Excel is Cutting Off Columns When Printing – 8 Solutions

This is the sample dataset.

Solutions for Not Cutting Off Columns When Printing in Excel

When trying to print the worksheet, two columns are moved to the 2nd page.


Solution 1 – Using the Page Setup Menu When Printing

  • Open your worksheet.
  • Go to the Page Layout >> click the Drop-Down arrow beside the Page Setup menu. You can also press ALT+P to go to Page Layout.

Using Page Setup Menu for not Cutting off Columns When Printing

  • In Print, choose Narrow Margins and Fit Sheet on One Page.

This is the output.

Result for Solution of Excel Cutting off Columns When Printing

Read More: [Fixed!] Cutting Off Text When Printing in Excel


Solution 2 – Using the Size Feature

  • Open your worksheet.
  • In Page Layout  >> go to Size >> Choose a page size. Here, A3 to keep all the columns on one page.

Employing Size Feature as Solution for not Cutting off Columns When Printing

This is the output.


Solution 3 – Use the Print Area Command

  • Open your worksheet.
  • Select the data. Here, B2:G25.
  • In Page Layout  >> go to Print Area >> choose Set Print Area.
  • Click the Drop-Down Arrow.

Use of Print Area Command as Solution for not Cutting off Columns When Printing

  • In Page Setup, select Page.
  • Click Fit to.
  • Click OK.

This is the output.

Read More: How to Print Excel Sheet in A4 Size


Solution 4 – Applying the Scale to Fit Group

  • Open your worksheet.
  • In Page Layout >> click on the Drop-Down Arrow beside Scale to Fit.

Applying Scale to Fit Group As Solution for not Cutting off Columns When Printing

  • In Page Setup, go to Page.
  • Click Fit to.
  • Click OK.

This is the output.

Read More: How to Print Excel Sheet in Full Page


Solution 5 – Applying the Page Break Preview Option

  • Go to the View tab.
  • Select Page Break Preview.

Employing Page Break Preview Option as Solution for not Cutting off Columns When Printing

Blue lines will be displayed showing the page border limits. The dotted Blue line is the page break.

  • Place the Mouse cursor on the dotted Blue line.
  • Drag it to the last column.

This is the output.

If you print the sheet, you will have all columns.

Read More: How to Print Multiple Sheets in Excel


Solution 6 – Changing the Column Width

  • Go to the border line of a Column. You will see the following Mouse Cursor.
  • Move the Mouse Cursor to decrease the width of the column.

Change Column Width for not Cutting off Columns When Printing

This is the output.

Read More: How to Print Sheet on One Page in Excel


Solution 7 – Reducing Font Size

  • Select the data.
  • In the Home tab >> click Decrease Font Size. Here, Font Size 10.

Reducing Font Size for not Cutting off Columns When Printing

Reduce the font size of title (12) and subtitles (11).

This is the output.

Read More: Make Excel Spreadsheet Bigger When Printing


Solution 8 – Using the Orientation Command When Printing

  • Open your worksheet.
  • In Page Layout  >> go to Orientation>> choose Landscape.

Employing Orientation Command When Printing

The printed copy is still cutting off columns.

  • Go to the File tab.

  • Select Print.

  • In Print, from the Drop Down Arrow of No Scaling >> choose Fit All Columns on One Page.

This is the output.

Read More: How to Print Excel Spreadsheet on Multiple Pages


 Things to Remember

  • If you are using Office 365 version of Excel, you can simply go to the Print option and choose Fit All Columns on One Page.

Things to Remember for not Cutting off Columns When Printing


Download Practice Workbook

Download the practice workbook.


<< Go Back to Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Musiha Mahfuza Mukta
Musiha Mahfuza Mukta

Musiha Mahfuza Mukta is a marine engineer who loves exploring Excel and VBA programming. To her, programming is a time-saving tool for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B.Sc in Naval Architecture & Marine Engineering from BUET, she's shifted gears and now works as a content developer. In this role, she creates techy content exclusively focused on Excel... Read Full Bio

2 Comments
  1. What if column(s) display fine, but when printing (having adjusted to landscape, selected print all columns on one page, etc.) for some reason it just leaves off characters in some columns that have lots of stuff in them? The mystery is that the columns show as intended in Excel, but when printed it prints all the columns & in the correct format, but the columns with lots of data in them are truncated.

    Thanks for your time.

    • Hello Jack,

      It sounds like the issue might be related to column width, text wrapping, or the print driver settings. Here are a few things you can try:

      Check Cell Formatting: Make sure the affected columns have “Wrap Text” enabled (Home → Alignment → Wrap Text) so that all text is visible within the cell.
      Adjust Column Width: Try increasing the column width slightly to see if more text appears when printed.
      Print as PDF First: Sometimes, Excel prints differently than it appears on-screen. Try printing to a PDF file first to check if the issue persists.
      Use “Fit to Page” Carefully: If you’re scaling to fit all columns on one page, excessive compression may cause text truncation. Try adjusting scaling manually instead.
      Check Printer Settings: Ensure your printer is not set to “Shrink to Fit” or another option that might alter text rendering.
      Try a Different Font: Some fonts do not print as expected when scaled. Switching to a standard font like Arial or Calibri might help.

      Hope this helps! Let me know if the issue persists.

      Regards
      ExcelDemy

Leave a reply

ExcelDemy
Logo

Advanced Excel Exercises with Solutions PDF