Chapter 4: Borders and colors
Exercise 17: Color only the input cells
Task
Fill the input cells of the form (B2:B5) with light yellow so people know where to type.
Moves 0 (target 1)4 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Input | |
| 2 | Name | ||
| 3 | Department | ||
| 4 | Date | ||
| 5 | Amount | ||
| 6 | |||
| 7 |
Fill the input cells of the form (B2:B5) with light yellow so people know where to type.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B5
- Home > Fill Color: light yellow (Alt → H → H)
Key takeaway
Coloring only the input cells prevents missed entries and overwritten formulas.
See How to add borders for details.