Upgrade to remove ads
Only $2.99/month

Chapter 1 Keyboard Shortcuts

Terms in this set (32)

Ctrl+Shift+%
Percent Format
Ctrl+Shift+Right Arrow
Select Right to End of Current Row
Ctrl+Shift+!
Number format to two decimal places
Ctrl+W and Ctrl+F4
Close current workbook
Ctrl+Shift+~
Apply general format
Ctrl+Shift+plus sign
Insert Cells
Ctrl+Shift+&
apply border around selected cell range
Ctrl+Shift+$
Currency Format
Ctrl+Shift+;
Current Time
Ctrl+Shift+_
Removes Border
Ctrl+;
Current Date
Ctrl+Tab
Switch between open workbooks
Ctrl+z
undo
Ctrl+d
copies formulas/values in topmost cells in range of selected
Ctrl+minus sign
delete actual cells in a selected range
Ctrl+right arrow
moves active cell to current row of adjacent cells with values
Ctrl+space
select current columns
Ctrl+1
Format cells dialog window
Ctrl+pgdn
switch active worksheet to the next worksheet to the right
Ctrl+r
copy formulas in leftmost cells to others in range
Shift+space
select current row
Alt+pgdn
move one screen to right within sheet
#REF!
invalid cell reference
Ctrl+shift+#
applies the date format
Ctrl+'
toggles between displaying formulas and displaying values
Ctrl+alt+v
paste special operation
######
column width of a cell is too narrow, or negative date
#NAME?
unrecognized text in a formula
#N/A
no answer can be found
#VALUE!
wrong argument type or operand
#NUM!
invalid numeric values in a formula or function
#DIV/0!
division by zero
YOU MIGHT ALSO LIKE...