How to prevent the text from cells to spill over adjacent cells? I know i can use "wrap text" but it changes the height of the cells and i don't want to change the cells size. I just want to hide the text that is over the cell border.
Thanks!
Last edited by emil9216; 10-30-2011 at 01:14 PM.
One way to do this is to put a space character into the cell on the right hand side.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks