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

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?

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

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 ViewPage Break PreView can you drag the blue line up or down?


Gord Dibben MS Excel MVP


On Wed, 15 Aug 2007 15:20:00 -0700, Jewels
wrote:

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?

How do I add a page to my spreadsheet in 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

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

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

"Shane" wrote in message ups.com...
| 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
|

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

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)

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

I just learned a new trick.

Thanks Shane.


Gord Dibben MS Excel MVP

On Thu, 16 Aug 2007 14:47:03 -0000, Shane wrote:

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)

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

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
|
| On Thu, 16 Aug 2007 14:47:03 -0000, Shane wrote:
|
| 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)
|

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

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


Gord

On Thu, 16 Aug 2007 17:47:22 +0200, "Niek Otten" wrote:

Same for me!

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

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



"Gord Dibben" wrote:

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


Gord

On Thu, 16 Aug 2007 17:47:22 +0200, "Niek Otten" wrote:

Same for me!