Skip to main content

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.
Labels:

Comments

Post a Comment

Popular posts from this blog

Rabba - A Soul Song

Post a Comment
Continue Reading »

Appium 1.5

The most awaited Stable version of Appium... 1.5 has been released. Go through the below update from Jonathon. Appium 1.5.0 Released Appium 1.5 The Appium team is extremely proud to announce the release of Appium 1.5! Go ahead and npm install -g appium while you read the rest of this post! Appium 1.5 has been in the works for over half a year, and we would like to share why it's such an important release for us.
Post a Comment
Continue Reading »

Steps to extract audio from a video file using VLC media player

Many of us face a situation where we have our most favorite video song, but we do not have an audio version of it. In my case, i had to convert all my favorite songs from the latest coke studio episodes. So here is the procedure to extract audio from any video file and save it as mp3. Open VLC media Player.  Press Ctrl+R which opens a window titled "Open Media"  Click on "Add" button and select your favorite video from which you wanted to extract the audio. Now, click on the little arrow button present on the "Convert/Save" button in the bottom of the window. Select the option "Convert" from the drop-down. Now a new Window named "Convert" will be opened. Click on the "Browse" button beside the text Destination File and choose an appropriate folder and name to save your output audio file. Once you have named your output file, change the extension from .ps to .mp3 Under the "Settings" section drop-down, se...
Post a Comment
Continue Reading »