Ask Your Question

how do I copy formulas into consecutive cells? [closed]

asked 2018-03-17 18:07:04 +0200

jimalo gravatar image

In Excel, this was an Alt-E-D function.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by floris v
close date 2018-03-24 22:53:38.772581

2 Answers

Sort by » oldest newest most voted

answered 2018-03-17 18:32:07 +0200

Liberty Belle gravatar image

updated 2018-03-17 18:33:27 +0200

You simply copy the source cell.

Then in the target cell, Edit > Paste Special

This brings up a whole menu of options, and you'll need to go to the documentation to learn about them.

There are some bugs. I reported one here. Linking is problematic right now.

Check and be sure the formula works the way you want before going too far in your spreadsheet.

edit flag offensive delete link more


That works! Thanks!

jimalo gravatar imagejimalo ( 2018-03-17 18:50:47 +0200 )edit

You are most welcome. If you don't mind, could you please take a moment and hit the checkmark on the left side of the answer I gave. That will mark this question as answered. It's really helpful for others to see that something is resolved.

Liberty Belle gravatar imageLiberty Belle ( 2018-03-17 19:18:23 +0200 )edit

We have a whole discussion going about why people don't mark more questions as answered. You may have some insight you'd like to contribute to that as well.

Liberty Belle gravatar imageLiberty Belle ( 2018-03-17 19:20:51 +0200 )edit

answered 2018-03-17 18:51:08 +0200

Lupp gravatar image

updated 2018-03-17 18:58:00 +0200

Ordinary filling down from the first row into the subsequent ones of the previously selected range (most used): Ctrl+D.
Using the shortcut keys letters of the menu path it would be Alt S I D.

For the additional menu items under Sheet > Fill not shortcut is preset.

For "formulas only" and similar specialties you need Edit > Paste Special.... (See previouis answer.)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-03-17 18:07:04 +0200

Seen: 364 times

Last updated: Mar 17 '18