I have a workbook whcih contains a number of worksheets and charts. I need to add a text box to a chart but the text box icon is greyed out on the drawing toolbar, as are the other addition icons, line box etc. The icons are also greyed out on the non chart worksheets. Other workbooks do not...
A text box is not really suited for this, it only shows one value so you would have to concatenate all your cells values together which would look messy. Using a list box may be better. Put Excel into design mode and place a listbox on your worksheet, right click and select properties.
Is there a way to place multiple hyperlinks in a single text box? Every time I select some text to make into a hyperlink, it makes the entire text box the link. I have a long Excel workbook comprised of long text boxes for ease of alignment purposes. I'm using Excel instead of Word because...
I have a number of pivot tables which include sum of values. I need to display the total sum value field but in a text box. I have typed = into the text...
You can only reference the cell like that, but if the value of Data!B8 is x you change cell Data!B8 to this: ="Total: "&x, then with your text box selected press F2 key and type: =Data!B8 and press Enter.
Hi there. For some reason on one of my files the illustrations section on the insert tab is greyed out. I also can't insert a text box. This file is not locked or protected in any way. Would anyone know why this could happen?
I can use Insert - Text Box and draw text boxes all day long. But as soon as I start trying to enter text Excel crashes with "Microsoft Excel has stopped working." Interestingly enough, I can delete text from one of my older spreadsheets but as soon as I try typing anything new Excel crashes.
I want to use macro form to edit this data using form, like if i type no 3 in text box, automatically the details of "3" should come in 3 text box, and i will edit those text box and i want one command button to replace same value in main excel sheet.
