Ask Your Question

how select only visible cells if rows/columns hidden? [closed]

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-24 14:03:53.465622

1 Answer

Sort by » oldest newest most voted

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

Edward gravatar image
edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 10,272 times

Last updated: Feb 12 '17