Nice Idea, but didn't work, although I saved and exited the program.

"Jon Peltier" wrote:

The scrolling usually involves only what Excel thinks it the used range.
Excel in this case thinks your used range includes all columns.

Select the first column in your sheet that you consider blank. Click the End
button on the keyboard, then hold Shift and click the right arrow. This
selects all columns from the one you selected to the right edge of the
sheet. Right click on the column header and select Delete to delete these
columns, and whatever about them Excel thinks you are using. After saving
the workbook, Excel should now consider only the undeleted columns as the
used range.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"D_N_A" wrote in message
...
Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means
the
horizontal scroll bar is very not sensitive, and not helpful for using
only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A