excel word powerpoint courses london - short cuts

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - Short cuts

excel word powerpoint courses london - Short cuts

resolvedResolved · Low Priority · Version Standard

Sunette has attended:
Excel Intermediate course

Short cuts

How do I close a group of documents?

RE: short cuts

Hi Sunette

Great to meet you yesterday and thank you for your feedback too.


To close a group of workbooks that you have open
Hold SHIFT key down, then click File menu, you will then see Close All.

Have a Great! weekend
Kind regards
Sandy


 

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips


Server loaded in 0.1 secs.