Forum Discussion

LOGara27's avatar
LOGara27
Copper Contributor
Jul 19, 2022

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 D,E,F,...,AK are hidden. My table ranges from column A to AC, so when I copy it into such sheets, most of the table is hidden. Is there a way to avoid this or do I have to 'unhide' all those columns on the sheet into which I'm copying the table? 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    LOGara27 

    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.

Resources