ExcelBanter - how do i paste rows/columns avoiding hidden rows/columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i paste rows/columns avoiding hidden rows/columns (https://www.excelbanter.com/excel-discussion-misc-queries/218478-how-do-i-paste-rows-columns-avoiding-hidden-rows-columns.html)

perezli

how do i paste rows/columns avoiding hidden rows/columns

how do i paste rows/columns avoiding hidden rows/columns

Billy Liddel

how do i paste rows/columns avoiding hidden rows/columns

Two stages

Edit, Goto, Special, Current Region

Edit, Goto, Special, Visible

Then copy and paste asw normal.

Regards
Peter

"perezli" wrote:

how do i paste rows/columns avoiding hidden rows/columns

All times are GMT +1. The time now is 07:55 PM.