Excel Guides

Picking a Contiguous Range of Cells in Excel

When working with large amounts of data in Microsoft Excel, it is often necessary to select a contiguous range of cells. This can be done easily by clicking on the first cell in the range, holding down the Shift key, and then clicking on the last cell in the range. The entire range will then be selected.

There are a few things to keep in mind when selecting a range of cells. First, all of the cells must be adjacent to each other. This means that they must be next to each other horizontally or vertically, but not diagonally. Second, the cells must be in the same row or column; you cannot select a range of cells that are in different rows or columns.

Once you have selected the range of cells that you want to work with, there are a number of things that you can do with them. For example, you can enter data into all of the cells at once, or apply formatting to them all at once. You can also delete the contents of all the cells in the range, or clear any formatting that has been applied.

If you need to select a non-contiguous range of cells (i.e., a range that is not next to each other), you can do so by holding down the Ctrl key while clicking on each individual cell that you want to include in the selection. Again, all of the cells must be in the same row or column.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.