We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Copy and Paste Excluding Hidden Columns


When I copy and paste in the grid, how can I get it to ignore hidden columns?

As of now, if I paste a group of cells that span a few columns and then paste those cells in to another range of columns, in which one of those within that range (or more) are hidden, the pasted cells will also paste the data into the hidden columns. I want any columns that are hidden to be excluded from copy/paste operations and that when pasted they would skip the hidden columns and continue to paste the cells in to the next available non-hidden column.

1 Reply

PM Piruthiviraj Malaimelraj Syncfusion Team March 15, 2017 03:33 PM UTC

Hi Shawn, 

Thanks for your interest in Syncfusion products. 

We could able to understand your scenario and we have analyzed our source deeply and with excel sheet also. The copied values will be pasted in hidden columns also, this is the default behaviour of the grid and excel also. It could not be achieved by any workaround. If you want to exclude the hidden columns from pasting the values, remove that columns instead of hiding. But the values of that column will be deleted. Please let us know if you have any other queries. 


Live Chat Icon For mobile
Up arrow icon