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

[Zendort]

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 me) ... and when pasting in another cell , they do not stick in their entirety, if not, the first 4 nothing more, I need to know how I can copy ALL of them and that they stick in their entirety, since if I work with giant tables I cannot be wasting time in reviewing the copies of the data.

Thank you very much and I hope you can help me!

Attached photo of what happens to me in Excel.

[#2]

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.

[#3]

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

 

[#4 · Accepted solution]

To only select the visible cells, not the filtered out ones, try pressing Alt ;