How to Select Only the Visible Cells in Excel 2016 and Prior – Best review and report

There are hundreds of articles on our site that can benefit all of us, whether there is a problem in your phone or your laptop or anything you want is not available on our website at the moment, we are ready to provide it to you as soon as possible.
All you have to do is just to communicate with us and tell us what you want, can now be read and enjoy reading the following article:

Excel can act unexpectedly when you copy and paste a range of cells. By default, the program will copy and paste all of the cells–even if some have been hidden. Here’s the time-saving shortcut that will select only the visible cells in Excel, ignoring those hidden rows and columns.

Whether you’ve used a filter that hides certain cells, collapsed an outline, or hidden specific rows or columns, sometimes you want to work just with the data you see. You can select the visible cells with a keyboard shortcut or with the Go To Special menu.

Select Only the Visible Cells with Alt+;

1. Select the range of cells in your worksheet.

excel selected2. Press Alt+; (hold down the Alt key and then press the semicolon key). On a Mac the shortcut is Cmd+Shift+Z.

excel shortcut

Excel will exclude all the hidden data from your selection and then you can copy (Ctrl+C) and paste (Ctrl+V) only the visible cells.

Select Visible Cells Only with the Go To Special Menu

The keyboard shortcut is the quickest way to select visible cells only, but if you don’t use this feature often, you can instead use the Go To Special menu.

1. Select the range of cells in your worksheet.

2. Click the Find & Select button on the Home tab, then click Go to Special…

excel gotospecial3. Select Visible cells only…

excel gotospecial2

4. Click OK.

Now you can copy and paste without worrying about the hidden data being pasted also.

Recommended by
Outbrain

 

Leave a Reply