1. Home
  2. MS Office

How To Select Only Visible Cells In Excel

Excel lets you hide columns and rows.This is a great way to make a clean, presentable Excel sheet. You can insert formulas in rows and columns, and hide them later. It also keeps other users from editing your formula. If the formula isn’t visible, chances are people are less likely to try and edit it. Hiding rows and columns is also a good way to hide the data used to create graphs or dashboards in the spreadsheet. The only problem with hidden cells is that while they are invisible, Excel still selects and copies their content. It still reads the data in hidden rows and columns even if it doesn’t show it.  This is a problem if you want to copy only the visible cells in a sheet. Here’s how you can select only visible cells in Excel, and copy their content.

There’s two ways to select only visible cells in Excel. One is the easy keyboard shortcut way. The other is the dragged out, ribbon menu method. We’re going to detail both.

Select Only Visible Cells In Excel – Keyboard Shortcut

Open the Excel sheet you want to copy cells from. Select the cells you want to copy. Don’t worry if it includes hidden rows and columns in the selected cell range.

Once you’ve selected the cells, type the Alt+; shortcut. A white outline will appear around the selected cells.

This outline means that only the visible cells are selected. Go ahead and use the Ctrl+C and Ctrl+V shortcuts to copy and paste the content of the visible cells.

Select Only Visible Cells In Excel – Menu

Select the cells you want to copy. Again, don’t worry if the selected range includes hidden columns and/or rows. On the Home ribbon, click the Find & Replace button and select ‘Go to special’ from the menu.

A window will appear with a long list of options to select. Select the ‘Visible cells only’ option and click ‘Ok’. The same white outline that appeared around the selected cells when you tapped the Alt+; keyboard shortcut will appear again. It shows that only the visible cells are selected. Go ahead and use the copy/paste shortcuts or buttons to copy and paste the cell contents.

It goes without saying that the keyboard shortcut is the easiest way to select only visible cells in Excel. It’s an oddly obscure keyboard shortcut and the menu option is very well hidden. Users who don’t know about the Alt+; shortcut paste cells in an intermediate worksheet and clean it before pasting the content where they need to. It’s hardly convenient though still easier than going through the menu options. That said, Alt+; is a keyboard shortcut you want to write down somewhere.

Leave a comment

  • M­a­n­y p­e­o­ple desire t­o ha­v­e a go­o­d earnings at their, bu­t t­he­y do­n’t kno­w ho­w t­o exactly d­o th­at o­n th­e Int­ernet. Th­ere ar­e a l­ot of w­ays t­o ea­rn am­ount of mo­ney, b­ut wh­enev­er p­eopl­e t­ry th­at the­y g­et tr­app­ed in a s­cam, Thus Now I am sh­aring wi­th yo­u a g­enuine an­d gu­arante­ed w­ay f­or fre­e to ea­rn hug­e am­ount of mon­ey a­t ho­me.I am earning atleast $10000 monthly since a whole year.Its an internet based job and not difficult to do, Even a little child can do this work and make money online. If you want a happy and wealthy life then you should copy and paste this website in web browser and then follow instructions to get started right now and earn Thousands Over the internet……….. http://ru­.­vu/by3ar

  • Yeah I obtained progress to receive 98 Thousand Five Hundred and Sixty Seven dollars.I found out about this job half-year prior and a pair of months back I surely tried out and I have made superb bucks. It is extremely helpful for me individually and also my family members.My siblings are uncertain to to find how I settled my online career and my Lifestyle in few time. Thanks to Almighty for this….You surely can get similar amount of payment, if you have a PC and net connection in your household. Any other technical information are not necessary to work on this job. I’m Liking it and you will also love it and you will not pardon yourself if you not visit the details >>>>>> ADULTADDA.NET/2YL