Forum Discussion
Zendort
Mar 11, 2020Copper Contributor
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 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.
- To only select the visible cells, not the filtered out ones, try pressing Alt ;
3 Replies
- SaviaSteel ContributorThe 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.