Saturday, July 10, 2004

Excel: Text is cut off when printing or print previewing

Solution: Change the default font size in Excel

You are trying to print preview or print out a document in Excel, but the text is cut off along the cell’s border. You’ve tried Format > Row > Autofit, and Format > Cells > Alignment > Wrap Text, but alas, nothing works. There are hundreds of rows and you can’t bear the thought of manually resizing each row!

Fear not! There is a quick workaround to this painful and cumbersome task!

First you will need to find the default font size for the worksheet you are working in. To find this, manually change the font size of the worksheet and view it in print preview (this may take several tries before you land upon the right size). If you are viewing it in the default font size, you should be able to see all the text (even if it means increasing the font size - you would think that you would see less of the text if you increased the size since there was not enough room in the cell to begin with, but Excel will display the text at this font size properly).

Go to Tools > Options > General. Change the default font size to the font size that you want (the font size at which you can view the text).

Excel will then alert you to close out of Excel and re-open Excel in order to accept the new font size. Exit out of Excel entirely and then re-launch it.

Open up a new worksheet to verify that your new font size is now the default (i.e., the font size you had entered in the dialog box). Open the workbook which you want to print.
Copy everything you want to print in the worksheet and paste it (Ctrl + v) into the new worksheet with the new default font size. Now do a print preview. Everything should look fine. Save this workbook with the same file name as the original if you like.


Anonymous Bawa Singh said...

Awesome, thanks much

January 10, 2013 at 4:38 PM  
Anonymous Anonymous said...

Thank you! This worked like a charm ;)

April 18, 2013 at 5:44 AM  
Blogger Fernando Diaz said...

This worked for me! Thanks!

November 25, 2013 at 3:13 AM  
Blogger Fernando Diaz said...

Excellent! This worked for me.

November 25, 2013 at 3:13 AM  
Blogger kiran kumar said...


August 28, 2014 at 10:42 AM  
Blogger Jody Krazeise said...

I was wondering if there is a solution for when you are using a Pivot Table and it's cutting off text when printing. It shows up fine in the actual pivot table but when you go to print, it only displays some of the text.

August 11, 2015 at 2:19 PM  
Blogger Zy said...

Brilliant. Thank you!

January 26, 2016 at 7:47 AM  
Blogger Zoe Dt said...

creatingpdf form from excel online can be download on this very well website, this is a wonderful creatingpdf form from excel online, and There are only three steps to creatingpdf form from excel easily.

August 25, 2016 at 8:10 AM  
Anonymous Anonymous said...

Thank you so much. This is such a great trick! I spent so much time trying things, but you are awesome!

December 19, 2016 at 5:08 PM  
Anonymous Anonymous said...

Thank you very much!!

February 1, 2018 at 4:30 PM  

Post a Comment

<< Home