![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |