Step 5: Click inside the region of the page where you want the header to appear, enter the text that you want to include in the header, then click the OK button. Step 4: Click the Customize Header button. Step 3: Click the Header & Footer button in the Page Setup section of the ribbon at the top of the window. Step 2: Click the Layout tab in the horizontal green bar at the top of the window. Step 1: Open your spreadsheet in Excel 2011. Once you have created the header, you can follow the same directions below if you need to edit it at all.
#ADD HEADER MICROSOFT EXCEL 2011 WINDOWS#
If you are on a Windows computer then you can read this article to add a header in Excel 2010. This tutorial is specifically for the 2011 version of Excel for the Mac. That’s why it is important to include a header at the top of your spreadsheets to make them easier to identify. You can sort your data into easily manageable rows and columns, and you can even use formulas to perform mathematical operations on that data.īut Excel can be a little difficult to work with when you need to print out your spreadsheets, and it can be even more difficult to remember what a specific spreadsheet is for when you have a lot of them. Check this out if you are a Word user.Excel spreadsheets are great for organizing data on a computer. Thus, it is also quick and easy to add a header to a Word document. Have fun customizing the top of your spreadsheets! Here, click "OK" to add your custom header to your spreadsheets.Īnd your selected worksheets now have your custom header specified. You will be back on the “Page Setup” box. If you want to add dynamic elements such as page numbers and dates, click the appropriate icons. Here, click on the left, middle, and right sections and specify the header content for each section. To specify a custom header, click the "Custom Header" button.Ī "Header" box will open. In the "Page Setup" dialog box, click the "Header/Footer" tab. In the “Layout” tab, in the lower right corner of the “Layout” section, click the arrow icon. While your spreadsheets are selected, in Excel's ribbon at the top, click the "Layout" tab. To do this, hold down the Shift key while you click each worksheet tab.
To add header to multiple worksheets at once, first launch your worksheet containing multiple worksheets in Excel.Īt the bottom of the worksheet, select the worksheets where you want to add a header.
#ADD HEADER MICROSOFT EXCEL 2011 HOW TO#
How to put a header on multiple worksheets To return to Excel's default view mode, in the ribbon at the top, click View > Normal. Likewise, if you want a different header for the first page, or different headers for odd and even pages, use the “Different First Page” and “Different Odd and Even Pages” options at the top. If you want to add dynamic content to your header, such as current page number or current date, then in Excel's ribbon at the top, click an appropriate option. To insert an “&” ampersand, tap the “&” key twice. Point: To add a line break, press Enter after a line. On the "Insert" tab, click Text > Header & Footer. In the Excel ribbon at the top, click on the "Insert" tab. In your spreadsheet, at the bottom, click the spreadsheet where you want to add a header. To add a header to your unique spreadsheet in Excel, first open your spreadsheet with Microsoft Excel. How to insert a header in a single worksheet So use the same steps below if you want to add a footer to your spreadsheets. Notes: Footers are added the same way as headers. Use this method if you want to add a header to multiple worksheets at once. The other way to use a header in Excel is to use the "Page Setup" dialog box.
If you are looking to add a header to a specific worksheet, use this method. One way to add a header in Excel is to use an option in the "Insert" tab.
0 kommentar(er)
