Selecting Cells

1. I can't seem to be able to do something simple in Excel

Suppose I select a Range and then I want to exclude a few cells from that range. Usually in Windows Applications this is done by holding down CTRL while selecting (which selects the item if it's not selected or Unselects the item if it's alreayd selected)

I can't do this in EXCEL???????? The CTRL feature only allows selecting but not unselecting.


2. Also is there a way to select all the cells under the current cell that are not Null and stop when you reach a Null cell?

For example suppose I have a list (database) with 1000 records and I want to format a field (column) of that database. Can I just select the first cell and then somehow select the remaining 999 cells in that column automatically? I am always having to scroll down to find the last record of the database .... gets annoying.

NOTE: I tried to just select the entire colum and then using CTRL to remove unwanted cells but that doesn't work as was stated in the original question.

For question 2 if it's not possible what would be the VBA to accomplish this?

Thank so much.

From the top of a list, use Ctrl-Shift-Down Arrow and it will select everything up until a NULL value

Hope that helps...
John

Sweet .... works well

So the CTRL thing doesn't work in Excel?

I wish it did, I really did... but I've never found a way to have it work...

Originally Posted by kraljb

I wish it did, I really did... but I've never found a way to have it work...

Agree with kraljb, it would be nice, but it only works to 'add' not to remove. If you add 1 too many you have to re-select.

---