MS-Excel shortcut keys

Microsoft Excel Shortcut Keys

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.