Shortcut keys in any program simplify and speed up your work because you take a shorter route in doing your work.

Today we shall look at some of the most commonly used shortcut keys in Microsoft Excel.

Ctrl + A -Select all contents of the worksheet

Ctrl+Home -Takes you back to first Cell

Ctrl+End -Take you to last used cell in a worksheet(even if blank)

Ctrl + B -Bold Highlighted Solution

Ctrl + I - Italic Highlighted Solution

Ctrl + U -Underline highlighted selection.

Ctrl+Up arrow -Takes you to first row of the data (provided there are no blank cells)

Ctrl+Down arrow -Takes you to last row of the data (provided there are no blank cells)

Ctrl+Left arrow -Takes you to first column of the data (provided there are no blank cells)

Ctrl+Right arrow -Last column of the data (provided there are no blank cells)

Ctrl+Page Down -Takes you to Next worksheet

Ctrl+Page Up -Takes you to Previous worksheet

Ctrl + 5 -Strikethrough highlighted selection

Ctrl + 6 -Bring up the print dialog box to begin printing

Ctrl + Z -Undo last action

Ctrl + F9 -Minimise current window

Ctrl + f10 -Maximize currently selected window.

Ctrl + F6 -Switch between open workbooks or windows.

Ctrl + Page up -Move between Excel work sheets in the same Excel document

Ctrl + Page down -Move between Excel work sheets in the same Excel document

Ctrl + Tab -Move between Two or more open Excel files

Alt + = -Create a formula to sum all of the above cells

Ctrl + Space - Select entire column

Shift + Space -Select entire row

F6 -Go to a specific cell i.e A7

F7 -Spell check selected text or document

F11 -Create chart from selected data

F2- Edit the selected cell

Ctrl + ~ -Switch between showing Excel formulas or their values in cells.

Some Microsoft Excel Books Recomendations for you

More by this Author

Comments 7 comments

profile image

MaryAnne09 6 years ago

Thanks for the information about MS Excel Shortcuts! Awesome!! :-)

dexixy profile image

dexixy 6 years ago from Kampala Author

Thanks, I'm glad you found this helpful. Thanks for reading and commenting

profile image

MaryAnne09 6 years ago

You are very welcome! You explain things very well, and I enjoy using Excel, which is a great topic to write about as well. I enjoy your hubs and will return to read more. I hope to add more of my own at some point, but I am very busy with school right now. :-) Have a great week!

Old Poolman profile image

Old Poolman 6 years ago from Rural Arizona

I have been using Excel for years, and never knew about these shortcuts. I printed out the list and put it where I can find it next time I need Excel. Thanks for sharing your knowledge.

GmaGoldie profile image

GmaGoldie 6 years ago from Madison, Wisconsin

I love Excel and these are short cuts I definitely will use! Thank you!

Rosemay50 profile image

Rosemay50 4 years ago from Hawkes Bay - NewZealand

I have worked with Excel for years but never knew most of these shortcut keys.

Thank you for the useful information

alocsin profile image

alocsin 4 years ago from Orange County, CA

I've been using Excel for years and yet did not know about these shortcut keys. Voting this Up and Useful.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.

    Click to Rate This Article