Suppose that column B is hidden:
Place your mouse on the line between column letters A and C. Note the
vertical black line with two headed arrow. Now move your mouse, don't drag
it, ever so slightly to the right until the vertical line changes into a
double vertical line with a which line down the center. Double-click.
To use this for more than one column, say B:E are hidden, highlight A:F and
proceed as above. This technique works even when the hidden columns contain
On the other hand if those columns contain data double-click when you see
the single vertical line with the two-headed arrow.
If this helps, please click the Yes button