I'm sure this is a very silly question, but I don't know
how to phrase it to get answers from Help.

I have a sheet with several columns. Each column a different colour.
There's data in a number of rows.

As I scroll down the rows, there is no end. The empty coloured columns
continue as long as I scroll down.

Can I set an absolute end? Is this wasting memory or space? The
workbook does take ages to open.

I do have a finite rightmost column.

Any help appreciated.

Thanks - Kirk

Although slightly counter-intuitive, memory wise it can be more efficient to
format entire columns rather than say the first 1000 rows per column (which
are otherwise unused but say for future use). Formatting entire columns does
not impact on the "usedrange".

Regards,
Peter T

"kirkm" wrote in message
...
I'm sure this is a very silly question, but I don't know
how to phrase it to get answers from Help.

I have a sheet with several columns. Each column a different colour.
There's data in a number of rows.

As I scroll down the rows, there is no end. The empty coloured columns
continue as long as I scroll down.

Can I set an absolute end? Is this wasting memory or space? The
workbook does take ages to open.

I do have a finite rightmost column.

Any help appreciated.

Thanks - Kirk

On Mon, 8 Sep 2008 12:17:08 +0100, "Peter T" <peter_t@discussions
wrote:

Although slightly counter-intuitive, memory wise it can be more efficient to
format entire columns rather than say the first 1000 rows per column (which
are otherwise unused but say for future use). Formatting entire columns does
not impact on the "usedrange".

Regards,
Peter T

Peter I don't understand what you mean.
How big is an entire column?

Guess I'd like to scroll down to my last (coloured) row
and see an end. At which point, I can scroll down no more.
Is that possible?

Thanks - Kirk

Having formats in columns would not help you to scroll down, other than as a
visual indicator.

"End" with the arrow keys looks for first or last data entry in a cell.

However you can use Ctrl-End which goes to the bottom-right of the used
range (which does include formats).

If your file takes longer to open than you'd expect or its file size is
larger than you'd expect with the amount of data, reason is might be to be
due to formats, perhaps in large otherwise unused areas.

Regards,
Peter T

"kirkm" wrote in message
...
On Mon, 8 Sep 2008 12:17:08 +0100, "Peter T" <peter_t@discussions
wrote:

Although slightly counter-intuitive, memory wise it can be more efficient
to
format entire columns rather than say the first 1000 rows per column
(which
are otherwise unused but say for future use). Formatting entire columns
does
not impact on the "usedrange".

Regards,
Peter T

Peter I don't understand what you mean.
How big is an entire column?

Guess I'd like to scroll down to my last (coloured) row
and see an end. At which point, I can scroll down no more.
Is that possible?

Thanks - Kirk

On Mon, 8 Sep 2008 14:52:17 +0100, "Peter T" <peter_t@discussions
wrote:

Having formats in columns would not help you to scroll down, other than as a
visual indicator.

"End" with the arrow keys looks for first or last data entry in a cell.

However you can use Ctrl-End which goes to the bottom-right of the used
range (which does include formats).

If your file takes longer to open than you'd expect or its file size is
larger than you'd expect with the amount of data, reason is might be to be
due to formats, perhaps in large otherwise unused areas.

Regards,
Peter T

Can you tell me l, is it possible to delete (Get Rid of) Unwanted rows
or columns, or not ?

And if you can - how, please?

I hit control-end and Cell IU 1981 is selected. I want the 'end' to be
CS 1175.

So far I've spent about 8 hours Googling for anwers and highlighting
cells and Delete - to no avail. This is crazy!

Thanks - Kirk

try this
http://www.contextures.on.ca/xlfaqApp.html#Unused

--


Gary


"kirkm" wrote in message
...
On Mon, 8 Sep 2008 14:52:17 +0100, "Peter T" <peter_t@discussions
wrote:

Having formats in columns would not help you to scroll down, other than as a
visual indicator.

"End" with the arrow keys looks for first or last data entry in a cell.

However you can use Ctrl-End which goes to the bottom-right of the used
range (which does include formats).

If your file takes longer to open than you'd expect or its file size is
larger than you'd expect with the amount of data, reason is might be to be
due to formats, perhaps in large otherwise unused areas.

Regards,
Peter T

Can you tell me l, is it possible to delete (Get Rid of) Unwanted rows
or columns, or not ?

And if you can - how, please?

I hit control-end and Cell IU 1981 is selected. I want the 'end' to be
CS 1175.

So far I've spent about 8 hours Googling for anwers and highlighting
cells and Delete - to no avail. This is crazy!

Thanks - Kirk