excel word powerpoint courses london - Short cuts

Resolved · Low Priority · Version Standard

Thu 18 Oct 2007, 17:16 Delegate Sunette said...

Sunette has attended:
Excel Intermediate course

Short cuts

How do I close a group of documents?

Fri 19 Oct 2007, 10:43 Trainer Sandy said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

excel word powerpoint courses london - Short cuts

Short cuts

RE: short cuts

Excel articles

Excel tip:

Autonumber in Excel

Training Programs
Professional & Management Development