BTerrell Group Blog

Grace's Tips on MS Excel 2007: Protecting Worksheets

Posted by Meredith Gooch on Mon, Jul 27, 2009

To prevent users from accidentally or deliberately changing, moving, or deleting important information from a Microsoft Excel worksheet, yet still giving users the ability to change only certain cells, you might want to try the following tips:

To quickly protect and unprotect worksheets:
- Right click on the Sheet tab and select Protect Sheet
- Select the desired options under All users of this worksheet to
- Once you have protected the worksheet, the Protect Sheet icon changes to Unprotect Sheet
- Select this icon to unprotect the worksheet

To unlock certain cells:
- Select the cells, columns, or rows that you want to allow to be edited by others
- On the Home tab, in the Cells group, select Format
- Note that the Lock Cell icon is highlighted in orange by default, indicating that the cell will be locked when the worksheet protection is activated.

Or, you can also check the locked status:
- Select Format Cells
- Select the heading tab Protection
- If there is a NO tick in the Locked box, it means the cell is not locked
- Select OK

- Grace Chen, Consultant

Read More

Tags: Microsoft Excel, protecting worksheets, Excel, MS Excel, protect sheet, format cells, unblock cells, block cells

How to Make the Most of Your Accounting System

Posted by Meredith Gooch on Thu, May 14, 2009

There are many things that your current accounting system can do aside from its core intended purposes. For example, accounting software allows the setup of managing recurring tasks, thus saving you time by eliminating duplicate data entries.

Read More

Tags: accounting software, Microsoft Excel, accounting system, crystal report, Microsoft Access