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…
How to Select Only the Visible Cells in Excel 2016 and Prior
No comments:
Post a Comment