To create a new sheet, click the + at the bottom of the active worksheet. Then, right-click the new tab, select Rename, and type a name for your sheet like Index or Worksheets. You can rearrange sheets by dragging their tabs left or right at the bottom of your workbook.
To quickly populate the page numbers, type the first two page numbers into A2 and A3, click A3 to select it, and then drag the square at A3’s bottom-right corner down until you’ve reached the number of pages in your workbook. Then, click the small icon with a + that appears at the bottom-right corner of the column and select Fill Series.
Go to File > Save. On the pop-up message that warns you about saving a macro-free workbook, click No. In the “Save as type” or file format menu, select Excel Macro-Enabled Workbook (*. xlsm) and click Save.
Don’t worry if the field already contains a cell address.
Don’t worry if the field already contains a cell address.
Don’t worry if the field already contains a cell address.
You might need to drag the corner of the shape to resize it so the text fits. To place a text box on or near the shape before typing, just click the Shape Format menu at the top (while the shape is selected), click Text Box in the toolbar, and then click and drag a text box. You can stylize the text using the options in Text on the toolbar while the shape is selected.
