Formatting

 

 

Shortcut

Description

CTRL+1, CTRL+SHIFT+F

Open Format Cells dialog box, use 1 on the keyboard, not keypad!

ALT+'

Open Style dialog box

CTRL+SHIFT+F, F

Open the Font tab in Format Cells dialog box

CTRL+B or CTRL+2

Toggle bold formatting

CTRL+I or CTRL+3

Toggle italic formatting

CTRL+U or CTRL+4

Toggle underline formatting

CTRL+5

Toggle strikethrough

CTRL+SHIFT+&

Apply outline border to selected cells

CTRL+SHIFT+_

Remove outline border from selected cells

CTRL+SHIFT+~

Apply general number format

CTRL+SHIFT+$, CTRL+SHIFT+4

Apply currency format with two decimal places

CTRL+SHIFT+%

Apply percentage format with zero decimal places

CTRL+SHIFT+#, CTRL+SHIFT+3

Apply date, month, year date formant

CTRL+SHIFT+@, CTRL+SHIFT+2

Apply hour, minute AM/PM time format

CTRL+SHIFT+!, CTRL+SHIFT+1

Apply number format with thousands separator and two decimal places

CTRL+SHIFT+^

Apply the scientific format with two decimal places

CTRL+SHIFT+5

Apply the percentage format

CTRL+SHIFT+6

Apply the scientific format

ALT+H H

Highlight cell - change the cell background color

ALT+H FC

Change the Font Color

ALT+H FS

Change the Font Size

ALT+H FF

Change the Font Style

ALT+H FP

Format Painter

CTRL+SHIFT+_

Remove the outline border around selected cell

 

Adjusting Sizes

Shortcut

Description

ALT+O CA

Adjust column width to fit content

 

Select complete column with CTRL+SPACE first, otherwise the column adjusts to content for current cell

ALT+O CW

Adjust columns width to specific value

ALT+O RA

Adjust row height to fit content

ALT+O RE

Adjust row height to specific value

 

Aligning Cells

Shortcut

Description

ALT+H AR

Align Right

ALT+H AC

Align Center

ALT+H AL

Align Left

ALT+H AT

Align Top

ALT+H AM

Align Middle

ALT+H AB

Align Bottom

ALT+H W

Wrap the text

 

Merging Cells

Shortcut

Description

ALT+H MM

Merge Cells

ALT+H MY

Unmerge Cells

ALT+H MA

Merge Across

ALT+H M

Merge text

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017