Formatting

Resolved · Low Priority · Version 2003

Mon 14 Jul 2008, 16:42 Delegate Carol said...

Carol has attended:
Excel Introduction course
Excel Introduction course

Formatting

how do you set up a second set of headings on a second page of the spread sheet?

Tue 15 Jul 2008, 13:08 Edited on Tue 15 Jul 2008, 13:09 Trainer Pete said...

RE: formatting

Hi Carol, Thank you for your post and if it hasn't been said before, welcome to the forum.

In answer to your question, I am assuming that you are looking to repeat headings, either column or row or perhaps both,

This can only be accomplished from the File>Page Setup menu option;

Click on the Sheet tab.
Under Rows to repeat at top or Columns to repeat at left, select the required columns and/or rows.
Click OK.

Now on each page of your printed work you will have the selected Column/Row headings.

I hope that has helped, regards Pete

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips

Formatting

Formatting

RE: formatting

Excel articles

Excel tip:

Formst Excel to display leading zeroes