Copying formulas or values to all used rows

Just a suggestion: as it is cumbersome to copy formulars or values all the way down in a column to all active rows you are suggesting a hack with an "x" one row below where you want to stop copying. That way it is so much easier to select the range you want to copy the same formula to.

You demonstrate and explain that in the Excel base course and are using it e. g. in lection 3 of https://learn.365datascience.com/courses/data-visualization/dashboard-in-excel-creating-a-drop-down-list-and-radio-buttons-in-excel/.

I was very impressed when I saw this hack because it saves so much time. But when I showed a colleague of mine who is also processing large datasets he said: "Ok, that is fast. But why don't you simply select the cell you want to copy and double-click on the rectangle at the right buttom of the cell cursor (this small rectangle)" Et voilà. That is again so much faster. There is one situation though where your "x"-hack is more suitable: if the data contains gaps in the rows.