Page Setup
For this worksheet, set the page margins to wide and the orientation to landscape.
- Click the Page Layout tab
- In the Page Setup group, click the Margins drop-down arrow
- Click Wide
- In the Page Setup group, click the Orientation drop-down arrow
- Click Landscape
Row Height & Column Width
On the current worksheet, set the row height for row 2 to 30 and the width of columns F and G to 12.
- Click the number 2 in the rows to select the entire row
- Click the Home tab (if necessary)
- In the Cells group, click the Format drop-down arrow
- In the Cell Size section, click Row Height
- Type: 30
- Click the OK button
- Click and drag over the letters F and G to select columns F and G
- In the Cells group, click the Format drop-down arrow
- In the Cell Size section, click Column Width
- Type: 12
- Click the OK button
Headers & Footers
Add the file name as a header to the current worksheet. Then, add the current date to the left side of the footer.
- Click the Page Layout tab
- Click the Page Setup dialog box launcher
- Click the Header/Footer tab
- Click the Header drop-down arrow
- Click the file name (133-classes by month.xlsx)
- Click the Custom Footer button
- Ensure the cursor is in the Left section
- Click the Date icon
- Click the OK button twice