Microsoft Excel Shortcut Keys .:: My Blogger Trick

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.
Use at your own risk.
Mouse 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/column divider 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

Keyboard shortcuts

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.

If you enjoyed this post and wish to be informed whenever a new post is published, then make sure you subscribe to our regular Email Updates!

Subscribe To Get Latest Tricks On Email!

0 comments:

Confused? Feel free to ask

Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.

Note:
1. To add HTML CODE in comments then please use our HTML Encoder
2. You can always Try the tutorial on our HTML Editor
3. Please do not spam Spam comments will be deleted immediately upon my review.

Regards,
MMKTricks