You can select adjacent cells in Microsoft Excel 2013 by clicking on a cell, then holding down your mouse button as you drag the mouse to select other cells. You can even select an entire row or column by clicking the row number at the left side of the spreadsheet, or the column letter at the top of the sheet.
But what if you need to select a group of cells that are not near one another? It is possible to select cells that are separated in Microsoft Excel 2013, although it is slightly different than the cell-selection methods just mentioned.
How to Select Cells That Are Separated in Excel 2013
The steps in this article will show you how to select cells that are not near one another in Excel 2013. This is helpful if you need to paste the same data into multiple, non-adjacent cells, or if you need to change the formatting on cells that you are unable to select by clicking and dragging. Note that this method will require you to hold down a key on your keyboard as you click each cell that you want to select.
- Open your spreadsheet in Microsoft Excel 2013.
- Click the first cell that you want to select.
- Hold down the Ctrl key on your keyboard, then click each other cell that you wish to select.
You can then perform whatever action you need to apply to each of those cells. For example, if I right-clicked on one of the selected cells and clicked the Format Cells option, I could update the formatting for just those cells.
You can then cycle through each of the selected cells by pressing the Enter key on your keyboard.
You can also enable the selection of multiple non-adjacent cells by pressing the Shift + F8 keys on your keyboard, then simply clicking each of the cells that you wish to select. You can exit that mode by pressing Shift + F8 again once you have finished updating your cells.
Do you have a lot of unnecessary hyperlinks in your worksheet? Learn how to remove all Excel 2013 hyperlinks at the same time instead of removing them individually.