![merging cells in excel without a mouse merging cells in excel without a mouse](https://media.gcflearnfree.org/ctassets/topics/234/mod_column_hide_hidden.png)
Sometimes, you may want to select an entire column of cells. Select One or More Entire Columns of Cells In the image below, we’ve deselected two rows from a selected range by holding down the Ctrl key while clicking the row numbers of the rows we didn’t want in the selection. In the image below, we’ve selected several rows that are noncontiguous.Īnd, just like with individual cells, you can also use the Ctrl key to deselect rows from a selected range. Then hold down your Ctrl key while clicking the row numbers of additional rows you want to add to the selection.
![merging cells in excel without a mouse merging cells in excel without a mouse](https://i.ytimg.com/vi/EM882U4Tanc/hqdefault.jpg)
To select noncontiguous rows, click the row number of a row you want to select. Either way, you’ll select a range of rows. Or, if you prefer, you can hold down your Shift key and click the bottom-most row you want to select. To select a contiguous set of rows, click the row number of the first row.Ĭontinuing to hold down your mouse button, drag your cursor across all the rows you want to select. An example formula might be CONCAT (A2, ' Family'). Close the formula with a parenthesis and press Enter. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Select the cell you want to combine first. If you know the exact range of cells you want to select, using the name box is a useful way to make the selection without any clicking or dragging. Select the cell where you want to put the combined data. Select a Range of Cells Using the Name Box I have some rows that are merged, and it was frustrating the hell out of me how quickly. In the image below, we deselected several cells from a range of cells we’d already selected just by holding down the Ctrl key while clicking the cells. Click down on scroll wheel (middle) of mouse (remember not turn.
![merging cells in excel without a mouse merging cells in excel without a mouse](https://www.libxl.com/images/merging.png)
You can also use your Ctrl key to deselect an already selected cell-even from a selection range. In the image below, we’ve selected five different cells. Now, hold down the Ctrl key and click to select additional cells. You can also select multiple cells that are not connected to one another by using your Ctrl key. Select (or Deselect) Independent Cells Outside a Range With the Ctrl Key Hold down your Shift key, and then click that cell.Īll the cells in the range are now selected. Scroll your sheet until you find the last cell in the range you want to select. Click the first cell in the range you want to select.