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 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
