If you’ve ever had information typed up like this:… and only needed to copy the stuff out of one column, you’ll love this tip.
Say, for example, you needed to just get the dollar amounts 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 amount 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!)