Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel intermediate

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

Excel Intermediate

ResolvedVersion 2010

Mainul has attended:
Excel Introduction course
Excel Intermediate course

Excel Intermediate

How do i change the default page number set up while trying to print out a large worksheet?

RE: Excel Intermediate

Hi Mainul,

Thank you for your question. The best way to change the page numbering in Excel is to view Excel in Page Layout view. Simply click View, Page Layout. When you click in one of the header or footer boxes (top or bottom of page), you will see the Header and Footer ribbon. Here, you can set the page numbering. You can decide which box contains the number, how the number displays and set a different first page. You can even tell Excel to run different headers and footers on odd and even pages.

One example of how you can display page numbers in Excel is to set it up to show "Page 1 of 20". To do this, click in a header or footer box, then type Page followed by a space. Now, click the Page Number button in the ribbon. Next type of, followed by another space. Lastly, click the Number of Pages button in the ribbon. It should now display as Page 1 of 1.

I hope this is helpful.

Kind regards
Marius Barnard
Excel Trainer

RE: Excel Intermediate

Thank you for your response. But that does not answer my query. What I want to know is while printing a large spreadsheet lets say through page breaking i made six pages. Now what excel does is while printing excel automatically selects the bottom part as page 2 rather then the one one the right hand side. How do i change this default setting? I will appreciate if trainer Doug can answer this, he showed it in the class how to do it?

Many thanx.

RE: Excel Intermediate

Hi Mainual

Sorry for late response. Yes I remember showing you this. You can change the order to 'over then down' rather than the normal 'down then over' as follows:

1. Select File, Print

2. Click the Page Setup link then the Sheet tab

3. At the bottom of dialog box choose Over the Down

You can check the order has worked by viewing in Page Break Preview.

Hope that answers your printing query.

Regards
Doug
Best STL

Tue 5 Apr 2016: Automatically marked as resolved.

Excel tip:

Get back to active cell

If you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back

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.