News

Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.
Microsoft Excel's form controls let you add buttons to your spreadsheet to perform functions. For example, if a spreadsheet invites coworkers to enter sales predictions, they might press a button ...
If you have Excel spreadsheets with sensitive data, you can easily lock and unlock them Here's what you need to do.
How to Lock the Position of a Chart in Excel. In Microsoft Excel 2010, a chart sits over the worksheet and provides a visual expression of the underlying data. You can use a chart in conjunction ...
How to lock cells in Excel Open the Excel workbook and select all cells in the worksheet with the cells you want to lock by pressing the Ctrl + A buttons on your keyboard.
You can lock the position of a chart in Excel spreadsheet so that it doesn't move or resize when you include more columns and change cell width. Learn how!