microsoft-excel-courses - multi auto printing excel

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Multi auto printing of a excel sheet

microsoft-excel-courses - Multi auto printing of a excel sheet

resolvedResolved · Low Priority · Version Standard

Susan has attended:
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel Advanced - Formulas & Functions course

Multi auto printing of a excel sheet

Sending at a later date as per conversation with Carlos

RE: multi auto printing of a excel sheet

Susan

Ok Send me the file so I can look at it.

Carlos


 

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