3 ways to select visible cells in Excel through Excel formula and keyboard shortcut.
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
3 ways to select visible cells in Excel through formula in excel and keyboard shortcut.
#excel #excelcourse #tips #exceltutorial #onlineclasses #dashboard #free #courage