Computer FAQs & Tips

The scenario that I came across is, when I am working on a excel file which required to present in multiple page print out, I will need to keep showing every column on each page printed out. Ok, how do I achieve that?

In this post, I will show you how to get around it.

Say you have data similar to the Screenshot below

In printed out on A4 paper size, there will be 2 pages. Page 1 will include Task Item column, Page 2 will not inlcude Task Item column. Now follow steps below to get repeat print column

Setup up repeat print Column

1. From file menu, click on File > Page Setup
2. Page Setup dialog appears, select Sheet
   
3. Click on icon in the red box as shown above
4. When below dialog appear, move your cursor to select column you want to repeat in printed out
   
5. Press Enter or Click on button on the right hand side of above dialog
6. Now you are back to Page Setup dialog, Click OK to come back to your excel document
7. From file menu, click on File > Print Preview
8. Now you should see column is printing on both pages
   Page 1
   
   Page 2
   

Setup up repeat print Row

To setup for repeat print Row, just follow the same step except for step 2 you will need to chose Row instead of Column

Author: Manet Yim FAQ & Tip