Is there a way to select some sort of table format so that, e.g., every 3rd row is a different color? That would help you keep track.
Regarding Martin's suggestion of filtering: (1) you could add a column at the beginning that is simply row number. That would be easy to fill in. And that would make filtering easy. (2) when filtering, you could show a small number of rows. That would make keeping track of which row you're on easier. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Haim (Howard) Roman Computer Center, Jerusalem College of Technology Phone: 052-8-592-599 (6022 from within Machon Lev) On Thu, Oct 18, 2012 at 4:47 AM, Martin Groenescheij < mar...@groenescheij.com> wrote: > I don't know how to highlight a row automatically, but why don't you use > the Auto Filter option. > Select a column with unique values (or multiple columns) so that there is > only one row visible. > > > On 18/10/2012 1:05 PM, lou ql wrote: > >> I am editing a calc file, and have to change data in discontinuous cells >> row by row. >> >> In order to avoid changing data of another row, I follow the steps for >> each: >> 1. edit data in one cell, e.g. C111 >> 2. highlight the whole row manually to help me to locate the the next cell >> that need modify, e.g. F111 >> 4. repeat highlight then select till this row finished. >> >> It will be helpful if the row can be highlighted automatically when I >> focus >> or edit a cell... >> >> > > ------------------------------**------------------------------**--------- > To unsubscribe, e-mail: > ooo-users-unsubscribe@**incubator.apache.org<ooo-users-unsubscr...@incubator.apache.org> > For additional commands, e-mail: > ooo-users-help@incubator.**apache.org<ooo-users-h...@incubator.apache.org> > >