• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

How to hide header/footer while typing in Excel 2010

February 7, 2012 by Admin 2 Comments

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

Reader Interactions

Comments

  1. Tim says

    July 7, 2016 at 10:18 am

    There is another way to show/hide the header/footer while in Page Layout view:
    If you position your cursor above the white sheet, an option to ‘Hide white space’ pops up, with an opposing arrows icon (or ‘Show white space’ if its already hidden). You can toggle the header/footer on and off.
    Took me a while to find that, after opening a file that had hidden the white space! I’m not aware of a check-box option to perform the same function.

    Reply

Trackbacks

  1. How to hide row and column headers in Excel says:
    November 10, 2014 at 9:24 am

    […] Also See: How to hide header/footer while typing in Excel 2010 […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel
  • How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide
  • How to increase number of worksheets Excel

blogmines.com Copyright © 2023