ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

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

Updated on September 8, 2011
Source

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

Shortcut
Description
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
SHIFT + F11
Insert New Worksheet
SHIFT + F4
Find Next OR Repeat the last find action.
Alt+D, P
To open the Pivot Table Wizard
Ctrl+*
Select current region
=+FunctionName+Ctrl+A
Open Insert new function window
Ctrl+Shift+Enter
Array formula
Ctrl+F3
Define name
F3
Paste name
Ctrl+1
Format cells
Ctrl+;
Current date
Ctrl+shift+:
Current time
End+Enter
Active the last active cell in Raw, even if there is an empty cells in the raw
Ctrl+Arrows
Activates the last cell in a contiguous list for the direction specified.
Ctrl+Shift+Arrows
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

Comments

    0 of 8192 characters used
    Post Comment

    • GmaGoldie profile image

      Kelly Kline Burnett 5 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!

    • Taleb80 profile image
      Author

      Taleb AlDris 5 years ago

      GmaGoldie

      Yes, I agree with you.

      Thanks for comments.

    • TheMoneyGuy profile image

      TheMoneyGuy 5 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.

      TMG

    • Taleb80 profile image
      Author

      Taleb AlDris 5 years ago

      TMG

      You are welcome.

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

      Thanks for stopping by & comment.

      Taleb8

    • Taleb80 profile image
      Author

      Taleb AlDris 5 years ago

      ITcoach

      Welcome to HP.

      Thank you for stopping by & votes.

      I hope I will see you around.

    • dingerd profile image

      Darrel Dinger 4 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
      Author

      Taleb AlDris 4 years ago

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

      I hope all the best for you.

    Click to Rate This Article