Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

training+excel+microsoft - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training+excel+microsoft - Excel

training+excel+microsoft - Excel

ResolvedVersion Standard

Ann-Marie has attended:
Excel Advanced course

Excel

what is the shortcut to get rid of decimals?

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 tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.