Something about the scroll bar
 

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

Something about the scroll bar
 

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"filo666" wrote in message
...
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

Something about the scroll bar
 

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.

---
Regards,
Norman



"filo666" wrote in message
...
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

Something about the scroll bar
 

Tanks Anne and Norman your information is very helpfull

Regards
"Norman Jones" wrote:

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.

---
Regards,
Norman



"filo666" wrote in message
...
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

Something about the scroll bar
 

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

"Norman Jones" wrote:

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.

---
Regards,
Norman



"filo666" wrote in message
...
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

Something about the scroll bar
 

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"filo666" wrote in message
...
Sorry again,
But the scroll bar doesn't returns to his original size¡¡¡¡¡
How to returne it?????

"Norman Jones" wrote:

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.

---
Regards,
Norman



"filo666" wrote in message
...
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

Something about the scroll bar
 

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...

--
steveB

Remove "AYN" from email to respond
"filo666" wrote in message
...
Sorry again,
But the scroll bar doesn't returns to his original size¡¡¡¡¡
How to returne it?????

"Norman Jones" wrote:

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.

---
Regards,
Norman



"filo666" wrote in message
...
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