November 9, 2010
I do compositing on assay certificates and need to delete the rows with duplicate sample values. They are color coded. In Excel '03, I can use Ctrl+f, and pick the Format button which allows me to "Choose format from cell." I can then pick a cell and it will have the color selected. I then highlight a column and hit the "Find All" button which then selects all the colored cells in that column and I can delete those rows.
When I try it in Excel '10 on Windows 7, I get the message "Microsoft Excel cannot find the data you're searching for." All the filter boxes are set the same in both versions of Excel.
Any suggestions would be appreciated. I can select them using wildcards for some of the values, but that requires running "Find" twice.
Thanks,
Ray
August 11, 2011
MS Excel allows you to sort data in your worksheets in many ways. One of the attributes that you can sort by is colors. Specifically, Excel allows you to sort by both the color of the cell and the color of the text within the cell.
Follow the steps below to learn how:
[list:1acfrej8][b:1acfrej8]Select [/b:1acfrej8]the [b:1acfrej8]data [/b:1acfrej8]that you would like to sort or select a cell within the data you would like to [b:1acfrej8]sort[/b:1acfrej8].
Display the [b:1acfrej8]Data [/b:1acfrej8]tab of the [b:1acfrej8]Ribbon[/b:1acfrej8].
Click the [b:1acfrej8]Sort Tool [/b:1acfrej8]in the [b:1acfrej8]Sort & Filter [/b:1acfrej8]Group.
The dialog box will display.
Using the[b:1acfrej8] drop-down [/b:1acfrej8]list in the [b:1acfrej8]Sort On [/b:1acfrej8]column, select either [b:1acfrej8]Cell Color [/b:1acfrej8]or [b:1acfrej8]Font Color[/b:1acfrej8], depending on your need.
Using the [b:1acfrej8]second [/b:1acfrej8]drop-down list in the [b:1acfrej8]Order [/b:1acfrej8]column, specify whether the color you selected should be on [b:1acfrej8]top [/b:1acfrej8]or [b:1acfrej8]bottom[/b:1acfrej8].
Should you want to sort by other colors, click the [b:1acfrej8]Add Level [/b:1acfrej8]button and repeat the steps above.
Click [b:1acfrej8]OK[/b:1acfrej8].[/list:u:1acfrej8]Your data should now be sorted by the specifications you chose.
November 9, 2010
Ms Bratt,
This is one of those cases where the "new & improved" features of the latest release of an application adds at least four steps to what I used to be able to do with two clicks.
Thanks,
Ray
August 11, 2011
Hi Ray,
New is not always better and change is [b:cm52lgrk]always [/b:cm52lgrk]difficult. You can, however, customize your QAT (Quick Access Toolbar) to shorten the process. You can create macros to help as well. You only have to do it once and then you always have it. I have always found it painful when the newer versions of MS Office are introduced. Version 2003 was like a comfortable pair of shoes for me. I knew all the shortcuts, quick keys, etc. and then the navigation all changed in version 2007 and then some more changes in version 2010. But eventually, after using it for a bit, you become accustomed. I will never forgive Microsoft from taking away the ability to customize MS Word though!
1 Guest(s)
