Select a Large Range of Cells With the Shift Key

This is an audio transcript from our online video training. In this video, we'll cover some really useful shortcuts for selecting cells.

Select a Range of Cells By Clicking and Dragging

These selections do not need to be next to one another. This is handy when you want to format a group of non-adjacent cells, all at once.

To get out of this mode, just press the Escape key or perform an action. Using this shortcut again will select the entire worksheet. These shortcuts work also when multiple cells are selected as.

We'll cover all these options in upcoming videos. Related shortcuts Add adjacent cells to selection. Shift Click.


  • Select cell contents in Excel!
  • Cell Manipulations (Mac) | ERC.
  • Download 200+ Excel Shortcuts!
  • mac taupe lipstick review philippines.
  • office mac 2011 home and student download trial?
  • Related Posts?
  • hinh anh nam gioi mac quan lot luoi.

Add non-adjacent cells to selection. Ctrl Click. Select current region. Ctrl A. Select entire worksheet.

http://1stclass-ltd.com/wp-content/code/762-handy-orten.php

How to select 2 (multiple) columns in Excel on Mac?

Press and release the F8 key on the keyboard to start Extended mode and to highlight the first cell. Use the arrow keys on the keyboard to move the cell cursor to the next cell you wish to highlight. The first cell remains highlighted. With the cell cursor on the next cell to be highlighted, repeat steps 2 and 3 above.

Follow the steps below if the range you wish to select contains a mixture of adjacent and individual cells. Move the cell cursor to the first cell in the group of cells you want to highlight. Press and release the F8 key on the keyboard to start Extended Mode.

How to Easily Select a Block of Cells in Excel

Use the arrow keys on the keyboard to extend the highlighted range to include all cells in the group. Use the arrow keys on the keyboard to move the cell cursor away from the highlighted group of cells.


  • Select Non-Adjacent Cells in Excel With Keyboard and Mouse.
  • mac os x environment variables path!
  • core image fun house mac download.
  • mac trackpad gestures stopped working!

The first group of cells remains highlighted. If there are more grouped cells you wish to highlight, move to the first cell in the group and repeat steps 2 to 4 above. Share Pin Email.

Updated November 09, Press and hold the Ctrl key on the keyboard. Click the rest of the cells you want to highlight. Once the desired cells are highlighted, release the Ctrl key. The steps below cover selecting cells using only the keyboard.