2020. 2. 7. 11:43ㆍ카테고리 없음
You select multiple cells in Excel by holding down the mouse button and dragging the cursor across columns or rows. Navigate to the Home tab in the office ribbon, if you aren't already there. In Excel Online, if you perform a Control-clic on a Mac, you'll have a contextual menu. No non-adjacent cells selection. The usual Command-clic doesn't work to select non adjacent cells. There is no way to select non-adjacent cells in Excel Online when using a Mac.
If you have a range of cells, of which some contain values and some are blank, and you want to select just the blank cells, there is a quick way to select those blank cells that doesn't involve manually clicking on every one. To do this, follow these steps:. Select the range of cells in your spreadsheet from which you want to select only the blank cells. Press F5 on the keyboard.
Best How Do You Select Multiple Cells In Excel For Mac 2017
Note that this step works for any version of Excel on Windows or on a Mac with a full keyboard. If you have a Mac with function buttons, press FN+F5. Then click the Special.
Button. Select the option for Blanks. Click OK Once you click OK, you'll find that only the blank cells in the range have been selected. The main reason you might want to do this is to enter a value or formula into only the blank cells in a range. To find out how you can do this, see the lesson on how to.