How do I reduce the columns outside my data?
 

I'm using Excel 2007 and somehow the worksheet created columns to the right
of my data that affects my horizontal scroll bar. All data is deleted but the
scroll bar won't revert back to the utilized area of the worksheet.

How do I reduce the columns outside my data?
 

Look he

http://www.contextures.com/xlfaqApp.html#Unused

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JFort" wrote in message
...
I'm using Excel 2007 and somehow the worksheet created columns to the
right
of my data that affects my horizontal scroll bar. All data is deleted but
the
scroll bar won't revert back to the utilized area of the worksheet.

How do I reduce the columns outside my data?
 

After deleting the columns you must save the workbook to reset the range.

Do not just "clear contents".


Gord Dibben MS Excel MVP


On Mon, 14 Sep 2009 13:00:01 -0700, JFort
wrote:

I'm using Excel 2007 and somehow the worksheet created columns to the right
of my data that affects my horizontal scroll bar. All data is deleted but the
scroll bar won't revert back to the utilized area of the worksheet.