Alternatively, you can manually select a function cell with the cursor.He has an A - Level in ICT, at grade C, and is proficient with a number of software packages.
Check out his book at Battles of the Pacific War 1941 -1945 recalls where, when and how the Pacific War was won and lost within the battlefields of the Pacific. Read more September 19, 2017 Excel is a spreadsheet application that has loads of functions that you can add to sheets. Excel 2016 also has enhanced collaboration options for sharing sheets with other recipients. Those who often share their spreadsheets might sometimes need to lock formula (or function) cells. Locking the function cells will ensure that other spreadsheet users cant delete or edit the formulas. Excel Locked For Editing By Me On Full Versions OfThe full versions of Excel include lock and protect options for spreadsheets. When you select to lock specified function cells, nobody, including yourself, can edit them. You can unlock the cells for editing by entering your sheet password. So if you dont need anybody to edit a shared spreadsheets functions, its usually better to lock the cells beforehand. ![]() However, this has absolutely no effect until you select to protect the spreadsheet. The Locked setting is selected for all cells, so protecting the spreadsheet will lock all the cells in it whether they include functions or not. Those who only need to lock functions should first unlock the spreadsheet, and then select just the formula cells. To unlock a spreadsheet, select all its cells by pressing the Ctrl A hotkey. Alternatively, you can click the Select All button at the top left of the spreadsheet. That will select all the cells in the sheet as in the snapshot below. Next, press the Ctrl 1 hotkey to open the Format Cells window. That window includes a Protection tab where you can select the Locked option. Click the Protection tab and deselect the selected Locked check box. Lock the Spreadsheets Formulas Now youve unlocked the spreadsheet, you can select to lock only the function cells in it. Select all the function and formula cells in the sheet by pressing the Find Select button on the Home tab. Select Go To Special to open the window shown directly below. Click the Formulas radio button to select all the formula type options, and press the OK button.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |