Make a list but exclude a cell?

Originally Posted by JetsVille

Hello,

Is there way to make a list such as A:A but exclude one cell in the list like A2?

A:A-A2 or something?

thanks

Hi,

not even in manual mode. Excel follows the Windows standard for 'select' - 'shift-select' to select all between, - 'Ctrl/Select' to include additional entries, but does not recognize Ctrl-Select to remove a selected entry.

hth
---