excel password

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 Password

Excel Password

resolvedResolved · Low Priority · Version 2003

Izabella has attended:
Excel Intermediate course

Excel Password

How to set up a password?

RE: Excel Password

One thing you could do is go to the standard File Save As when you are in the worksheet. Then in the standard window where you are going to save you file there is a Tools button on the top right hand side. Click on that and go to the General options. From there you can set a password to oprn or modify.

Hope that helps

Tracy


 

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.