Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn scroll lock off (2007 excel)? No scroll lock key | Excel Discussion (Misc queries) | |||
Cannot scroll with a Scroll Point Mouse | Excel Discussion (Misc queries) | |||
adding scroll bar to scroll on cell's content? | Charts and Charting in Excel | |||
Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
Scroll the screen view with the scroll bar | Excel Discussion (Misc queries) |