Excel - Copy and Pasting over Visible Cells?

[mehmood180]

Microsoft 365 Excel -

When I am using the filter and some of the cells get hidden. Then when i paste a formula over the visible cells it does this to the hidden cells also. I want to paste formula over visible cells only.

Find and select > Go to Special > Visible cells only. This sometimes works but i would like to set this as standard on my spreadsheet, like it has been set on other spreadsheets that i have used before? So that this will not affect any of the hidden cells?

Some spreadsheets it does this automatically and some it does so obviously there is a setting somewhere?

Can anyone please help?

[#2]

Hi Mehmood,

Pasting data into filtered cells, it works only when you paste one item only, it you want to paste more than one item you will get error message, as I know this is one of excel limitation in the pervious versions, I not sure if Microsoft fix this issue with Excel 365