Active row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Question
Is there a way to display the row containing the active cell with a different background color. In the same manner that is displayed when the row is highlighted. I have a visual problem that makes it difficult to chase items left to right in the same row

Question
Is the a way to display the row number on the right side of the display screen as well as the left side

Thanks in advanc

Jim
 
Jim, Question 1, have a look at chip's row liner addin at
http://www.cpearson.com/excel/rowliner.htm

Question 2, I don't think so

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **


JimO said:
Question 1
Is there a way to display the row containing the active cell with a
Click to expand...
different background color. In the same manner that is displayed when the
row is highlighted. I have a visual problem that makes it difficult to
chase items left to right in the same row.
Question 2
Is the a way to display the row number on the right side of the display
Click to expand...
screen as well as the left side?
 
JimO,

Question 2:

You could put =Row() every few columns, and copy down with the fill handle.
Or if the table isn't wide enough to require scrolling, just put it in a
column at the right. You could format it with a different text color, a
background color, different font, or whatever makes it easy to spot.

If you're entering into, or updating a table (has column headings, and one
row per record), using Data - Form may be suitable. It puts one row at a
time in the dialog box, oriented mostly vertically.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

JimO said:
Question 1
Is there a way to display the row containing the active cell with a
Click to expand...
different background color. In the same manner that is displayed when the
row is highlighted. I have a visual problem that makes it difficult to
chase items left to right in the same row.
Question 2
Is the a way to display the row number on the right side of the display
Click to expand...
screen as well as the left side?
 
Back
Top