Filling cells

Discuss the spreadsheet application

Filling cells

Postby Shatonapples » Wed Dec 05, 2007 10:25 am

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.
Shatonapples
 
Posts: 2
Joined: Wed Dec 05, 2007 10:23 am

Re: Filling cells

Postby Hagar Delest » Wed Dec 05, 2007 10:35 pm

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

NB: moved your thread to the Calc forum.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28626
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Filling cells

Postby Shatonapples » Thu Dec 06, 2007 1:04 am

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.
Shatonapples
 
Posts: 2
Joined: Wed Dec 05, 2007 10:23 am

Re: Filling cells

Postby huw » Thu Dec 06, 2007 11:02 am

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.
huw
Volunteer
 
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm


Return to Calc

Who is online

Users browsing this forum: RusselB and 20 guests