Forum Discussion
LOGara27
Jul 19, 2022Copper Contributor
Copying a table into a sheet with hidden columns
I have created a template for a table which I want to copy into other excel sheets. However, some of these sheets have columns hidden e.g. the following columns are displayed A,B,C,AL,AM,AN,... while...
SergeiBaklan
Jul 19, 2022Diamond Contributor
If you copy/paste entire columns, not ranges, target columns shall be un-hided.
If copy/paste range, you may Paste Special with keeping source columns width.