Printing tricks

November 18, 2021

Print the entire Excel Table in one sheet

1. Click on file tab

2. Select Print (Or directly use the shortcut CTRL+P)

3. Click on Scaling Option (Last option under Settings)

4. There are 3 options

a. Fit Sheet on one page: Entire data is printed in one page

b. Fit all columns on one page: All column headers are in one page

c. Fit all rows on one page: All row headers are in one page

Repeat Table Header Rows on Every Printed Page

While printing an excel table we notice that only the first page has the column titles at the top. But we need the table headers on each of the printed pages. How do we do this?

1. Open the worksheet that you're going to print.

2. Switch to the PAGE LAYOUT tab.

3. Click on Print Titles in the Page Setup group.

4. Make sure that you're on the Sheet tab of the Page Setup dialog box.

5. Find Rows to repeat at top in the Print titles section.

6. Click the Collapse Dialog icon next to "Rows to repeat at top" field.

7. The Page Setup dialog window is minimized and you get back to the worksheet. You can notice that the cursor changes to the black arrow. It helps to choose an entire row with one click.

8. Select a row or several rows that you want to print on every page. Note: To select several rows, click on the first row, press and hold the mouse button and drag to the last row you want to select.

9. Click Enter or the Collapse Dialog button again to return to the Page Setup dialog box.

10.Now your selection displays in the Rows to repeat at top field.

Note: You can skip steps 6-8 and enter the range using the keyboard. However, pay attention to the way you enter it - you need to use the absolute reference (with the dollar sign $). For example, if you want to see the first row on every printed page, the reference should look like this: $1:$1.

11. Click on Print Preview to see the result.

Contributor: Siddhi Mukim

Ever since preparing for her CFA Examinations, Siddhi Mukim has been working with Aswini as she firmly believes that practical learning and experience on the field is most vital.Post completing her CFA , She has been handling his Consulting and Training Department.