full row selection

U

Uitlander

please could anyone tell me if the full row selection can be set in Excel?
there was the option in word 2000 if I'm not mistaken. I mean when cursor is
pointed to a single cell, a full row is being highlated.

Click on the row number on the left side of the screen.
- this isn't about it, a little different capability. if i click the row
number and
then will click a key "->" or any other direction, the selection will
dissapear. and I want it to stay, it definetely was in Office2000.
 
D

David McRitchie

This is Excel not Word, to make a row selection
stick regardless of cursor position would severely
impact Excel usage. Since you indicate clicking on
the row number which selects an entire row is not the
same as what you want, I don't really understand what you want.

If you select the row, you can use the scrollers
to move around without affecting the selection.
If you want to add more rows or cells to the selection
you can use the Ctrl key, or to add a span of cells you
can use the Shift key.
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

You can make the cursor position show up better with
automatically drawn row and/or column lines around the active cell
with RowLiner, but it will affect your use of Undo (Ctrl+Z).
http://www.cpearson.com/excel/rowliner.htm

You can color (highlight) a row to make it stand out
using format, Conditional Formatting
http://www.mvps.org/dmcritchie/excel/colors.htm
http://www.mvps.org/dmcritchie/excel/condfmt.htm

A better explanation and purpose might help if the above
doesn't help you.

You could toggle a color on or off overriding previous
cell format color with an Event macro triggered by a double-click
http://www.mvps.org/dmcritchie/excel/event.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


Uitlander said:
please could anyone tell me if the full row selection can be set in Excel?
there was the option in word 2000 if I'm not mistaken. I mean when cursor is
pointed to a single cell, a full row is being highlated.

Click on the row number on the left side of the screen.
- this isn't about it, a little different capability. if i click the row
number and
then will click a key "->" or any other direction, the selection will
dissapear. and I want it to stay, it definetely was in Office2000.
 
U

Uitlander

A better explanation and purpose might help if the above
doesn't help you.
when i browse cells by "->" or "<-", or up and down, full row is being
highlighted, not selected, but highlighted (for convenience, if a row is very
long it is hard to find a value for example in 1 and 25 column in the same
row, so i'm forced to select a row manually, find a value and then again move
to a cell i was in). many editors have such a feature and Excel 2000 (not
word, sorry) had it.
 
B

Bob I

The selected Cell "Highlights" the Row and Column headers. IF you wish
to "scroll around" with the arrow keys and keep the selection, press
Scroll Lock key first. Now browse.
 
L

LÅ‘sha Leger

yes, it's a very interesting but still not that. I meant while browsing, the
row should be automatically highlighted like it was highlighted with "Fill
Color (set the background color)" instrument from Home -> Font section and
after moving to another row cell - dehighlighted.
 
L

LÅ‘sha Leger

erhhhh. to a cell in another row.

LÅ‘sha Leger said:
yes, it's a very interesting but still not that. I meant while browsing, the
row should be automatically highlighted like it was highlighted with "Fill
Color (set the background color)" instrument from Home -> Font section and
after moving to another row cell - dehighlighted.
 
B

Bob I

Well that "feature" has been gone for at least a couple versions now, so
not likely it will return. I suppose you could code VB to do that if you
really wanted it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top