Join the Meeting Place for Moms!
Talk to other moms, share advice, and have fun!

(minimum 6 characters)

Is there a key command or format to delete/hide duplicate cells in a spreadsheet?

I have a spreadsheet I am working on at work, but it has over 27,000 rows that I have to work due to the duplicate cells/rows with the same patient listed multiple times.

Is there a way to hide those automatically without having to go through the entire spreadsheet and doing them individually?

I hope this question makes sense.

 
Memigen

Asked by Memigen at 3:36 PM on Dec. 3, 2010 in Money & Work

Level 27 (30,799 Credits)
This question is closed.
Answers (1)
  • Are you working in Excel? What version? It is possible to hide entire rows or entire columns but not invididual cells.
    HotMama330

    Answer by HotMama330 at 2:30 PM on Dec. 4, 2010