Lots of folks have opined in the past that Excel has never been a user-friendly application. It is true that Excel has so many powerful features but it can be tough to keep track of them all. Microsoft has listened to these laments and in Excel 2016, they made it easier with an enhanced search feature called Tell Me, which made buried tools much easier to locate. Microsoft has now renamed that feature. It is now called Search, but it works essentially the same as Tell Me.
Follow the steps below to learn how:
- Click in the Search box on the right-hand side of the tabs on your Ribbon. Or, like me, you can simply use the shortcut Alt-Q instead (as you know, I love to save time and keystrokes).
- Next, key in a task you would like to perform (i.e., create a pivot table). A menu will now appear showing potential matches for the task. If you go ahead and try it, the top result is a direct link to the form for creating a PivotTable.
- Select it and you will start creating a PivotTable without having to go to the Ribbon’s Insert tab first.
The search box makes it much easier to perform myriad tasks in Excel.
If you feel that you need more information regarding your task, the last two items that appear in the above-mentioned menu allow you to select from related Help topics or search for your phrase using Smart Lookup.