How do I select specific data in Excel?

Select one or more cells

1. Click on a cell to select it. Or use the keyboard to navigate to it and select it.
2. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells.
3. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

Where is the select data in Excel?

Follow these steps:

1. On the Insert tab, select the chart type you want.
2. On the Chart Design tab, select Select Data.
3. Click in the Chart data range box, and then select the data in your worksheet.

What is the fastest way to select data in Excel?

7 great keyboard shortcuts for selecting cells quickly.

1. Shift + Arrow Keys – Expands the selected range in the direction of the arrow key.
2. Shift + Spacebar – Selects the entire row or rows of the selected range.
3. Ctrl + Spacebar – Selects the entire column or columns of the selected range.

Where is the selection dialog box in Excel?

On the Ribbon, click the Find & Select command button in the Editing group on the Home tab and then choose Go To from its drop-down menu or press Alt+HFDG, Ctrl+G or F5. The Go To dialog box opens.

How do you select data for a chart in Excel?

If your chart data is in a continuous range of cells, select any cell in that range. Your chart will include all the data in the range. If your data isn’t in a continuous range, select nonadjacent cells or ranges. Just make sure your selection forms a rectangle.

How do you select a data source in Excel?

In Excel 2013, when you click the Select Data command button on the Design tab of the Chart Tools contextual tab (or press Alt+JCE), Excel opens a Select Data Source dialog box. The controls in this dialog box enable you to make the following changes to the source data: Modify the range…

Where is select data source dialog box in Excel 2013?

Excel 2013 All-in-One For Dummies. In Excel 2013, when you click the Select Data command button on the Design tab of the Chart Tools contextual tab (or press Alt+JCE), Excel opens a Select Data Source dialog box.

How to select only the active data range in Excel?

To select only all active data range, you need to select the first cell in the range first, then press Shift + Ctrl + End keys.