file

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » File

File

resolvedResolved · Low Priority · Version Standard

Farah has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

File

how to make a file read only

RE: file

Hi Farah

Thankyou for attending the course on Tuesday, i hope you really enjoyed it.

The answer to you question is as follows: there are two ways to make your file read only one better than the other i would reconmend the first one

1. to to file save as from the window that comes up go to the top right of the window and choose tools, then click general options then put in a password to open and a password to modify which should do the trick, you will need to enter (both passwords twice).

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn


 

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips


Server loaded in 0.07 secs.