Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts
    EXCEL 2007
    I want to redesign my Excel sheet with checkbox columns rather than entering text. I'd like the auto-fill list to edit, organize & consolidate options for these cells. It's many "scroll windows" worth of options.

    (I wonder when Windows will ever allow printing or at least text selection for pasting, possible from all dialog type boxes)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='halfmybrain' post='781969' date='26-Jun-2009 21:53']I want to redesign my Excel sheet with checkbox columns rather than entering text.[/quote]
    I wouldn't recommend that. Each check box is an object, so you'd be cluttering the worksheet with lots of objects; it'd soon become difficult to manage. You could have the user enter an "x" into cells instead.

    I wonder when Windows will ever allow printing or at least text selection for pasting, possible from all dialog type boxes
    You can press Ctrl+C in a message box to copy the text on the message box to the clipboard, ready to be pasted into any application that accepts text.
    You can press Alt+PrintScreen in a message or dialog box to copy an image of the box to the clipboard, ready to be pasted into any application that accepts pictures, such as Paint or Word.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Windows doesn't copy text that can't be selected. The Auto Filter Text list can't be selected.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='halfmybrain' post='781976' date='26-Jun-2009 23:01']Windows doesn't copy text that can't be selected. The Auto Filter Text list can't be selected.[/quote]
    No, the AutoFilter dropdown list is not a dialog, you can't select, copy or edit it.
    If you want an editable list of unique items from a range of cells, you can use Advanced Filter with the "Copy to another location" and "Unique records only" options.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •