View Single Post
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

If there are *no* spaces (empty rows, columns), you could try this to select
from the current cell to the last non-blank cell in the row *or* the column:

Select the cell.
Hover the cursor over the lower border of the cell until it changes to an
arrow.
NOW, *double click*.
The focus automatically moves to the last non-blank cell in the column.
Take this a step further.
Do this again, *but hold down <Shift.
You have now selected your column.

This works for *any* of the cell borders, so that you can move and/or select
UP, Down, LEFT, or RIGHT from your present cell location.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"scurtin" wrote in message
...
Yes, I am an administrative assistant for a sub-contractor, and we list all
of the materials needed from two huge spec books into an Excel File. It
would be helpful to be able to bookmark within these files. We are talking
about 3000 rows on a worksheet.

Many times, I wish I could Edit/select all in Excel. I know I could type
the range, but this would be a great convenience to me.

Is there a possibility for either of these concepts?

Thank You Kindly,


Susan L. Curtin