| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I freeze data in the spreadsheet so no one can change it?
I have store daily sales in a spreadsheet then another sheet that breaks the
daily sales into monthly catagories. Once the month is over, I want to keep this data frozen. So if I accidently put todays data in the wrong month I want excell to tell me, "sorry stupid, you already froze this data and can't change it!" Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I freeze data in the spreadsheet so no one can change it?
gbbmech13,
Try this: 1. Select all cells in the worksheet (CTRL-A) 2. Format-Cells, in the Protection Tab, UNCHECK the "Locked" checkbox. Click OK 3. Tools-Protection-Protect Sheet. Supply a password if you like, but make sure you don't forget the password. Now, at the end of the month, select the cells that you want "frozen". Then, Format-Cells, in the Protection Tab, CHECK the "Locked" checkbox. "gbbmech13" wrote: I have store daily sales in a spreadsheet then another sheet that breaks the daily sales into monthly catagories. Once the month is over, I want to keep this data frozen. So if I accidently put todays data in the wrong month I want excell to tell me, "sorry stupid, you already froze this data and can't change it!" Is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I freeze data in the spreadsheet so no one can change i
I forgot, you need to unprotect the sheet first before you can lock/unlcok
the cells. So, at the end of the month, Un protect the sheet, select the cells that you want "frozen" and lock them. Then protect the sheet again. "Vergel Adriano" wrote: gbbmech13, Try this: 1. Select all cells in the worksheet (CTRL-A) 2. Format-Cells, in the Protection Tab, UNCHECK the "Locked" checkbox. Click OK 3. Tools-Protection-Protect Sheet. Supply a password if you like, but make sure you don't forget the password. Now, at the end of the month, select the cells that you want "frozen". Then, Format-Cells, in the Protection Tab, CHECK the "Locked" checkbox. "gbbmech13" wrote: I have store daily sales in a spreadsheet then another sheet that breaks the daily sales into monthly catagories. Once the month is over, I want to keep this data frozen. So if I accidently put todays data in the wrong month I want excell to tell me, "sorry stupid, you already froze this data and can't change it!" Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| How can you change the x-y axis of data in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
| Large Spreadsheet - Freeze On Recalculate | Excel Worksheet Functions | |||
| Freeze Panes , Data Validation Conflict | Excel Discussion (Misc queries) | |||
| How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions | |||
Linear Mode
