How do I type over the face of my full spreadsheet...like "COPY"?

G

Guest

I have a full spread sheet of 10,000 description of entries that are
numbered. There are duplicates in this spread sheet and I need to leave them
because of the numbering. I want to write "DUPLICATION" over the parts of
the spread sheet that are duplicates in a bigger and maybe colored font to
save my supervisor time when she reviews the spread sheet. It would look
like someone took a stamp and stamped the spread sheet. How do I do this...I
have forgotten how.
 
D

Dave Peterson

I think I'd use a helper column of cells. Then I could even apply
Data|Filter|autofilter and show just what I wanted.

Chip Pearson has lots of ways to work with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

He even includes a way to use Format|conditional Formatting to hide duplicates.
But you could use a different font/fill color if you wanted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do restore the content of a excel spreadsheet back 2 weeks. 1
How do I shift cells down in Excel? 1
Validation - removal of over an entire spreadsheet 2
How do I embed a word doument in an excel spread sheet? 1
In Excel, how do I print the cell blocks as well as the data? 2
How do I spread numbers over several months? 3
how do I stop the excel spreadsheet from scrolling to the right 1
How do I paste a large amount of text into a cell ? 1

Top