ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software

My Own Excel Shortcuts list -Mostly professional - I will keep updating

Updated on September 8, 2011

Excel Shortcuts are very helpful

I think whoever uses Excel, knows that every shortcut he learns is a big gift, as it save his time (and time is money- time is your life so you are saving your life for more important things or to be more active and productive)

As accountant & chief accountant now, I try to memorize every one I can find.

Here I will add, just the unique shortcuts, not the common.

hope you will like them.

My Lovely Excel Shortcuts List

ALT + O, H, R
Rename a worksheet
ALT + E, M
Move or copy current sheet
ALT + Page Down
Move one screen to the right
ALT + Page Up
Move one screen to the left
Insert New Worksheet
Find Next OR Repeat the last find action.
Alt+D, P
To open the Pivot Table Wizard
Select current region
Open Insert new function window
Array formula
Define name
Paste name
Format cells
Current date
Current time
Active the last active cell in Raw, even if there is an empty cells in the raw
Activates the last cell in a contiguous list for the direction specified.
Selects the cells from the original active cell to the last cell in a contiguous list for the direction specified.

Please, share us your own best shortcuts.

Thanks in advance.

Did you find new shortcuts here?

See results


    0 of 8192 characters used
    Post Comment

    • Taleb80 profile image

      Taleb AlDris 5 years ago

      Search for such this list, they will improve your skills fast.

      I hope all the best for you.

    • dingerd profile image

      Darrel Dinger 5 years ago from Tennessee

      Thank you for sharing these! I am always working in Excel and trying to learn new things. All the short cuts I use I have taught myself. I've never looked for a list like this even though I know they are out there. I am going to keep this list handy and try to memorize these to help make my job a little easier.

    • Taleb80 profile image

      Taleb AlDris 5 years ago


      Welcome to HP.

      Thank you for stopping by & votes.

      I hope I will see you around.

    • Taleb80 profile image

      Taleb AlDris 6 years ago


      You are welcome.

      Yes, I agree with you, Excel is very familiar.

      Thanks for stopping by & comment.


    • TheMoneyGuy profile image

      TheMoneyGuy 6 years ago from Pyote, TX

      Even though, I like more advanced software for a lot of the analysis I do, I find, when making a presentation outside of my circle of Engineers, I get a much better response when I use Excel, the reason I believe is the near universal familiarity people have with the product. I to keep a shortcut list, as for some reason, I have a hard time memorizing them. Thank you for a couple new ones.


    • Taleb80 profile image

      Taleb AlDris 6 years ago


      Yes, I agree with you.

      Thanks for comments.

    • GmaGoldie profile image

      Kelly Kline Burnett 6 years ago from Madison, Wisconsin

      Excel is a great tool - often underutilized. Short cuts on Excel are a big gift. I will have to try these out. Thank you!