Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I display a cell range in a text box in excel?
I want to display the contents of a cell range in a text box. I know how to
put contents from one cell in a text box but I need to put the contents of 24 cells in my text box. Or how can I change the length and height of cells below other cells without changing the other cells length and height. Is there a way to put a line to freeze panes to change the length and height of cells below the line? |
#2
|
|||
|
|||
Would the '&' work for this problem. eg if A1 = "Pat" and B1 = "Hughes"
then the formula A1&B1 would return PatHughes, formula A1&" "&B1 would return Pat Hughes? To make the cell fit the text, without effecting other cells in the same column, then use Format Cells/Alignment/Wrap text. Although this will effect those in the same row. Hope this helps. Roger "Pat Hughes" wrote: I want to display the contents of a cell range in a text box. I know how to put contents from one cell in a text box but I need to put the contents of 24 cells in my text box. Or how can I change the length and height of cells below other cells without changing the other cells length and height. Is there a way to put a line to freeze panes to change the length and height of cells below the line? |
#3
|
|||
|
|||
Thanks for your reply Roger but when I tried your suggestiong they didn't
work. I have a box of 24 cells that I want to put at the bottom of a phone list but that has different sized cells as the phone list. I thought if I could copy and paste into a text box I could move it where I wanted and not have to change the format of the size of cells for the phone list. I see where this could be a great way to change the cell sizes of certain cells without affecting the worksheet cell sizing. Thanks, Pat "RogerN" wrote: Would the '&' work for this problem. eg if A1 = "Pat" and B1 = "Hughes" then the formula A1&B1 would return PatHughes, formula A1&" "&B1 would return Pat Hughes? To make the cell fit the text, without effecting other cells in the same column, then use Format Cells/Alignment/Wrap text. Although this will effect those in the same row. Hope this helps. Roger "Pat Hughes" wrote: I want to display the contents of a cell range in a text box. I know how to put contents from one cell in a text box but I need to put the contents of 24 cells in my text box. Or how can I change the length and height of cells below other cells without changing the other cells length and height. Is there a way to put a line to freeze panes to change the length and height of cells below the line? |
#4
|
|||
|
|||
Pat
Sorry but the only way I can think to do this is to create a text box and then copy the contents of each cell into it one at a time. I am not good enough at macros to know if this could be automated. Hopefully, someone else can help. Roger "Pat Hughes" wrote: Thanks for your reply Roger but when I tried your suggestiong they didn't work. I have a box of 24 cells that I want to put at the bottom of a phone list but that has different sized cells as the phone list. I thought if I could copy and paste into a text box I could move it where I wanted and not have to change the format of the size of cells for the phone list. I see where this could be a great way to change the cell sizes of certain cells without affecting the worksheet cell sizing. Thanks, Pat "RogerN" wrote: Would the '&' work for this problem. eg if A1 = "Pat" and B1 = "Hughes" then the formula A1&B1 would return PatHughes, formula A1&" "&B1 would return Pat Hughes? To make the cell fit the text, without effecting other cells in the same column, then use Format Cells/Alignment/Wrap text. Although this will effect those in the same row. Hope this helps. Roger "Pat Hughes" wrote: I want to display the contents of a cell range in a text box. I know how to put contents from one cell in a text box but I need to put the contents of 24 cells in my text box. Or how can I change the length and height of cells below other cells without changing the other cells length and height. Is there a way to put a line to freeze panes to change the length and height of cells below the line? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Excel 2000 Cell Capacity and Data Display | Excel Discussion (Misc queries) | |||
Display ALL text contents in cell | Excel Discussion (Misc queries) | |||
Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions |