Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2007

Tue 8 Nov 2011, 16:05 Delegate Heather said...

Heather has attended:
Excel Introduction course
Excel Intermediate course
PowerPoint Intermediate Advanced course
Word Advanced course

Excel

Please can you explain how to fit a large spreadsheet onto one page and print without it going over various other pages.

Wed 9 Nov 2011, 14:44 Trainer Paul said...

RE: Excel

to fit a sheet onto one page select the print preview, choose page set up and select "fit to one page".

Alternatively go to your page break preview (3rd option to the left of the zoom bar on the bottom right hand of screen). Take your mouse and move the blue bars to the edge.

A large sheet may print in very small text.

Does that help?

Thanks
Paul

Wed 16 Nov 2011: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Hide data in Excel Worksheets