Weekly Computer Tip # 306
24 April 2010
quickly select a range of cells (Excel 2000-2007)
Just in case you were wondering where last week's tip was... I was stuck in Germany for five days because of the Volcano in Iceland. (What next: earthquake in Asda? ;) But I'm back and inspired by one of yesterday's course participants who told me (and the others) a quick way to select a rectangular block of cells in an Excel worksheet.
Here's how:
- Select the first cell of the block (the cell in the upper-left corner).
- Hold down the SHIFT key and click the last cell of the block (the cell in the lower-right corner).
I agree Darnie: much nicer that dragging from the first cell of the block to the last cell of the block. Thanks for the inspiration!
By the way, just in case you want a complete list of how to select ranges in Excel:
- Select a single column: click on the column heading (its letter).
- Select two or more adjacent columns: drag from the column heading for the first column to the column heading for the last column.
- Select a single row: click on the row heading (its number).
- Select two or more adjacent rows: drag from the row heading for the first row to the row heading for the last row.
- Select the entire worksheet: click on the Select All button in the upper-left corner of the worksheet frame.
Oh, and if you want to read up on how to quickly move the cell pointer in Excel, have another look at http://www.roem.co.uk/tip_245.html
Until next week.
PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.
Home
Training
Support
Clients
Contact Details
News
Disclaimer