• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips

Excel 2010

How to change starting page number in Excel 2010

July 19, 2012 By Ravi Shankar Leave a Comment

This post is in reply to the query posted by a reader that

My footer is starting with zero. Why?
I want it to start with one.

Excel 2010 footer page number by default starts with number 1and you can change the starting page number using the Page Setup option.

Step 1: Click the File menu and navigate to Print option.

image

Step 2: In the Print screen, click the Page Setup link available at the bottom.

Step 3: This would display the following Page Setup window.

image

Enter the starting page number for you footer in the First page number field. If you want to have the default behavior then keep the value as auto.

Step 4: Click OK button to confirm and save the changes.

By this way you can customize the starting page number in Excel 2010.

del.icio.us Tags: Excel 2010,starting,page number,first page number,change

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: Change, Excel 2010, first page number, Page Number, starting

How to hide header/footer while typing in Excel 2010

February 7, 2012 By Ravi Shankar Leave a Comment

This is in response to question asked by a reader of this blog related with header and footer in Excel 2010.

how do I make the header / footer not visible on the page while typing?

When you click on the insert header and footer option in Excel 2010, excel would immediately change the view to Page Layout. Hence you would see the newly added header and footer in your worksheet.

image

After typing the required header and footer details and do not want to see header and footer while typing you excel sheet in the data section then you can change the view to Normal by selecting Normal under the Workbook Views section.

image

This would temporarily hide the inserted header and footer in the Worksheet and you can always get it back by changing the Workbook view to Page Layout.

del.icio.us Tags: Excel 2010,Header,Footer,Hide,Workbook,Worksheet,Views,Normal,Page Layout

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: Excel 2010, Footer, Header, hide, Normal, Page Layout, Views, Workbook, Worksheet

  1. Pages:
  2. «
  3. 1
  4. 2
  5. 3
« Previous Page

Primary Sidebar

TwitterLinkedin

Recent Posts

  • How to set preferred Wifi network on Mac
  • Attribute Unavailable: Estimated section warning before iOS 11.0
  • How to recover Firefox password from Time Machine backup
  • Show hidden files and folders on Mac
  • How to request a refund for apps in App Store

Pages

  • About
  • Privacy Policy
  • Terms and Conditions

Copyright 2022 © rshankar.com

Terms and Conditions - Privacy Policy