How do I type over the face of my full spreadsheet...like "COPY"?
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. |
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. Michel wrote: 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. -- Dave Peterson |
All times are GMT +1. The time now is 04:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com