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

visual+basic+excel - freezing data

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » visual+basic+excel - Freezing data

visual+basic+excel - Freezing data

ResolvedVersion Standard

Anna has attended:
Excel Advanced course

Freezing data

how do you freeze all live data in a worksheet?

RE: freezing data

Hi Anna:

If by 'freezing data' you mean you want to prevent cell values or formulas from being overwritten, select:

Tools/Protection/Protect Sheet...

Enter a Password (this is optional) and click Okay. Since all cells are locked by default you will then be unable to change any cell.

If you want to protect only some cells, and leave others available for entry, before protecting the sheet you need to select the cells you want to remain unprotected and select:

Format/Cells/Protection and remove the tick from 'Locked'.

Hope this helps. Post back if you need further help.

Regards,

Tony Gay.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

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