Page 1 of 1

Filling cells

PostPosted: Wed Dec 05, 2007 10:25 am
by Shatonapples
I always found it handy to be able to hit ctrl+r or ctrl+d to fill right or down, respectively, in excel. Is there any chance that there's an easy way to add that into calc?

Thanks in advance.

Re: Filling cells

PostPosted: Wed Dec 05, 2007 10:35 pm
by Hagar Delest
What do you mean by "fill right" or "fill down" ?

NB: moved your thread to the Calc forum.

Re: Filling cells

PostPosted: Thu Dec 06, 2007 1:04 am
by Shatonapples
There's a fill option in both excel and calc. I was wondering if there was a way for me to set the hotkey for fill down to ctrl+d and fill right to ctrl+r.

Re: Filling cells

PostPosted: Thu Dec 06, 2007 11:02 am
by huw
I recorded macros of doing a copy-down & a copy-right, and assigned them to shortcuts.

Beware if you try to do this for fill (drag-fill), Excel and Calc treat hidden cells differently from each other.