Excel: Select Visible (1)

I built my Social Media spreadsheet in an Excel spreadsheet with all the tools I want built in (formulas, conditional formatting and data validation). Ultimately, I will transfer my information into a stripped down spreadsheet in csv (comma separated) format. This is the format that Google Calendars will accept.

When I transfer my posts to this spreadsheet, I don’t want to include any blank rows AND I only want to copy and paste once. How do I perform this little piece of magic? I use the Excel command for selecting visible cells only.

Go To Special Dialog, select Visible cells only
Go To Special Dialog, select Visible cells only

Tucked away in the Go To Special dialog is the option for selecting only the visible cells in a region. This takes what could be multiple copy/paste operations and condenses them into one step.

First filter your data so that blanks do not appear, then press the F5 function key to bring up the Go To dialog box.

Press the Special button to open the Go To Special dialog box, choose Visible cells only and press OK. Now when you copy the selected cells, only the cells you can see are copied.

In my next post I’ll show the method to put this useful button on your Quick Access Toolbar.


This post is originally from 2016. If you want help with the newest and classic features in Excel drop me a line at catharine@mytechgenie.ca