View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
grahammal grahammal is offline
external usenet poster
 
Posts: 1
Default 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