ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software»
  • Office Software Suites»
  • Microsoft Office

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

    • 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.

    • 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

    • 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!

    • 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.

    • 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!

    • 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

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