Microsoft Excel Keyboard Shortcuts Page 2
ADVERTISEMENT
1
2Microsoft Excel Keyboard Shortcuts
continued...
Keys for formatting data
Other shortcut keys
display the style dialog box
paste clipboard contents nto active cell
SHIFT+INSERT
ALT+’ (apostrophe)
display Find & Replace dialogue box
display the Format Cells dialog box
CTRL+1
CTRL+F
opens a new workbook
apply the General number format
CTRL+N
CTRL+SHIFT+~ (tilde)
apply the Currency format with 2 decimals
opens prin dialogue box
CTRL+P
CTRL+SHIFT+$
saves the file
apply the Percentage format with 2 decimals
CTRL+SHIFT+%
CTRL+S
select all
apply the Date format with day, month, & year
CTRL+A
CTRL+SHIFT+#
apply the Number format with 2 decimals
select differences within selection
CTRL+\ (back slash)
CTRL+SHIFT+!
display Pick From List
apply the outline border
CTRL+SHIFT+&
ALT+DOWN ARROW
display File menu
apply or remove bold formatting
ALT+F
CTRL+B
apply or remove italic formatting
display the Edit menu
ALT+E
CTRL+I
display the View menu
apply or remove underline
CTRL+U
ALT+V
display the Insert menu
apply the Time format with the hour and minute
ALT+I
CTRL+SHIFT+@
hide rows
display the Format menu
ALT+O (letter)
CTRL+9
display the Tools menu
unhide rows
CTRL+SHIFT+(
ALT+T
hide columns
display the Data menu
ALT+D
CTRL+0 (zero)
unhide columns
display the Window menu
ALT+W
CTRL+SHIFT+)
display the Help menu
show or hide the Standard toolbar
CTRL+7
ALT+H
Other function keys
display help
F1
insert a chart sheet
ALT+F1 or F11
insert a new worksheet
SHIFT+F11
execute Save As command
ALT+F2 or F12
close the Window
CTRL+F4
exit the program
ALT+F4
display list of macros in open workbooks
ALT+F8
open Visual Basic (VBA) editor
ALT+F11
open an existing file
CTRL+F12 or CTRL+O (letter)
maximize or restore the workbook window
CTRL+F10
extends a selection
F8
makes the menu bar active
F10
displays a shortcut menu
SHIFT+F10
Get in touch with us
for Not For Profit specific support and advisory
enquiries@gerrardfc.co.uk
gerrardfc.co.uk/training
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education