Home |
Search |
Today's Posts |
#1
|
|||
|
|||
text to appear at top of cell
in every cell I am tapping Alt and return so all the text appears in one box
when the box is filled i manually drag the box down so all text is diaplayed rather half of it 1. Is there a shortcut way to apply this to all cells so that the text will display in one cell automatically in all cells and it automaitcally returns down so all text is diaplayes 2. When doing this in all cells the text displays in the bottom how can i set it so the text displays in the top |
#2
|
|||
|
|||
Hit ctrl-a (twice in xl2003) to select all the cells.
Then Format|Row|Autofit (You could also just select the rows you want to use first, instead of all the rows.) jenniss wrote: in every cell I am tapping Alt and return so all the text appears in one box when the box is filled i manually drag the box down so all text is diaplayed rather half of it 1. Is there a shortcut way to apply this to all cells so that the text will display in one cell automatically in all cells and it automaitcally returns down so all text is diaplayes 2. When doing this in all cells the text displays in the bottom how can i set it so the text displays in the top -- Dave Peterson |
#3
|
|||
|
|||
Thank you very much
for some reason it is not applying to all of cell A but thats life however the writing is still appearing at the bottom of the box rather than the top "Dave Peterson" wrote: Hit ctrl-a (twice in xl2003) to select all the cells. Then Format|Row|Autofit (You could also just select the rows you want to use first, instead of all the rows.) jenniss wrote: in every cell I am tapping Alt and return so all the text appears in one box when the box is filled i manually drag the box down so all text is diaplayed rather half of it 1. Is there a shortcut way to apply this to all cells so that the text will display in one cell automatically in all cells and it automaitcally returns down so all text is diaplayes 2. When doing this in all cells the text displays in the bottom how can i set it so the text displays in the top -- Dave Peterson |
#4
|
|||
|
|||
hi,
Formatcellsalingnment tabvertical box. set to top Regards FSt1 "jenniss" wrote: Thank you very much for some reason it is not applying to all of cell A but thats life however the writing is still appearing at the bottom of the box rather than the top "Dave Peterson" wrote: Hit ctrl-a (twice in xl2003) to select all the cells. Then Format|Row|Autofit (You could also just select the rows you want to use first, instead of all the rows.) jenniss wrote: in every cell I am tapping Alt and return so all the text appears in one box when the box is filled i manually drag the box down so all text is diaplayed rather half of it 1. Is there a shortcut way to apply this to all cells so that the text will display in one cell automatically in all cells and it automaitcally returns down so all text is diaplayes 2. When doing this in all cells the text displays in the bottom how can i set it so the text displays in the top -- Dave Peterson |
#5
|
|||
|
|||
you need this....easy learning I got a lot of my begginer help on this site... cool They teach you by making a, Time sheet, Invoice and cheek book from scratch on Windows media Player very cool www.MDOTutorials.com -- Route2391 ------------------------------------------------------------------------ Route2391's Profile: http://www.excelforum.com/member.php...o&userid=26774 View this thread: http://www.excelforum.com/showthread...hreadid=394608 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
Moving text from one cell to another. | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Forcing text onto new line in cell | New Users to Excel |