Produce customized worksheets that incorporate formatting changes:
Skills and concepts covered:
Freeze rows and columns
Cell colour fills
Add a cell colour → Use the select cursor to highlight the cells in the row to be filled with color → Move the cursor up into the ribbon to the fill icon with it has a paint bucket on it → Click the small triangle next to the paint bucket to see options for your colors → choose a cell color
Add a border → Highlight all of the cells with information in them → Go up into the ribbon to the left of the fill icon → Click the small triangle next to the border icon → Choose all borders
Freeze the first worksheet row → In the ribbon, click on the View tab → Find the Freeze Panes option → Click on it and see three options: Freeze the viewed area, the first row or the first column → Choose the first row option → Scroll up and down in the worksheet → The first row does not move → To undo that action, go back to the freeze pane option and select unfreeze pane.