View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_7_] kirkm[_7_] is offline
external usenet poster
 
Posts: 91
Default Basic help with sheet

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