Support Board

Date/Time: Sat, 04 May 2024 16:08:48 +0000

Post From: Spreadsheet: Insert rows between row #2 and row #3

[2019-10-12 13:22:35] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
is there a way to insert blank rows between row #2 and row #3 in the spreadsheet? No. Each row is a chart bar, with the current bar in row 3 and earlier bars in rows below. There are no rows for bars in the future. Depending on what you are doing, it's possible to reference row 2 in formulas to get 1 bar in the 'future', but it can't be displayed, and it usually requires a reference to ROW()=3 to trap errors. If I understood why you need to insert formulas between rows that always correspond to chart bars, I might be able to offer a way to accomplish what you want.