I was doing a very quick search and found nothing, but as I read you
thread I was thinking about "joining" groups
Highlite the columns you want to hide and goto
Data=Group and Outline=and select group
Now there will be a "-" sign above your columns click on the minus sig
and the group will hide, there are also numbers at the side of th
column you can click to hide columns, this also works for rows,
you can have many grouped columns and rows.

If you don't like using the groups method, you can always try you
macro recorder , like end,= takes you to the last cell with data in
row ...

--
davesexce
-----------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread.php?threadid=52004