Quickly select a range of values in excel
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
- Select a cell somewhere in the range.
- Press CTRL + SHIFT + * (shortcut)
Related posts:
How to quickly select a large non contiguous range with keyboard in excel
Excel vba: Select cell A1 on all sheets before you close a workbook
Excel: Select only visible cells
Select a cell in a table and the chart updates automatically (vba)
Quickly create links to sheets, tables, pivot tables and named ranges in a workbook
Recommended categories
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.
http://office.microsoft.com/en-us/excel/HP100738481033.aspx