Results 1 to 3 of 3

Thread: How to put formula in Text Box in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    54

    How to put formula in Text Box in Microsoft Excel

    I have a chart that I added a text box which I would like to reference a cell which contains a formula. Suppose cell c25 contains the formula =sum(C2:C23). Is it possible for the text box to reference cell c25.

  2. #2
    Join Date
    Jun 2011
    Posts
    798

    Re: How to put formula in Text Box in Microsoft Excel

    A text box from the control toolbox has a linked cell property and will display the contents of the linked cell. I do not think you can add or use a formula or cell reference in that. This might be not possible.

  3. #3
    Join Date
    Jun 2011
    Posts
    635

    Re: How to put formula in Text Box in Microsoft Excel

    It is possible. You can link a cell to text box in excel. All you need to do is insert a text box. Do not click inside it. Just choose the box and press F2. Then choose a cell reference. That's all. The text box is no linked to the cell.

Similar Threads

  1. Looking for formula that can ignore text values in Excel
    By Henriksen in forum MS Office Support
    Replies: 3
    Last Post: 23-02-2012, 07:20 PM
  2. How to normalize a data formula in Microsoft Excel
    By Purujeet in forum MS Office Support
    Replies: 2
    Last Post: 16-02-2012, 08:01 PM
  3. Convert copy formula to Text in Microsoft Excel
    By Kaesav in forum MS Office Support
    Replies: 2
    Last Post: 01-02-2012, 07:39 PM
  4. Formula for tracking annual leave in Microsoft Excel
    By Kungfu Pandey in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 05:29 PM
  5. Text not visible in cell only in Formula Bar (excel 2003)
    By NavinS in forum MS Office Support
    Replies: 1
    Last Post: 14-02-2008, 03:32 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,642,720,867.37182 seconds with 17 queries