| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove white space in print preview
Excel 2007 - I am having a problem where I have multiple cells with
paragraphs of data in them. When I am working in the cell it shows the last line of data to match up with the bottom of the cell. However, when I go to print preview it shows a large amount of white space from my last line of data to the end of the cell. The white space shouldn't be there. I made sure I don't have any extra returns or spaces after my last word and punctuation mark. Any thoughts? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove white space in print preview
Try :
=CLEAN(TRIM(your cell)) Regards. Daniel Excel 2007 - I am having a problem where I have multiple cells with paragraphs of data in them. When I am working in the cell it shows the last line of data to match up with the bottom of the cell. However, when I go to print preview it shows a large amount of white space from my last line of data to the end of the cell. The white space shouldn't be there. I made sure I don't have any extra returns or spaces after my last word and punctuation mark. Any thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting rid of white space for printing | Excel Discussion (Misc queries) | |||
| white space deletion | Excel Worksheet Functions | |||
| How do I remove white space around a chart? | Charts and Charting in Excel | |||
| White Space in a Cell | New Users to Excel | |||
| White Space in PDF from Excel | Excel Discussion (Misc queries) | |||
Linear Mode
