Basic help with sheet

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

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
 
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
Click to expand...

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
 
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
Click to expand...

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
 
Back
Top