Chapter 7 Use Alt for column widths, borders and view settings ・ MISSION 32
Mission 32: Draw borders across the table
FileHomeInsertPage LayoutFormulasDataReviewViewPress and release Alt for key hints.
Keycat
Draw grid borders for all cells in the table (A1-C5).
A1fxMetric
A
B
C
D
1
Metric
Actual
Target
2
Sales
520
500
3
Gross profit
180
170
4
Operating profit
62
60
5
Profit margin
12
12
6
7
8
Keystrokes 0/ Best example: 5
Chapter 7 ・ MISSION 32
Draw borders across the table
Draw grid borders for all cells in the table (A1-C5).
A
B
C
D
1
Metric
Actual
Target
2
Sales
520
500
3
Gross profit
180
170
4
Operating profit
62
60
5
Profit margin
12
12
6
A
B
C
D
1
Metric
Actual
Target
2
Sales
520
500
3
Gross profit
180
170
4
Operating profit
62
60
5
Profit margin
12
12
6
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- CtrlA
- →Alt
- →H
- →B
- →A
Alt → H → B → A applies All Borders, a useful way to format a table for a report.
This is an operation for the Windows version of Excel (the Mac version of Excel does not have ribbon key tips).
Practise individual shortcuts or check the shortcut reference here. Shortcut drillsExcel shortcut list
Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.