Using the Ctrl Button to Select Non-Adjacent Cells

Using the Ctrl button on the keyboard, you can select multiple non-adjacent cells that can be far away from each other and you have to use the scroll bar to go down to select them.

Let us take the file named “Example 01.xls” from a previous post as an example:

(1) Open Example 01.xls

(2) Click cell “B4”:

Microsoft Excel 2003: Using Ctrl Button to Select Non-Adjacent Cells

(3) Press the Ctrl button and click cell “B21”:

Microsoft Excel 2003: Using Ctrl Button to Select Non-Adjacent Cells

(4) Scroll down, …

Microsoft Excel 2003: Scrolling Down

… press Ctrl, and click cell “B38”:

Microsoft Excel 2003: Using Ctrl Button to Select Non-Adjacent Cells

And this is how you select a number of non-adjacent cells.

Advertisements

Tags: ,

One Response to “Using the Ctrl Button to Select Non-Adjacent Cells”

  1. sof Says:

    interesting post !!

Comments are closed.


%d bloggers like this: