Protect Sheet: This feature is to prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password. Say you own the team status report worksheet, where you want team members to add data in specific cells only and not be able to modify anything else. With worksheet protection, you can make only certain parts of the sheet editable and users will not be able to modify data in any other region in the sheet. Worksheet level protection is not intended as a security feature. It simply prevents users from modifying locked cells within the worksheet. Protecting a worksheet is not the same as protecting an Excel file or a workbook with a password. How to protect the active worksheet? Select Home Menu => Click Format Tool => Click Protect Sheet => Type a password “ABCD1” in password to protect sheet box => Select “Protect Worksheet and contents of locked cells” check box => Uncheck all the check boxes in the allowing section => Click OK => Retype “ABCD1” in Reenter password to proceed => Click OK. For more understanding, look at the screenshot please: Fill: This feature is using to instead of entering data manually on a worksheet, you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells. For example, if the first few characters that you type in a cell match an existing entry in that column, Excel automatically enters the remaining characters for you. Excel automatically completes only those entries that contain text or a combination of text and numbers. Entries that contain only numbers, dates, or times are not automatically completed. One way to use the fill handle is to enter a series of linear data into a row or column of adjacent cells. A linear series consists of numbers where the next number is obtained by adding a “step value” to the number before it. The simplest example of a linear series is 1, 2, 3. However, a linear series can also be a series of decimal numbers (1.5, 3.5, 5.5…), decreasing numbers by two (10, 8, 6…), or even negative numbers (-1, -3, -5). In each linear series, you add (or subtract) the same step value. When you want to add a series of values in the selected rows or columns then you can use this tool to automatically fill series of values that the amount you want. How to fill series of values in columns by 1 to 100 in three selected rows? Select your three rows after you enter the started values in each row => Select Home Menu => Click Fill Tool => Click Series => Select Rows option button in the series section => Select Linear option button in the type section => Type step values “Ex: 1” and stop values “Ex: 100” => Click OK. For more understanding, look at the screenshot please:
0 Comments
|
Archives |