## Quickly select a range of values in excel

*Article updated on December 06, 2010*

Copying or moving cells is probably one of the most common activities in excel. Here is how to quickly select cells and adjacent cells containing values. The selection ends when there are blank rows or columns.

This is useful when working with large ranges. Keep in min that the selection might also contain blank cells. See examples below.

*Example 1*

*Example 2*

Create a list of dates with blanks between quarters in excel

Question: How do I create a list of dates with blanks between each quarter? (Q1, Q2, Q3 and Q4) Answer: […]How to create random numbers, text strings, dates and time values

In excel the RAND() function returns a number greater than or equal to 0 (zero) and less than 1. Combining […]### 2 Responses to “Quickly select a range of values in excel”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

This looks like Excel 2007. Can you also select a cell in the range and press Ctrl+A to select the range, as you can in Excel 2003?

Yes, I didn´t know about Ctrl + A.

Excel shortcut and function keys

Applies to: Microsoft Office Excel 2007

CTRL + A

Selects the entire worksheet.

If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.

When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.

CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.

https://office.microsoft.com/en-us/excel/HP100738481033.aspx