{"id":1973,"date":"2022-08-07T10:45:41","date_gmt":"2022-08-07T07:45:41","guid":{"rendered":"https:\/\/www.addictivetips.com\/?p=189957https:\/\/www.addictivetips.com\/microsoft-office\/how-to-select-only-visible-cells-in-excel\/"},"modified":"2022-08-07T10:45:41","modified_gmt":"2022-08-07T07:45:41","slug":"how-to-select-only-visible-cells-in-excel","status":"publish","type":"post","link":"https:\/\/tojikon.net\/en\/1973-how-to-select-only-visible-cells-in-excel\/","title":{"rendered":"How To Select Only Visible Cells In Excel"},"content":{"rendered":"

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\u2019t 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\u2019t show it. \u00a0This is a problem if you want to copy only the visible cells in a sheet. Here\u2019s how you can select only visible cells in Excel, and copy their content.<\/p>\n

There\u2019s 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\u2019re going to detail both.<\/p>\n

Select Only Visible Cells In Excel \u2013 Keyboard Shortcut<\/h3>\n

Open the Excel sheet you want to copy cells from. Select the cells you want to copy. Don\u2019t worry if it includes hidden rows and columns in the selected cell range.<\/p>\n

Once you\u2019ve selected the cells, type the Alt+; shortcut. A white outline will appear around the selected cells.<\/p>\n

\"\"<\/span><\/p>\n

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.<\/p>\n

Select Only Visible Cells In Excel \u2013 Menu<\/h3>\n

Select the cells you want to copy. Again, don\u2019t worry if the selected range includes hidden columns and\/or rows. On the Home ribbon, click the Find & Replace button and select \u2018Go to special\u2019 from the menu.<\/p>\n

\"\"<\/span><\/p>\n

A window will appear with a long list of options to select. Select the \u2018Visible cells only\u2019 option and click \u2018Ok\u2019. 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.<\/p>\n

\"\"<\/span><\/p>\n

It goes without saying that the keyboard shortcut is the easiest way to select only visible cells in Excel. It\u2019s an oddly obscure keyboard shortcut and the menu option is very well hidden.\u00a0Users who don\u2019t know about the Alt+; shortcut paste cells in an intermediate worksheet and clean it before pasting the content where they need to. It\u2019s hardly convenient though still easier than going through the menu options. That said, Alt+; is a keyboard shortcut you want to write down somewhere.<\/p>\n","protected":false},"excerpt":{"rendered":"

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\u2019t visible, chances are people are less likely to try and edit it. …<\/p>\n","protected":false},"author":1,"featured_media":1974,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[36],"_links":{"self":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1973"}],"collection":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/comments?post=1973"}],"version-history":[{"count":0,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1973\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media\/1974"}],"wp:attachment":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media?parent=1973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/categories?post=1973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/tags?post=1973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}