If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Text in formula bar is not displaying in cell | Mike | General Discussion | 0 | August 29th, 2005 09:47 PM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Help inserting a Cell Value in a Text Cell | Dave | Worksheet Functions | 5 | March 5th, 2005 09:06 PM |
Concatenatd fields in a query for a searching form | Marc | Running & Setting Up Queries | 8 | October 19th, 2004 08:49 PM |