Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell protection

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Cell protection

Resolved · Low Priority · Version 2007

Reply Thu 9 Oct 2008, 16:31Delegate James said...

James has attended:
Excel Intermediate course
Excel Advanced course

Cell protection

if you forget the password after you've protected a worksheet is there any way to alter the data. If not do you have any suggestions of keeping password names with workbooks better 9e.g. if there a template already stored to retain this info easily

For upcoming training course dates see: Pricing & availability

Reply Tue 14 Oct 2008, 15:20Trainer Mark said...

RE: Cell protection

Hi James

Thanks for the post

Now if you forget your password after you have protected your sheet, you dont really have many options, apart from contacting IT to try and find out the password for you

They should be able to do it for you.

As for keeping passwords i keep them in a little book that i always carry round with me but dont tell other work people about - but sorry James that all i can suggest

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 articles

· Excel: Save Time With AutoFill
· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Improve Performance Of Your Excel Macros
· Streamlining Excel To Save Time

Please browse our web site to find out more about
excel training seminar and other Microsoft training courses.

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips