Something about the scroll bar

[Guest]

Hi, Because englñish is not my first lenguaje and because of the difficulty
of the question, please try to understan what I'm asking for.


Ok, go to an exel new worksheet and with the scroll bar go to the cell A300,
there write something (ex. fdslkgjt) and press enter, then, errase the cell
A300,
go to the cell A1 and look the scroll bar Small???

I don't know why excel, althought you errase the data, still defining the
cell A300 as a part of the sheet.
This is not important if you see as the excel part, a few KB more for the
file and that's all, but Imagine when you use acces¡¡¡¡¡
the whole 300 records (1 MB aprx) appears in you tables, queries and
reports, and also the queries take much longer to appears; How to tell excel
that the sheet is just of the writed zone and not of all what excells thinks
they are

PD. Defining or Errasing from acces the records is not a possibility because
the sheet is linked and the program doesn't allow to modify the exel linked
page.

TIA

 

[Anne Troy]

To completely clear a cell, you must hit Edit-->Clear-->All and then save
the file.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Norman Jones]

Hi Filo666.

To restore the worksheets used range to correspond to the worksheets data
range, see Debra Dalgleish's suggestions at:

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

Congratulations on expressing your problem so well.

 

[Guest]

Tanks Anne and Norman your information is very helpfull

Regards

 

[Guest]

Sorry again,
But the scroll bar doesn't returns to his original size¡¡¡¡¡
How to returne it?????

 

[Anne Troy]

Filo, did you SAVE the file first?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[STEVE BELL]

What everyone has been trying to explain is that excel extends the worksheet
to the last row and last
column where something has been entered, even after the cell has been
cleared.

Saving the workbook will adjust this.

But sometimes we put in a space into a cell and think it is empty...

So ... Hold Ctrl and hit End (Ctrl + End)

this will move the selection to what Excel thinks is your last cell.
If you have something in A25 and something in M2 the last cell will be
M25

hope this helps...