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
print titles

ResolvedVersion 2010

Martina has attended:
Excel Intermediate course

Print titles

How can I print a title on all pages?

RE: Print titles

Hi Martina, thanks for your query. You can either put the heading into the header of the spreadsheet itself, or force certain rows on the spreadsheet to appear on every page of the print, as here:

http://office.microsoft.com/en-us/excel-help/repeat-specific-rows-or-columns-on-every-printed-page-HA010243219.aspx

Hope this helps,

Anthony

Mon 28 May 2012: Automatically marked as resolved.

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

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.