Hold down the control key and click (or click and drag) elsewhere on the How to quickly select non-adjacent cells or ranges in Excel? Select non-adjacent cells or ranges with hotkeys.
I run a golf pool where is team selects a serious of PGA players to make up their team.Įxcel Shortcut: Add non-adjacent cells to selection, Add non-adjacent cells to selection. You might think there would be a way to unselect a cell if you mistakenly include it Excel Formula for Mac Non Adjacent Cells Good afternoon, any help would be greatly appreciated. How to select non-adjacent cells in Excel, In Mac Excel, you hold the Command key down, then click the cells you want. Once the desired cells are highlighted, release the Ctrl Click the rest of the cells you want to highlight. Press and hold the Ctrl key on the keyboard. With your mouse, click the first cell you want to highlight. Press Select Non-Adjacent Cells with Keyboard and Mouse. Position your cursor in the first row or column.
Select data for a chart in Excel for Mac, On the Table tab, select Convert to Range. How to select non adjacent cells in excel mac
