answersLogoWhite

0


Best Answer

For large worksheets that print on multiple pages, they will allow for a standard heading on them and the possibility of other details, such as page numbers on them. A printed header and footer does not actually appear on the worksheet itself. Any headings for that purpose must be put into cells on the worksheet.

User Avatar

Wiki User

6y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

They are not essential to have. If a worksheet is being printed, you can have them in order to show some information. Included in the footer might be the page number, the total number of pages, the name of the worksheet or workbook, the date and time and other information that the user might want to put in themselves. In the header there might be information about the document, in the form of a main heading. The header and footer details will appear on all printed pages, which can save the user having to put some of this information directly onto the sheet. Quiet often a worksheet will not make use of headers and footers. It is the choice of the user.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are the Importance of headers and footers in a worksheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you create page numbers in Microsoft Excel?

Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.Go to the View menu and then to Headers and Footers. Page numbers can be added there.


Do headers and footers offer any advantages over adding the information within the worksheet cells?

Yes. You are guaranteed that the data will appear at the top and bottom of every page, which is what you want to do if you are using headers and footers. You can be assured of their positions on the printed page, which isn't always the case with worksheet cells. The size of the fonts may change or rows may be added or removed, which would change the position of the worksheet cells. If you wanted to put text onto every page, only using cells, you would have to put data in multiple times. With headers and footers, it only needs to be put in once to appear on every page. Headers and footers have special facilities such as being able to determine the number of the page or the name of the workbook or worksheet being printed, which can be added in so that they appear on every page.


In which view do headers and footers NOT display?

The correct answer is Draft View. In this view graphics, headers and footers are not displayed.


What are headers and footers in ms PowerPoint?

Headers are at the top and footers are at the bottom of a page. They contain text or images that appear on every slide.


Can use Headers in Microsoft Excel?

Yes you can use headers in Excel. You can also use footers. Like in any kind of printed document, there is a margin area in which headers and footers can be used.


Does WordPad have header and footer?

WordPad does not allow headers and footers. Check out this word processor: http://www.jarte.com/ You can define headers and footers in the Page Setup.


Why are headers and footers not required in a business document?

Sometimes they are. Headers and footers are used to convey information. If you write a contract or proposal, you probably want page numbers on each page, so you can identify where to find information. Headers and footers are not exclusive to academic writing.


The object that creates a professional printout of a data that includes headers footers and graphics?

The object that creates a professional printout of data that includes headers, footers, and graphics is the


How do you get headers and footers on a Word pad document?

WordPad does not have headers and footers. WordPad is not a full word processor so it lacks some features that you will find in a word processor.


How do you change the worksheet header with your name course number in Excel?

Go to Headers and Footers and pick Custom header. You can then make the adjustments you need and type in the name and course number you want.


Do headers and footers work the same in both excel and word?

no


How do you put a xat chat box on your proboards?

Yay!! nother fellow xat user!! go to your headers and footers, then global headers and footers, and put it in your footer. and put some center codes around it too