Ctrl D

[Mariahballmer]

Does Ctrl D only paste/fill values in visible cells?

 

[shg]

What happened when you manually hid some rows and tried it?

When you used autofilter to hide some rows and tried it?

 

[Mariahballmer]

It appears to only paste/fill in the visible cells but I wanted to be sure. I thought someone could confirm. I don't want to continue to use and find out some hidden cells are also being sporadically filled in error.

 

[Teeroy]

I generally use the handle to fill, so I thought I'd test this.
For me it fills in whether rows are visible or not (excel 2016).

 

[Mariahballmer]

Thanks. We're on 2013 using the filter then Ctrl d fill. What is the handle to fill?

 

[shg]

When you select a cell or range, there's a small square at the bottom-right of the selection marquee. That's the fill handle.

If you hover the mouse over it, the cursor changes to a cross. Then you can right-click and drag it to copy.