View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Michael Link
 
Posts: n/a
Default Stupid List Box Question

Hmm. "List" doesn't appear as an option in my Data pull-down even when the
list is selected. I'm doing this on a Mac, so perhaps that is part of the
problem. I may just have to start over again.

"Tom Ogilvy" wrote:

Have you tried selecting the list, then doing Data=List=Resize List?

--
Regards,
Tom Ogilvy



"Michael Link" wrote:

Somehow while I was setting up a list, I made it so it filled all the rows of
the sheet (over 60,000). Actually, my list is only about a thousand rows. How
can I reformat the thing to fill only the required columns? I can't just
click on the frame at the bottom and drag it to tighten because I get a
warning box saying "Not enough memory" when I try to do so.

Thanks for help with such a dumb question! Help!

M. Link