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

excel training course london - column headings

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course london - Column headings

excel training course london - Column headings

ResolvedVersion Standard

Column headings

how do I keep column headings showing on several pages of spreadsheets?

RE: column headings

Hi Rossana

To print column headings showing up when you print a big spreadsheet, go to File - Page Setup - Sheet, then use the Print titles area to select the columns you wish to have repeated at the left of each page when the spreadsheet prints. You can also select rows to repeat at the top of each page as well. Then click OK.

If you have a look in Print Preview once you have set up Print titles then you should see the same information repeated at the left and/or the top of each page.

I hope this answers your question - if not, please reply then I can get back to you on this again.

thanks
Amanda

Excel tip:

Removing border lines on the keyboard

Highlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines.

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