ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I type over the face of my full spreadsheet...like "COPY"? (https://www.excelbanter.com/excel-discussion-misc-queries/28212-how-do-i-type-over-face-my-full-spreadsheet-like-%22copy%22.html)

Michel

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.

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.

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