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

shortcuts

ResolvedVersion 2003

Deborah has attended:
Excel Introduction course

Shortcuts

How to shortcut the totals fields

RE: Shortcuts

Hi Deborah,

Thanks for your question and welcome to the forum.

You can use Autosum to sum a total and then use Autofill (little black cross) to fill the formula across or down.

The shortcut key for Autosum is Alt =

Thanks and kind regards

Maggie

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

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.1 secs.