We all use Excel for our basic official accounts mostly. Excel has many versions and requires lots of formulas to acquire them properly. No person can accomplish an excel spreadsheet without knowing the formulas. These formulas can be complicated for most people, but that can be learned quickly by taking a crash course or from online videos also. However, apart from learning formulas and shortcuts to access Excel, there are a few other things to know to access Excel. Like ways to prevent it from others once you are forwarding it to your other co-workers or clients.
Preventing your work from others
We understand that you work very hard on your sheet and do not want any other person to change the file you shared. There is a way; in Excel, you can lock your specific choice of the cell if you want to. This will prevent and secure your cells from being changed by any other random person. Here’s how,
How to lock cells?
When you are protecting your cells on your worksheet, it will be locked. So nobody can delete or change it, not even edit. That means once you lock them no edit, delete or reformatting can be done by any other person but you.
1. Navigate to the review tab
2. Select protect sheet
3. Click OK
These three simple steps will protect your sheet.
Ways to lock specific cells
There are times when you want to lock specific cells so that no other person can change it, but there might be some reason you want them to adjust. Like, you may want to allow others to change pricing and all but do not IDs and names. As we said, earlier cells are protected by default when you apply to protect the whole sheet.
· Uncheck locked
· Go to review-protect sheet
· Click OK
If someone is willing to lock, unlock cells that aren’t alongside, you can still accomplish it by using some shortcuts. Select one specific cell or group of cells and lock or unlock whatever you are willing to do. Then select the next cell and press F4 to reverse your previous action.
Ways to add percentage in excel
The most appropriate way to add percentage in Excel is highlighting the specific cell you are looking for and press Ctrl+Shift+%, this will turn any numerical cell into a percentage. There are other ways to add percentage in your sheet, but that requires your hand and the mouse and doing it manually to know where it is, which tab or the knowledge of shortcuts. The way I suggest is easier for everyone if you are looking for % sign specifically. Calculation of salary and payroll is very easy to excel so learn more from this article.