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

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 without voting

More by this Author


Comments 7 comments

GmaGoldie profile image

GmaGoldie 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

Taleb80 5 years ago Author

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

Taleb80 5 years ago Author

TMG

You are welcome.

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

Thanks for stopping by & comment.

Taleb8


Taleb80 profile image

Taleb80 4 years ago Author

ITcoach

Welcome to HP.

Thank you for stopping by & votes.

I hope I will see you around.


dingerd profile image

dingerd 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

Taleb80 4 years ago Author

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

I hope all the best for you.

    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
    working