This will put the formula & into the space. Put the cursor in the Left, Center or Right sections and and select the icon that looks like a spreadsheet with multiple tabs at the bottom.Choose Custom Header or Custom Footer, depending on where you want the sheet name to appear.Go to the Page Layout, Page Setup menu and click the Header/Footer tab.This will apply the footer to all the sheets at once so that you don’t have to set each sheet individually. Start on the first worksheet, and highlight all the others by holding the control button and clicking each sheet name.To include the worksheet name on every sheet: Have you ever printed an excel file with multiple tabs or worksheets, only to find you can’t tell which page came from which worksheet? There are several ways to solve this one, but the easiest is to just put the worksheet name in the header or footer, so that when you print the file, each page indicates the sheet it came from.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |