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

excel intro

ResolvedVersion Standard

Pat has attended:
Excel Introduction course
Excel Intermediate course

Excel intro

How can I insert rows without adding them one at a time?

RE: Excel intro

Right click on the headings cell. Select Format. Select Alignment tab. On the Orientation area, change the degrees so it is 90 and click ok
thanks

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.