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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

On Mon, 8 Sep 2008 21:46:03 -0400, "Gary Keramidas"
<GKeramidasATmsn.com> wrote:

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

Thank you! That did - and the note about saving and reopening
was necessary too.

Cheers - Kirk