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

training excel vba - headers

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training excel vba - Headers

training excel vba - Headers

ResolvedVersion Standard

Cristina has attended:
Excel Introduction course

Headers

How do you include the headers on the second page, when your document uses up to pages?

RE: Headers

Hi Cristina

Go to FILE> Page Setup >Sheet tab

Then , under print titles, choose ROWS TO REPEAT AT TOP, and the click the rows that your headers are in.

Preview your page, to see if you have gort what you want.

regards

Richard

Excel tip:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

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.1 secs.