Our Excel workbook is full of examples demonstrating all our Excel tips and techniques accompanied by a ten page notes explaining each tip and trick. None of our tips and tricks are trivial. For example, they don’t include such tips as keystroke short cuts. They are all intended for advanced Excel users. With these powerful, sophisticated, and esoteric tips and tricks, you can boost your office productivity significantly. Find out what you have been missing out on over many years of using Excel. This product requires Excel 2000 or higher.
Range Selection Techniques (17 Examples)
Select a cell or range quickly without scrolling.
You want to select a specific number of cells in a row Starting from a
particular cell in a row. When the task involves a large number of cells, it
is not easy to figure what cell should be the last cell in the row. You will
have to turn on the RIC1 reference style (Tools>Options>Views).
For example, you need to select 75 cells from the cell C125. You turn on the R1C1 feature and figure the last (the 77th) column to select. Then you scroll down to C125 and across 75 cells to select the desired range. Lastly you turn off the reference style. What a chore! If you try to select the last filled (not just formatted) cell in a row where there are many filled cells interspersed by blank cells, then you will have more aggravation.
With our tips, however, you will find these tasks a breeze. You don't have to do any scrolling. You don't have to turn on/off the reference style. It takes only a few quick keystrokes!
We have 17 examples demonstrating this kind of techniques.
1) Select the last filled (not just formatted) cell in a row.
2) Select the last filled (not just formatted) cell in a column.
You have a long non-contiguous single column range made up of filled and unfilled cells and want to select the last filled cell without scrolling.
3) Select the last filled cell in a worksheet.
Do you want to select the last non-empty cell in your worksheet without scrolling?
The Excel's built-in method (Edit>Go To>Special>Last Cell) does not
necessarily take you where you want. Press the F5 key and type "LC"* in the
reference box and press the Enter key. As long as your last cell is not on
the last row (65536), it will be selected in about 10 seconds. Although this
method is a little slow compared to the built-in feature, it is always
4) Select a blank column next to an existing one-column range.
You have a long non-contiguous single column range made up of filled and unfilled cells and want to select a new blank range identical in size right to the filled range. You do not want to use the mouse to scroll all the way down and want to accomplish this task without using any macro or VBA code.
5) You want to select a particular number of cells, say 125 cells, across in a row beginning with the last filled cell in a row.
You do not want to turn on the R1C1 reference style setting to count the number of columns.
6) Select a range from a cell in a row to the last filled cell in the row.
7) Select the last N, say 5 cells to the left of the last filled cell in a row.
8) To select 10 cells to the right of the current cell in a row,
9) To select the entire column containing the last filled cell in a row,
10) Select a single row range from the active cell to a particular column, say the 15th column.
11) Select a specific number of columns, say, ten columns from a current column, say the column C.
12) Select a specific number of cells, say, 75 in a row from a particular cell, say C125.
13) Select a specific number, say 120 cells to the right of a particular cell, H5.
14) Select a specific number, say 10 columns to the right from a particular column, say the column H.
15) Select a specific number, say 15 columns to the right from a particular column, say the 25th column.
16) Select the cell with the maximum value in a given range, say a named range called "TestData".
17) Two methods to select multiple named ranges.
More Excel Tips & Tricks
Excel Tips & Tricks Start & Find Your Excel VBA Procedure Quickly From Your Workbook Window & Alternatives to Excel Array Formulas & Sumproduct & Other Useful Regular Excel Formulas & Advanced Filter & Other Tips
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft