« Robots at the library | Main | OverDrive Updates - Fall 2014 Edition »

Super secret Excel shortcut - "copy visible"

If you do a lot of work in Excel, you may hide the columns you aren't working with or filter the data to see only certain information.

What happens if you copy something that spans that hidden data? The hidden data is copied (and pasted) too... UNLESS you first use

alt + ; 

and then do your copy. This will copy only the visible cells.


Video example: https://www.youtube.com/watch?v=J3-9x_3hoTg  (2:08)


For those folks who prefer Excel menus, the full steps to copy visible cells using the Excel menus can be found here: http://office.microsoft.com/en-001/excel-help/copy-visible-cells-only-HA010342322.aspx


Feed You can follow this conversation by subscribing to the comment feed for this post.

Post a comment