Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Excel 2003 Sorting xxxxxxxxxxxxxx?

Sorting a multi-row and col range that has checkboxes. Why the F don't the checkboxes sort when they are included in the range? They are not a sort key and don't need to be either.

1 Answer

Relevance
  • 1 decade ago
    Favorite Answer

    They do not sort because they are not 'in' the range. Embedded objects actually 'float' above the worksheet.

    You can size and position them to appear as if they are contained in a cell, but they are not in the cell.

    To position them, you must manipulate their Top and Left properties via code, or manually position them.

Still have questions? Get your answers by asking now.