Under Customize toolbar, for Show favorites bar, do one of the following:. To turn on the favorites bar, select Always.

Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...

If you want multiple copies of a printout, change the number of copies in the Print page: On Windows 7 or earlier, at the top of the Print page is a box labeled Copies with up and down arrows for you to choose how many copies of the document you want. Make your choice (either by entering a number or using the arrows), and then click Print.

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Press Ctrl + Alt + Delete to open Task Manager.If you don’t see Task Manager after pressing Ctrl + Alt + Delete, press Ctrl + Shift + Esc to open Task Manager.. If Task Manager flickers along with everything else on the screen, a display driver is probably causing the problem.

Select your printer from the list and then select Open queue to see a list of what's printing and the upcoming print order.

To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.

Try it! Universal search. Select Search on the taskbar or press Windows logo key + S, then type what you want to find.You'll get personalized search results for people, email, and files in local and shared sites, or from the web. Desktop groups

The new Microsoft Edge will delete your browsing history, cookies, and site data, as well as passwords, addresses, and form data when you close all InPrivate windows. You can open an InPrivate window in different ways: Select and hold (right-click) the Microsoft Edge logo in the taskbar and select New InPrivate window.