Friday 26 September 2014

MS Excel Shortcuts




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