ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

MICROSFT EXCEL SHORTCUT KEYS

Updated on May 31, 2013

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

Comments

    0 of 8192 characters used
    Post Comment

    • profile image

      MaryAnne09 6 years ago

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

    • dexixy profile image
      Author

      dexixy 6 years ago from Kampala

      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!

    • profile image

      Old Poolman 6 years ago

      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

      Kelly Kline Burnett 6 years ago from Madison, Wisconsin

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

    • Rosemay50 profile image

      Rosemary Sadler 5 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 5 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.

    Click to Rate This Article