Microsoft Excel Shortcut keys

Auto sum shortcut key : Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .

Create hyper links in Excel : Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing “CTRL + K”.
Close all open files at once : Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking “File” and then “Close All”.

Quickly open recently opened files : Quickly open the recent files by first pressing “ALT + F” to open the file Menu and press 1, 2, 3, or 4.

Create underlines without any text : This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name:  .

Print only sections of a document : Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.

Repeat recent action : Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.

Quickly undo : Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.

Quickly above cell contents : In Microsoft Excel press CTRL + SHIFT + ” to copy the above cells contents.

Using the Microsoft Excel Auto filter : Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data automatically.

7 thoughts on “Microsoft Excel Shortcut keys

  1. Thank you for this article. I will also like to state that it can possibly be hard if you find yourself in school and starting out to create a long credit rating. There are many pupils who are just trying to make it and have long or beneficial credit history is often a difficult matter to have.

  2. You made some decent factors there. I looked on the internet for the issue and located most people will go together with with your website.

  3. Thanks for the write-up. My spouse and i have generally seen that the majority of people are eager to lose weight when they wish to look slim and attractive. However, they do not always realize that there are other benefits for losing weight as well. Doctors say that overweight people suffer from a variety of disorders that can be directly attributed to their particular excess weight. Thankfully that people who sadly are overweight and suffering from several diseases can help to eliminate the severity of their illnesses by losing weight. You’ll be able to see a gradual but noted improvement with health when even a slight amount of weight loss is attained.

  4. I think this is among the most important info for me. And i’m glad reading your article. But should remark on few general things, The site style is ideal, the articles is really great : D. Good job, cheers

  5. Thank you for another informative site. Where else could I get that type of information written in such a perfect way? I’ve a project that I’m just now working on, and I’ve been on the look out for such info.

  6. I keep listening to the newscast speak about getting boundless online grant applications so I have been looking around for the most excellent site to get one. Could you advise me please, where could i acquire some?

  7. What’s Happening i’m new to this, I stumbled upon this I’ve discovered It positively helpful and it has aided me out loads. I am hoping to contribute & aid different customers like its helped me. Great job.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s