Excel is useful in the organization of data, including dates, times, percentages and other numbers. In this section, learn shortcuts to better format the cells and their respective data.
WINDOWS
Ctrl + 1
|
Format cells dialog
|
Ctrl + b
(or ctrl + 2) |
Apply / remove bold
|
Ctrl + i
(or ctrl + 3) |
Apply / remove italic
|
Ctrl + u
(or ctrl + 4) |
Apply / remove underline
|
Ctrl + 5
|
Apply / remove strikethrough
|
Ctrl + Shift + f
|
Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size
|
Alt + ' (apostrophe)
|
Display the Style dialog box
|
Number Formats
Ctrl + Shift + $
|
Apply the Currency format with two decimal places
|
Ctrl + Shift + ~
|
Apply the General number format
|
Ctrl + Shift + %
|
Apply the Percentage format with no decimal places
|
Ctrl + Shift + #
|
Apply the Date format with the day, month, and year
|
Ctrl + Shift + @
|
Apply the Time format with the hour and minute, and indicate am or pm
|
Ctrl + Shift + !
|
Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values
|
Ctrl + Shift + ^
|
Apply the Scientific number format with two decimal places
|
F4
|
Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell
|
Apply Borders to Cells
Ctrl + Shift + &
|
Apply outline border from cell or selection
|
Ctrl + Shift + _ (underscore)
|
Remove outline borders from cell or selection
|
Ctrl + 1, then Ctrl + Arrow Right/Arrow Left
|
Access border menu in 'Format Cell' dialog. Once border was selected, it will show up directly on the next Ctrl + 1
|
Alt + t
|
In Cell Format in 'Border' Dialog Window, set top border
|
Alt + b
|
In Cell Format in 'Border' Dialog Window, set bottom border
|
Alt + l
|
In Cell Format in 'Border' Dialog Window, set left border
|
Alt + r
|
In Cell Format in 'Border' Dialog Window, set right border
|
Alt + d
|
In Cell Format in 'Border' Dialog Window, set diagonal and down border
|
Alt + u
|
In Cell Format in 'Border' Dialog Window, set diagonal and up border
|
Align Cells
Alt + h, ar
|
Align Right
|
Alt + h, ac
|
Align Center
|
Alt + h, al
|
Align Left
|
No comments:
Post a Comment