Filling cells

[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.

[Hagar Delest]

What do you mean by "fill right" or "fill down" ?

NB: moved your thread to the Calc forum.

[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.

[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.