First time here? Check out the FAQ!
2018-12-11 17:55:50 +0100 | received badge | ● Famous Question (source) |
2018-09-27 23:30:46 +0100 | received badge | ● Notable Question (source) |
2018-08-08 17:33:28 +0100 | received badge | ● Popular Question (source) |
2018-08-08 09:07:56 +0100 | commented answer | Calc - how to fill a series from multiple rows that all reference the same row That's brilliant, thank you! It's only a few hundred rows, so shouldn't be a problem. It's for an automated invoice spre |
2018-08-08 09:07:24 +0100 | commented answer | Calc - how to fill a series from multiple rows that all reference the same row That's brilliant, thanks! It's only a few hundred rows, so shouldn't be a problem. It's for an automated invoice spreads |
2018-08-08 08:58:08 +0100 | marked best answer | Calc - how to fill a series from multiple rows that all reference the same row I have cells in a few rows that all reference one row on another sheet:
When I select these cells and drag the fill handle to fill the cells below, Calc fills them like this:
I guess it's doing this because each new row is three cells below the original row. This is not the behaviour I want - I want to fill them in a series, like this:
Any ideas how to do this? I'd like to use either a formula or a manual way of doing this - I'm not familiar with macros so would rather avoid if possible, please. |
2018-08-08 08:58:08 +0100 | received badge | ● Scholar (source) |
2018-08-07 21:16:34 +0100 | asked a question | Calc - how to fill a series from multiple rows that all reference the same row Calc - how to fill a series from multiple rows that all reference the same row I have cells in a few rows that all refer |