Forum Discussion

mehmood180's avatar
mehmood180
Copper Contributor
4 years ago

Excel - Copy and Pasting over Visible Cells?

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?

excel
Formulas and Functions

1 Reply

  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    MCT
    4 years ago
    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

Resources