Forum Discussion

Copper Contributor

Mar 11, 2020

Solved

Excel 2019 doesn't let me Copy and Paste all formulas

Well, recently I acquired Excel 2019 and its recent updates and then ...when I copy a formula in Excel, the punctuated cells appear to me and not in its complete one (which already seems strange to m...

excel

Formulas and Functions

office 365

Savia
Mar 11, 2020
To only select the visible cells, not the filtered out ones, try pressing Alt ;

Savia

Iron Contributor

Mar 11, 2020

The rest of what has been copied has been pasted on to the rows which are currently filtered out. If you clear the filter you will see that the pasted cells are there.

Zendort

Copper Contributor

Mar 11, 2020

Savia Unfortunately, it does not continue down and does not stick completely with the filter as it did in Excel 2016 😞

Savia
Iron Contributor
Mar 11, 2020
To only select the visible cells, not the filtered out ones, try pressing Alt ;