2009/6/17 Gene Young <[email protected]> > Harold Fuchs wrote: > >> >> >> Errm. *Please* try what I suggested. Having selected row 8, move the >> cursor >> down to row 9 and then ***hit shift and space*** that is hold down the >> shift >> key and press space. Row 9 becomes selected. The effect is *exactly* what >> the OP said he wanted. >> >> You need to go back and re-read the original post. Dotan's friend > claimed she could highlight a row and, by using the arrow keys, move the > highlight (selection) to the next row down thereby highlighting the > information she was working with.
Errrm. "... thereby highlighing the information she **was** (?????) working with". That makes no sense. It was this I was referring to. She wanted to be able to highlight a row of > information and, with one keystroke (the arrow key) move the highlighted > area to the next row she was going to work with. This can not be done in > either Excel or Calc. > Errm. No. I think you need to re-read the OP's question. The OP's friend wants to *move* the highlight from the row she just finished working with to the row she wants to start on next. In other words, having finished with row 8 she wants to unhighlight it and highlight row 9 which is the one she wants to work on next. She wants to do this from the keyboard. She can using the method I described. As I said, it's not one key but two - down and then shift/space. Or, if you record a macro and assign it to a key then it's just that key. Dotan, *please* ! Put me out of my miser. (and everyone else on this list). > > > > I think you, Gene Young, are trying to move the **data** down. >> > > No, I am extending the highlight down, one row at a time so that the last > highlighted row is the row in current use. There is no moving of data, only > the highlighting of the selection. > > That is *not* > >> what the OP wants. The OP's friend has a list of data in rows. Having >> worked >> on one row (say #8) she now want to concentrate on row 9. Concentration is >> aided by having the "current" row highlighted. It's analogous to putting a >> ruler on the page so that data from one row are not confused with data >> from >> another and you can more easily "read along the row". >> > > Agreed, see above. The point is that she wanted to do it with single > keystrokes. It can't be done. If you are arguing that it can't be done with a single arrow press then you are right and you can claim your prize. It's not one I'd want, though. In Excel you can EXTEND the SELECTION one row at a time with SHIFT+DOWN > ARROW, making your row of interest either the last highlighted row or the > first row below the highlighted selection. The OP doesn't want to *extend* the selection. He wants to *move* it. From row 8 to row 9 so that before the move *only* row 8 is highlighted and after the move *only* row 9 is highlighted > Either method accomplishes placing the focus on the desired row. In Calc, > it only extends the selection or the first CELL in the highlighted row. (It > SHOULD extend the selection across the entire row. I don't know if this is > a bug or by design.) Thus her desired action, moving the row highlight down > with a single keystroke, is not possible in Calc. This means she must > resort to the two keystroke method you suggested. Only a sleight delay > admittedly, but not exactly what the OP wanted, which is what I was pointing > out. > > > -- > > Gene Y. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- Harold Fuchs London, England Please reply *only* to [email protected]
