Category Archives: Everybody

Highlight Every Other Row of a Privilege Log (or other spreadsheet!)

Happy New Year, readers! Today’s tip is an old favorite, and one that can save you a lot of tedious work.   It exploits Excel’s conditional formatting feature to quickly highlight every other row of your privilege log, or any other … Continue reading

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Practice Management, Privilege Logs | Tagged , , , , , , | Leave a comment

Hide Your Name When Printing Outlook Emails

When you print an Outlook email–whether your own or someone else’s–your own name appears by default in large text at the top of the printout. This is awkward if you are printing emails as a delegate, or are using them as … Continue reading

Posted in CLE, Everybody, Lit Support, Practice Management | Tagged , , , , , , , | 4 Comments

Get Excel to Automatically Launch Documents from an Exhibit List, Privilege Log, or Hot Documents List

Today I’ll explain how to create a schedule of documents or other files in Excel that includes a hyperlink for each document.  Anyone reviewing this list will be able to open any document described on it by just clicking the link.  This makes it … Continue reading

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Privilege Logs | Tagged , , , , , , , | 4 Comments

Reverse Names Easily with Find & Replace

A student in one of my CLE programs recently asked me the following question:  What do you do when you have a long list of names of the form “Cook, Mary” and you want to put them in the form “Mary … Continue reading

Posted in CLE, eDiscovery, Everybody, Lit Support, Practice Management | Tagged , , | 5 Comments

Print a Rough Deposition Transcript in Half the Pages

The court reporter just emailed you the rough transcript of today’s deposition, and you’ve absolutely, positively, got to read it on the train tonight.  The idea of reading it off a tablet makes your head hurt, but printing out that .txt file is … Continue reading

Posted in Everybody, Lit Support, Practice Management | Tagged , , , , | 2 Comments

A Brief Aside on the Use of Hyphens

The sun doesn’t rise and set on spreadsheets; we’ve got briefs to write, too!  Here is a rule that I see broken frequently: Use a hyphen to create two-word adjectives, but not when the two words are used as a … Continue reading

Posted in Everybody | Tagged , , | 1 Comment

Find & Redact Social Security Numbers in Excel Files

A raft of state and federal laws require the redaction of social security numbers from publicly available documents.  For attorneys, this usually means that documents produced in litigation must be scrubbed of SSN’s.   In my experience, many parties resort to … Continue reading

Posted in CLE, eDiscovery, Everybody, formulas, Lit Support, Native File Review | Tagged , , , , , , , | Leave a comment