Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Low Priority · Version 2003

Reply Mon 14 Jul 2008, 15:07Delegate Lizzy said...

Lizzy has attended:
Excel Introduction course

Excel

what are the short cuts?

For upcoming training course dates see: Pricing & availability

Reply Mon 14 Jul 2008, 15:14 Edited on Mon 14 Jul 2008, 15:15Trainer Pete said...

RE: excel

Hi Lizzy,

Thank you for your post, welcome to the forum, in answer to your question; Shortcuts are usually the name given to Keyboard Shortcuts, these are performed by applying two or more keys at the same time, such as CTRL+C (you hold down the CTRL key and then press the C key,) this will perform the command Copy on selected text, then navigate to where you want the selected text to be Pasted and press the keyoard short cut CTRL+V.

When you become more proficient at using keyboard shortcuts they will become a part of your daily usage, and you will find they will speed up your usage of the program quite considerably. best regards Pete

Excel articles

· From novice to expert users - Microsoft Excel fits all
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Using The Excel Forms Toolbar To Spruce Up A Workbook
· What Is A Sparkline And How Do They Work?
· MS Excel: Excel At Making The Most Of Your Christmas

Please browse our web site to find out more about
excel+courses and other Microsoft training courses.

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips