Check the Excel Essentials Course https//coursesxelpluscom/p/learnexcelessentialsQuickly learn how to insert header and footer information to your Exce 56Add the Sheet Name header element to the left header section, and the text Viewed On_ followed by the Current Date header element to the right header section Click cell A3 to deselect the header to view the resultsThe number of characters to extract is hardcoded as 255 In the Excel UI, you can't name a worksheet longer than 31 characters, but the file format itself permits worksheet names3 On the Design tab, in the Header & Footer Elements group, click Current Date to add the current date (or add the current time, file name, sheet name, etc) Result Note Excel uses codes in order to automatically update the header or footer as you change the workbook 4 You can also add information to the left and right part of the header
1
