On the Insert tab in the Text group, click Header & Footer this displays the spreadsheet in page layout view.
Select the spreadsheet for which you want to add headers or footers.
How to add and remove headers and footers: Simply put, they make calculations, graphs, and pivot tables much easier to read and follow. Headers and footers are useful in providing quick information about your document or data in a predictable format and also help set out different parts of a document. They often contain descriptive text such as titles, dates, or page numbers displayed in page layout views and on printed pages. What are headers and footers?Īs with Word, Headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in an Excel spreadsheet. So let’s see what they are and how adding them to your spreadsheet can help make your data even easier to read. While Excel creates charts and tables to make information easier to read, there’s a function that most users tend to forget, or are unaware of – headers and footers. Most business users are familiar with using work applications like Microsoft Excel.
0 kommentar(er)
