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

Mission 33: Add a top border and a thick bottom border to the total row

📋 Mission list
FileHomeInsertPage LayoutFormulasDataReviewViewPress and release Alt for key hints.

Keycat

Apply a top border and a thick bottom border to the total in row 6.

Keystrokes 0/ Best example: 5

Chapter 7 ・ MISSION 33

Add a top border and a thick bottom border to the total row

Apply a top border and a thick bottom border to the total in row 6.

Now
Goal

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

Shortcuts used in this mission

  1. ShiftSpace
  2. →Alt
  3. →H
  4. →B
  5. →C

Alt → H → B → C applies a top border and a thick bottom border, often used for totals in financial and KPI tables.

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.