Search results
Results from the WOW.Com Content Network
Go to the Data tab on the Ribbon, then select Data Validation. On the Settings tab, in the Allow box, select List. If you already made a table with the drop-down entries, select in the Source box, and then select and drag the cells that contain those entries. However, do not include the header cell.
Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as the last cell on the worksheet that contains data or formatting.
In Excel, you may want to load a query into another worksheet or Data Model. In Excel, select Data > Queries & Connections, and then select the Queries tab.
Create a parameter that stands for a value you might frequently change, such as a server, database, folder, file name, location or filter value.
On the Data tab, in the Data Tools group, select Data Validation. On the Settings tab, in the Allow box, select List. In the Source box, type your list values, separated by commas. For example, type Low,Average,High. Make sure that the In-cell dropdown check box is selected. Otherwise, you won't see the drop-down arrow next to the cell.
Use chart filters to show and hide data series or categories, and use the Select Data Source dialog box to further change and rearrange the data that's shown in your chart.
Learn best ways to select a range of data to create a chart, and how that data needs to be arranged for specific charts.
On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, Select cell contents in Excel containing those entries. You'll see the list range in the Source box change as you select.
In the Insert Slicers dialog box, select the check boxes for the fields you want to display then select OK. A slicer is displayed for every field that you selected. Clicking any of the slicer buttons will automatically apply that filter to the linked table or PivotTable.
Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting. Cells to the last used cell on the worksheet (lower-right corner) Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on the worksheet (lower-right corner).
Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.