visual+basic+excel - Freezing data

The UK's most regular instructor-led training courses.
Training information: visual+basic+excel · Excel training london · VBA training UK

Resolved · Low Priority · Version Standard

Freezing data

Anna has attended:
Excel Advanced course

by - delegate Anna [2 posts] (2007 Nov 1 Thu, 11:47) Reply

how do you freeze all live data in a worksheet?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: freezing data

by - trainer Anthony [5 posts] (2007 Nov 8 Thu, 14:05) Reply

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.

· Tap the Power of Recorded Macros with MS Excel Courses
· Tips to Facilitate Printing of Excel worksheets
· Microsoft Excel Training: Essential for Today's Employees
· Excel Macros for the Non-Programmer
· Microsoft Excel Courses Teach Advanced Macro Techniques

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips