Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Overwriting next empty cell
Can anybody tell me if there is a way of switching off the fact that when
writing into a cell and the text goes past the column width the text will spill over onto the next cell to the right if it is blank? I know about Wrapping text but this cuts the text off at each new word which is not what I want. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Overwriting next empty cell
If you put something in that adjacent cell, it'll stop that overlap.
You can use an apostrophe ('), a spacebar ( ). But I like to use a formula: ="" It's easier to notice and weird enough to remind me why I did it. Is this a stupid Question? wrote: Can anybody tell me if there is a way of switching off the fact that when writing into a cell and the text goes past the column width the text will spill over onto the next cell to the right if it is blank? I know about Wrapping text but this cuts the text off at each new word which is not what I want. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Overwriting next empty cell
Click on the top left hand corner of your worksheet to select the whole sheet. Right click on the worksheet and select 'Format Cells'. Select the 'Vertical text alignment to 'Justify' and then OK. Select the whole of your worksheet once more. Select 'Format' from the top tool bar & select 'Row' then 'Height'. Set the row height to 12.75 which is standard or anything you like. This will contain the text whithin the cell without overlapping or word wrapping. I'm using Excel 97 but i'm sure its the same for later versions. Hope this helps -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=561045 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |