How do I add a page to my spreadsheet in excel?

[Jewels]

I am using Microsoft office excel 2003. I do not know how to create a 2nd
page on my spreadsheet? I tried using page break but that is not working for
me?

 

[Gord Dibben]

What do you consider as a "page"?

A printed page or a new worksheet?

What is not working with page break?

Have you got a print range set?

When in View>Page Break PreView can you drag the blue line up or down?


Gord Dibben MS Excel MVP

 

[Shane]

If you want to have a seperate page to print you can select the area
that you want add, right click and select the "Add to print area". If
there is no print area you can "Set Print Area". I hope that helps

Shane

 

[Niek Otten]

Hi Shane,

I don't know that option and it's not in any of my Excel versions. Are you sure this isn't from an add-in?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| If you want to have a seperate page to print you can select the area
| that you want add, right click and select the "Add to print area". If
| there is no print area you can "Set Print Area". I hope that helps
|
| Shane
|

 

[Shane]

Sorry, you need to have view set to 'Page Break Preview', then you can
select an area, right click and add it to the print area. (My
secretary showed me how to do it)

 

[Gord Dibben]

I just learned a new trick.

Thanks Shane.


Gord Dibben MS Excel MVP

 

[Niek Otten]

Same for me!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gord Dibben" <gorddibbATshawDOTca> wrote in message |I just learned a new trick.
|
| Thanks Shane.
|
|
| Gord Dibben MS Excel MVP
|
|
| >Sorry, you need to have view set to 'Page Break Preview', then you can
| >select an area, right click and add it to the print area. (My
| >secretary showed me how to do it)
|

 

[Gord Dibben]

Now, the next trick will be remembering this trick<g>


Gord

 

[aneasiertomorrow]

That's magic. I'll be adding it to my excel tips & tricks session for sure.

Lucy
--
MOS Master Instructor
www.aneasiertomorrow.com.au

PowerPoint Live 2007 28-31 October in New Orleans www.pptlive.com
See you there