Selecting/Editing highlighted cells in Excel

  • Thread starter Thread starter Carol330
  • Start date Start date
C

Carol330

I have a spreadsheet (50 pages). 4000 line entries. I have severaal hundred
highlighted. Is there a way to pull just the highlighted.
 
Carol, some of this depends on what you mean by "highlighted" and what you
want to do/mean by "pull".

Chip Pearson has done a world of work with dealing with cells that have
color applied to them ( hightlighted? ). These two pages give you some
information on that kind of thing, with the second page describing certain
things that you can do that he has provided functions for via a file to
download and use. While the first page indicates he's only talking about
sorting by color, it leads to more functions and is a good introduction to
what he provides on the second page listed below.

http://www.cpearson.com/excel/SortByColor.aspx
http://www.cpearson.com/excel/Colors.aspx
 
How are the entries highlighted?

By coloring manually all the same color?

One method.........................

Select all cells.

Edit>Find>Format>Format>Pattern.........pick the pattern and "find all"

After the finding and with the "found" dialog still open hit CTRL + a to
select the founds.

Edit>Copy then paste to another worksheet.


Gord Dibben MS Excel MVP
 
Back
Top