logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
Excel vs Tableau
November 11, 2021
Circular Referencing Solution
November 25, 2021

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)

3

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

1

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

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.

5

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.

6

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.

7

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

8

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.

9

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.
Picture1
Share
0

Related posts

December 16, 2021

Stacking in EXCEL


Read more
December 9, 2021

SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW


Read more
November 25, 2021

Circular Referencing Solution


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'