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

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

ctrl-a (twice in xl2003) will select all the cells.

clicking on that grey little button-like thingy directly above the row numbers
and directly to the left of the header for column A will also do it.

Hitting ctrl-a in xl2003 or ctrl-* (ctrl-shift-8) will select the current
region.



scurtin wrote:

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

--

Dave Peterson