Chapter 7 Use Alt for column widths, borders and view settings ・ MISSION 34

Mission 34: Draw borders across the table

📋 Mission list

Keycat

Draw grid borders for all cells in the table (A1-C5).

FileHomeInsertPage LayoutFormulasDataReviewViewPress and release Alt for key hints.
Keystrokes 0/ Best example: 5

Chapter 7 ・ MISSION 34

Draw borders across the table

Draw grid borders for all cells in the table (A1-C5).

Now
Goal

The tutorial is On. You can change this setting on the mission list page. Mission list

Shortcuts used in this mission

  1. CtrlA
  2. →Alt
  3. →H
  4. →B
  5. →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.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).