excel training course london - column headings

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

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

excel training course london - Column headings

resolvedResolved · Low Priority · Version 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:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


Server loaded in 0.08 secs.