Dynamically Resize Columns?
 

Hi,

I have a worksheet where all my data & graphs fit perfectly on m
screen at the current resolution. I now need to add another tw
columns, which will spoil the worksheet totally ;-(

Not all my data needs to be seen at one time and I can manually hid
and unhide columns for the time being. However I’m sure I’ve see
worksheets with small ‘+’ and ‘–‘ buttons ay the top or columns (ma
have been rows only) to collapse if needed. Can anyone point me in th
right direction

--
dazma
-----------------------------------------------------------------------
dazman's Profile: http://www.excelforum.com/member.php...fo&userid=2590
View this thread: http://www.excelforum.com/showthread.php?threadid=39910

Dynamically Resize Columns?
 

The + and - symbols are created through the Group function on the Data menu.
Select the rows or culumns you want to group. Select Data - Group and Outline
--
HTH...

Jim Thomlinson


"dazman" wrote:


Hi,

I have a worksheet where all my data & graphs fit perfectly on my
screen at the current resolution. I now need to add another two
columns, which will spoil the worksheet totally ;-(

Not all my data needs to be seen at one time and I can manually hide
and unhide columns for the time being. However Im sure Ive seen
worksheets with small €˜+ and €˜€“€˜ buttons ay the top or columns (may
have been rows only) to collapse if needed. Can anyone point me in the
right direction?


--
dazman
------------------------------------------------------------------------
dazman's Profile: http://www.excelforum.com/member.php...o&userid=25903
View this thread: http://www.excelforum.com/showthread...hreadid=399101

Dynamically Resize Columns?
 

I was about to add lots of little buttons with VB code to change th
proerties of the colums - This looks and works much better

--
dazma
-----------------------------------------------------------------------
dazman's Profile: http://www.excelforum.com/member.php...fo&userid=2590
View this thread: http://www.excelforum.com/showthread.php?threadid=39910