The Smart Lookup button replaces the Research button under the Review tab. When you type A3 in the box, then click OK, Excel will take us to A3 automatically. The cell will be selected. Type in the name of the Column (For example, A), then the number of the row (For example, 3). When you select Go To, this dialogue box will appear: To use Go To, go to the Home tab, then select Find & Select again. Using the Go To feature, you can ask MS Excel 2016 to go to a certain cell. This saves time over scrolling through a worksheet. You can also search rows or columns – or in formulas. You can now specify where you want to look, such as within a worksheet. Select Options to further narrow down the search for the data you need to find. In the "Find What" field, type in the data that you want to find. Maybe it's the word "March." To use the Find feature, click on the Home tab, then click Find & Select in the Editing group. You will see a dropdown menu. Excel 2016 offers you the Find feature to make locating the data you need easy. Let's say you want to find the number of candy bars that sold in the month of March, but you didn't want to scroll through a large worksheet to find that information. Use the arrow keys to navigate through the data to find an insertion point.Double click the cell that you want to edit.If you need to delete data in a cell, use the backspace key. When you've finished, simply hit enter or click in another cell to save your changes.
To be able to edit data in a cell, you first need to put a cell in active mode. You can do this by selecting the cell and pressing F2 or simply clicking inside the cell. You can then type at the end of the data. For example: if you have text inside the cell that reads "cat", you can click in the cell at the end of the word, then add more text, such as "catsup".
Tips: If the password has been forgotten or lost, then you need to use VBA codes or 7-zip to unprotect the Excel sheet 2016 and disable the read-only.In the old days of pencil and paper or a typewriter, making changes to anything was a hassle. You had to use that messy white out fluid. Or even worse, take an eraser to it and chance leaving a smudge mark or tearing the paper. If asked for the password, type it and click OK. Select the Review tab and click Unprotect Sheet. In this case, to disable read-only, you need to unprotect the sheet by the following steps. Once the reader attempts to change the worksheet, he will be prompted with the warning message shown below. The author of an Excel 2016 workbook may protect the sheet and lock the cells so that users only can open and read the workbook but can’t be able to make changes to it. Then the read-only mode in the Excel 2016 workbook can be disabled.ģ. When you are back to the Save As dialog, click Save to save the workbook. In the General Options dialog, delete the password to modify and uncheck the box next to Read-only recommended, and then click OK.
In the Save As dialog, click the drop-down arrow next to the Tools button, and then select General Options. Type the password for write access and click OK.Ĭlick File -> Save As, select one location where you will save this document. In this case, to disable read-only,have a look: If a password to modify is added to protect the Excel 2016 workbook, anyone who doesn’t know the true password only can open this workbook in read-only mode and changes he makes can’t be saved unless he save the workbook with a new name or in a different location. If the workbook is just marked as final to let readers to know it is final and read-only, to disable the read-only mode, you just need to open the Excel 2016 workbook and then click the Edit Anyway button on the yellow warning appeared at the top of the workbook.Ģ.