How to Print a Long And Narrow Excel Table

Date:2021-1-22 Author:Sandra

Have you ever printed a long and narrow Excel sheet? It may takes a lot of paper to print such a form, but you will find it wasteful. Because most part of a piece of paper is blank. So today, the author will share you a useful method to print this kind of sheet.

How to Print a Long And Narrow Excel Table
How to Print a Long And Narrow Excel Table

Step 1: Copy the Form to Word Document

Press Ctrl and A to select all the forms and press Ctrl and C key to copy it. Then press Ctrl and V together to paste into a Word Document.

How to Print a Long And Narrow Excel Table
How to Print a Long And Narrow Excel Table

Step 2: Set Columns

The table we just pasted is too long, we can set it into two columns.

How to Print a Long And Narrow Excel Table
How to Print a Long And Narrow Excel Table

Step 3: Repeat the Header Rows

You need to highlight the title table and go to Layout to choose Date. Click on the Repeat Header Rows.

How to Print a Long And Narrow Excel Table
How to Print a Long And Narrow Excel Table

Now, you can go to Print to review the real print effect. The long Excel sheet have been fitted on one page.

How to Print a Long And Narrow Excel Table
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *