Selecting range of cells without dragging

  • Thread starter Thread starter mika.
  • Start date Start date
M

mika.

Is there a way to select a range of cells in a column
without clicking on the first cell and dragging down to
the last cell? This becomes tedious when I want my first
cell e3 and my last cell to be e518, for example.

Thanks!
 
mika

Another option: If E518 is the bottom entry of the column, select E3, hold
shift and Ctrl and double-click the bottom border.

Andy
 
Hi

Or you can enter E3:E518 in the Name Box (the box to the left of the
formula bar) and press enter!
(Make sure type in Uppercase for the columns)

Anyone else? :-)

Tom
 
Back
Top