If you've ever had information typed up like this:
... and only needed to copy the stuff out of one or two columns:
... then you'll love this tip.
Say, for example, you needed to just get the dollar amounts and the names and copy them someplace else. If you've got a whole list of these, you might think you'll either have to type this up again, or copy-and-paste each piece of text separately.
Recently, a fellow reader, Jessica from Miami, asked if I would help her figure out a way to create an event timeline in a format her boss is partial to:
She had tried to find templates online, but nothing really seemed geared to a legal context.
I tried creating a solution in Word, but it was less than satisfactory. So, given that Jessica was pretty comfortable with Excel, I developed a template for her there.
Changing the orientation of text within cells (vertical, horizontal, or diagonal, as in the example above) is actually pretty easy — here, I’ll show you:
(To view in full-screen mode, click the button in the lower right-hand corner.)
There’s other formatting done here too — the cells are wrapped (the Wrap Text checkbox above), I shifted the vertical alignment to Bottom, and in some cases, to get the middle cell to look more “centered,” I added a hard return before the text (with ALT-ENTER). There’s a fair bit of eyeballing that has to be done to get it to look right, and it’s all a judgment call according to your personal preference.
What uses could you find for this trick? Let me know in the comments below.
(P.S.: Jessica seemed to be pretty happy with her new template last I heard!)