Tag Archives: hide

How to keep the columns still hidden after copying the whole table? | Excel 2007

First unhide the columns. If you want to copy the whole table then to unhide all the columns hidden, simply select the entire worksheet and click on the column labels with your right mouse button and choose “Unhide”. When this is done, select and copy the data. Afterwards use the „Undo” command to hide all the columns that were unhiden. Now paste the previously copied data.

Continue reading