Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel training course - print header

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Print Header

excel training course - Print Header

ResolvedVersion Standard

David has attended:
Excel Intermediate course

Print Header

How does one have the first row of the excel page print on the every page that is printed?

RE: Print Header

Hi David

To keep the row or column heading to stay on the page the answer is in the File Menu and down to Page Setup, you have to go across to the Sheet tab. There is an option in there which says print titles "Rows to repeat and the Top" or "Columns to repeat at the left".

Click in the red arrow which takes you into the spreadsheet and with your mouse drag the rows or columns you want kept on your page. From there you can do a print preview and check it is what you wanted then if it is, Press OK !

Hope this helps

Tracy

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.