If you want to select copy paste only the visible cells in Excel:
We recently detailed the top 100 Windows Services because our technicians frequently need to know where they came from, what the default user is, and what those services really do. However, the IaaSVmProvider service did Read more…
Microsoft Office 365 licenses allow each user to install M365 on up to 5 different devices. So the question arises what happens when you have your 6th device? The answer is you will get error Read more…
We recently created a video on how to easily setup and operate MABS in which we explained the difference between Microsoft Data Protection Manager, Microsoft Azure Backup Service and the Microsoft Azure Backup Server (both Read more…
2 Comments
Peace · April 10, 2020 at 11:19 am
Thank you for this video about how to paste visible cells only. It works only if you paste the cells on a different sheet where cells are not hidden. If I try to copy from Col. A and paste it on Col. B on that same sheet where some cells are invisible, it does not work.
Can you please advise? I am using office 365.
Ian Matthews · April 13, 2020 at 8:04 pm
Hi Peace;
That makes sens. If the rows are hidde, they will be hidden when you paste. You could paste into a different worksheet (as you suggest) or workbook.