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.
