how select only visible cells if rows/columns hidden?

edit

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! ^_^