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 » training+excel+microsoft - Excel

	98.1 % recommend us
	More live stats...

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

Training information:

training+excel+microsoft - Excel

Resolved · Low Priority · Version Standard

Reply Wed 10 Oct 2007, 16:23Delegate Ann-Marie said...

Ann-Marie has attended:
Excel Advanced course

Excel

what is the shortcut to get rid of decimals?

For upcoming training course dates see: Pricing & availability

Reply Thu 11 Oct 2007, 10:44Trainer Pete said...

RE: excel

Hi Ann-Marie, Thank you for your post, other than a convoluted key board operation involving Ctrl keys and Tab keys to reach the Format, Cells, Number, decimal places input box, I think the easiest way to reduce or get rid of decimals is to click the Decrease Decimals button on the Formatting Toolbar.

Excel articles

· How To Add Extra Data Ranges To An Excel Chart
· You're Hired! Raising Your Chances Of Employment With Excel
· Why Printing Needn't Be A Grey Area In Excel
· Inviting Investment Into Your Business Can Be Easier With Excel
· Sorting Birthdates Into Their Respective Months In Excel

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