3 ways to select visible cells in Excel
What do you do when you have to copy a range of cells in Excel and paste it somewhere else?
In most cases, the below three steps get the work done:
Select the cells that you want to copy.
Copy the cells (Control + C).
Select the destination cell and paste these cells (Control + V).
But what if you have some hidden cells in the dataset?
Then – these above three steps are not enough.
In that case, you need to first select the visible cells in the dataset, and then copy paste this data only.
In this video, I will show you 3 ways to select visible cells in Excel:
-- Using the keyboard shortcut (ALT + ; for windows and CMD + SHIFT + Z for mac)
-- Using the Go To Special dialog box.
-- Using the Select Visible Cells command in the Quick Access Toolbar
You can read more about this here: https://trumpexcel.com/select-visible...
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch video 3 ways to select visible cells in Excel online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 06 December 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 74,294 once and liked it 524 people.