At 22:49 10/05/2009 +1000, Chris Paterson wrote:
When using Calc and I want to repeat the entry above it, I know I can use
the mouse to click on the edge of the box and drag it down to copy it, but
I prefer to use the keyboard. When I used to use MS Word, I could press
Ctrl+D and this used to fill down the entry. I've looked through the help
files, but can't find out how to do it in Calc.
Ctrl+D does something very similar (but perhaps more general) in Calc -
but only with strings, it seems, not with numbers (or other items). It
brings up a list of (up to 200) entries appearing in the same column. You
can select the required entry using the arrow keys or jump close to it by
typing its initial letter. Pressing Enter completes the process.
I trust this helps.
Brian Barker
thanks Brian,
I also had a reply from Tom who showed me how to change the list of items to
just fill down the entry from above, which is just what I wanted.
thank you
chrisP
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
