We hope this article on selecting elements of an Excel worksheet has been helpful. To select all cells in a table or list, click in one of the cells and press Ctrl + A. How to Select All Cells in an Excel TABLEД®xcel allows the user to create tables, previously called Lists. The best way to select all the cells in a worksheet is to click the Select All cell in the upper left corner of the worksheet as shown below.ДЄlternately, clicking in an unused cell outside the range of data and pressing Ctrl + A will usually select all of the worksheet cells as well. To de-select one of the cells you've selected, just click again in that cell. You can also select a cell range as discussed above and then press and hold the Ctrl key to select individual cells. To select multiple cells that are not contiguous, click in the first cell and then while holding down the Ctrl key, click in the other cells you wish to select. Perhaps we want to format them the same, or delete their contents. Sometimes we want to select multiple cells that are not in a block. In the image at right we selected cells A1 through B5. In this Excel tutorial, I will show you three useful tricks that you can use to subtract multiple cells from one cell in Excel. To select all of the cells in a cell range, click the cell in one corner of the range and, while keeping the left mouse button pressed, drag the cursor to the opposite corner of the range. When you need to subtract multiple cell values from a particular number, the best way to do it is to put the number in one of the cells (on the same sheet or a different sheet) and apply a simple formula. A cell range is a contiguous group or block of cells that form a square or rectangle.

How to select multiple cells in excel