Ask Your Question
1

how select only visible cells if rows/columns hidden?

asked 2017-02-11 18:13:54 +0200

Schweitzerbube gravatar image

updated 2017-04-08 14:14:28 +0200

ratrace gravatar image

I've hidden some rows & columns of data, and want to copy to another sheet the remaining visible data. If I just drag select the rectangle, do a Ctrl-c to the buffer and then Ctrl-v to the other sheet, I get ALL the data, not just the visible data. I thought Paste Special might do it, but I didn't see an option to paste only the visible cells. Thanks in advance if you can tell a Libre newbie how to do this! ^_^

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2017-02-12 21:51:58 +0200

Edward gravatar image
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-02-11 18:13:54 +0200

Seen: 307 times

Last updated: Feb 12