Excel How to Print Column and Row Headers

Romeo Costillas
Romeo Costillas
1.4 هزار بار بازدید - 5 سال پیش - Excel How to Print Column
Excel How to Print Column and Row Headers

Repeat specific rows or columns on every printed page

1. Select the worksheet that you want to print
2. Go to Page Layout menu
3. Click Print Titles, under Page Setup group
4. On the Sheet tab, under Print titles, do one or both of the following.

4.1 To repeat row headers only:
In the Rows to repeat at top, click the Collapse Popup window button at the right end of the field then select the row/s that you want to repeat

4.2 To repeat column headers only:
In the Columns to repeat at left, click the Collapse Popup window button at the right end of the field then select the column/s that you want to repeat

4.3 To repeat row and column headers, apply step 4.1 and 4.2.


No matter your title, people will not follow you if they don't trust you.
- John C. Maxwell

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:
@romeocostillas

YouTube Playlist:
Excel Keyboard Shortcut Control Combi...

Or visit me on Facebook at Facebook: ExcelbyRomeoCostillas

See you there!


Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert


"To EXCEL in the workplace, one must know how to use excel!"
- Romeo

Tagalog Excel | Filipino | Pinoy Excel | Excel Tutorial | Excel Tagalog Tutorial

#excel #microsoftexcel #excelbyromeocostillas #excelonline #exceltraining #excelfreetraining #excelmasterclass #tagalogexcel #excelpinoy
5 سال پیش در تاریخ 1398/10/25 منتشر شده است.
1,446 بـار بازدید شده
... بیشتر