I have selected the names of the columns, so It selected the whole column for
every column from around M untill the end. As I sayd earlier, the problem
appears only when the graphs are in the sheet, and disappears when they all
(and not anything else) are deleted. This is, I believe, the sorce of the
problem..

"Trekman" wrote:

On May 2, 2:19 pm, D_N_A wrote:
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

There is something that Excel thinks you have as valid data in columns
you believe blank. Scroll bar should normally be only those columns
you are actively using. Are you formatting rows by selecting the
entire row or are you selecting a finite range of cells to format? I
have seen many spreadsheets with lines or shading etc. that goes all
the way out to the limit. I believe this may be the problem.