📊Excel Shortcut

Apply Outside Border

Detailed guide to use "Apply Outside Border" in Excel

Shortcut Keys

The highlighted keys show where to press. Press the required keys together.

Windows

Ctrl
⇧
6

Windows shortcut: Ctrl+Shift+6

Mac

Ctrl
⇧
6

Mac shortcut: Ctrl+Shift+6

In Action

This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.

Auto-playing example
Active: B2Selection: B2Sheet: Sheet1Step 1/2

You can scroll the sheet horizontally

↶↷BIUGeneral
Name Box
B2
Formula Bar
fx1200000
◢
A
B
1
Metric
Value
2
Base
1200000
3
Rate
0.18
Sheet1
Ready100%

Basic Info

Category
Editing
Difficulty
★★★(Avancé)

How to Use

  1. 1Select the target cell/range if needed
  2. 2Press the highlighted keys shown above together
  3. 3Apply Outside Border is executed

Practice

Practice this shortcut and build reliable muscle memory.

Start Shortcut PracticeSee Practice ModesCommencer les fonctions

Usage Tip

Apply an outside border to the selected range.

Related Shortcuts

Insert/Edit Comment

Same category
Shift + F2

Insert Hyperlink

Same category
Ctrl + K

Copy Formula from Cell Above

Same category
Ctrl + '

Toggle Formula View

Same category
Ctrl + `

Toggle Reference Type

Same category
F4

Copy Value from Cell Above

Same category
Ctrl + Shift + 2

Apply Date Format

Same category
Ctrl + Shift + 3

Apply Currency Format

Same category
Ctrl + Shift + 4

More In This Category

Clear Cell Contents

Delete

Redo

Ctrl + Y

Underline

Ctrl + U
View Full Shortcut List

FAQ

What is the shortcut for Apply Outside Border?

Windows: Ctrl+Shift+6. Mac: Ctrl+Shift+6.

How do I use Apply Outside Border?

Use it after selecting a table or summary block to apply an outside border quickly.

What shortcuts should I practice after Apply Outside Border?

Practice copy value from above, outside border, and cell editing next and you can move through common Excel work much faster.

Where can I practice Apply Outside Border?

Use the page button to start a focused drill right away. If you switch to full practice, you can review copy value from above, outside border, and cell editing in the same flow.

What is the action preview for Apply Outside Border?

A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.

← Back to ListExcelGym Home