Thursday, 1 March 2012

Microsoft Excel Shortcut Keys

Microsoft Excel 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.

Sarmad Zia

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation.


Post a Comment


Copyright @ 2013 CTGS HOME .

Designed by Templateify & Sponsored By Twigplay