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