microsoft excel tutorial, microsoft excel 2007, microsoft excel shortcut keys, microsoft excel shortcuts, microsoft excel tricks, microsoft excel tricks and shortcuts
Microsoft excel Tricks and Shortcuts
|
Shortcut
|
Description
|
|
Double-click (on a cell)
|
Edit the cell contents.
|
|
Double-click (on a row/column divider)
|
Adjust height/width
to auto-fit
|
|
High-light headers of
multiple rows/columns then Double-click on a row/column divider
|
Adjust height/width
to auto-fit of all high-lighted rows/columns
|
|
Triple-click
|
Select the entire
contents in the cell
|
|
Click on row/column divider
then drag
|
Adjust height/width
of the row/colunn
|
|
High-light headers of
multiple rows/columns then Click on row/columndivider then drag
|
Adjust height/width
of the rows/colunns
|
|
Ctrl + Mouse wheel
|
Zooms in and out of document.
|
|
Hold Shift + Click the cells
|
Select multiple
cells
|
|
Shortcut
|
Description
|
|
F2
|
Edit the selected cell.
|
|
F5
|
Goto a specific cell. For example, C6.
|
|
F7
|
Spell check selected text and/or
document.
|
|
F11
|
Create chart.
|
|
Ctrl + A
|
Select all.
|
|
Ctrl + B
|
Bold.
|
|
Ctrl + C
|
Copy.
|
|
Ctrl + F
|
Find (same as Shift + F5).
|
|
Ctrl + G
|
Go To.
|
|
Ctrl + H
|
Replace.
|
|
Ctrl + I
|
Italic.
|
|
Ctrl + K
|
Insert link.
|
|
Ctrl + N
|
New Workbook.
|
|
Ctrl + O
|
Open Workbook.
|
|
Ctrl + P
|
Print dialog.
|
|
Ctrl + S
|
Save.
|
|
Ctrl + U
|
Underline.
|
|
Ctrl + V
|
Paste.
|
|
Ctrl + Z
|
Undo.
|
|
Ctrl + Y
|
Redo.
|
|
Ctrl + X
|
Cut.
|
|
Ctrl + 5
|
Strikethrough text.
|
|
Ctrl + F3
|
Define Name.
|
|
Ctrl + F4
|
Exit Excel.
|
|
Ctrl + F6
|
Switch between open workbooks.
|
|
Ctrl + F9
|
Minimize current window.
|
|
Ctrl + F10
|
Maximize current window.
|
|
Shift + F1
|
Activate Help on Item.
|
|
Shift + F2
|
Insert Comments
|
|
Shift + F3
|
Insert Function.
|
|
Ctrl + Shift + ;
|
Enter the current time.
|
|
Ctrl + ;
|
Enter the current date.
|
|
Ctrl + Page down
|
Move to next worksheet.
|
|
Ctrl + Page up
|
Move to previous worksheet.
|
|
Ctrl + Shift + #
|
Number Format: Date
|
|
Ctrl + Shift + @
|
Number Format: Time.
|
|
Ctrl + Shift + !
|
Number Format: Commas.
|
|
Ctrl + Shift + $
|
Number Format: Currency
|
|
Ctrl + Shift + %
|
Number Format: Percentage
|
|
Ctrl + Shift + ^
|
Number Format: Scientific.
|
|
Ctrl + Space
|
Select entire column.
|
|
Shift + Space
|
Select entire row.
|
|
Ctrl + (Arrow key)
|
Move to next section.
|
No comments:
Write comments