Edit a Spreadsheet Layout

To modify an existing spreadsheet layout, follow these instructions:

Ribbon bar. Select the Format tab. In the Spreadsheet group, click Layouts to display the Spreadsheet Layouts dialog box.

Classic menus. From the Format menu, select Spreadsheet to display the Spreadsheet Layouts dialog box.

Procedure

  1. In the Spreadsheet Layouts dialog box, select the spreadsheet layout that you want to modify, and click the Edit button.
  2. In the Edit Spreadsheet Layout dialog box, select the Format you want to edit.
  3. Click the Edit button to display the Edit Format dialog box, and make the desired changes to the formats of the spreadsheet layout.
  4. Click the OK button to return to the Edit Spreadsheet Layout dialog box, and make any desired changes to the format.
  5. When you have made the desired formatting changes to the spreadsheet layout, click OK.
  6. Click Close in the Spreadsheet Layouts dialog box to return to the active spreadsheet.