DON'T PASTE IN HIDDEN COLUMNS

S

SHERRY

IS THERE A WAY THAT I CAN HIDE VARIOUS COLUMNS ON MY
WORKSHEET AND PASTE SOMETHING FROM ANOTHER WORKSHEET ONTO
ONLY THE UNHIDDEN COLUMNS.

THANKS SHERRY
 
P

Poh

Hi
Try this
Select the range (inclusive of hidden column), click Edit
Goto > Special > Visible cells only (system will select
those cells that are not hidden). Then, carry out the
usual copy and paste action.
 
Top