Category Archives for "Excel 2003"

Weirdly popular post: How to put multiple lines into cells in Microsoft Excel

All of a sudden (and in addition to a surge in site traffic generally), I’m seeing an awful lot of people visiting my post, How to put multiple lines into cells in Microsoft Excel. There must be a lot of people wanting to do this:

A mailing address typed into Excel

Or this:

Text in an Excel cell with line wrap turned on

Hey, I’m always happy to help. Click here for the full tutorial.

1 Weekly Roundup: Popular Word fixes, Excel row headers, and Office for iPad

Now that it’s past the annual holiday season here in the US (Santa brought me a way-big monitor!) it’s back in the saddle again for the Weekly Roundup. This week: Microsoft Office blog does its own list of most popular posts (including a couple of issues that continually plague legal Office users), a quick-and-dirty Excel tutorial on printing title rows, and an exciting rumor for iPad users.

Keep reading →

4 Reader Question: Calculate difference between two dates in Microsoft Excel

A reader contacted me recently with a deceptively simple Microsoft Excel question: “How do I calculate the difference between two dates?”

I say “deceptively simple” because the answer depends upon the context, namely, whether the two dates being compared are actually embedded in cells within the Microsoft Excel spreadsheet.

Keep reading →

7 Creating a custom timeline in Excel

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:

Example of a timeline created in Microsoft Excel 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!)

15 Customizing the Status Bar

There’s a whole host of ways you can make the various Microsoft Office applications easier to use. In fact, most users don’t take full advantage of the options for customizing these applications to make the Office suite work better for them.

Today, we’re going to talk about one of the easiest customizations: the Status Bar. Look at the bottom of any Office application and you’ll see a bar just above the Windows Taskbar at the bottom (like this example from Word 2007):

Status Bar from Microsoft Word

(If you need to see the above a bit bigger, click on it for a full-sized version.  Go on — I’ll wait here.)

Most users don’t know they can change the information listed on the task bar in any Office application (except Outlook, unfortunately). And it’s really easy:

1) Right-click your mouse anywhere on the status bar.

2) Select the option(s) you want (check marks on this example from Word 2007 indicate the option is already selected and showing up on the Status Bar):

Customize Status Bar right-click menu from Microsoft Word

I recommend, for example, always turning on the Track Changes indicator, and I personally think the Word Count is a handy piece of information to have.  Feel free to experiment with adding or deleting features — you won’t mess up your document!

3) Once you’ve made your choices, click elsewhere on the screen to close the Customize Status Bar menu and save your changes.

That’s it! (That may be the easiest Word task you’ll do all day!)

Now, why is this important? Here are some scenarios to consider:

1) Someone’s sent you a document to review/revise and left Track Changes on, so when you start typing, Word starts redlining the document. With the status bar set to show the status of Track Changes, you can simply click on that section once to turn it off. That’s much simpler (and faster) than going to the Review tab, dropping down the Track Changes menu, and turning it off there.

2) You’ve imported some text from WordPerfect and notice that the headers and footers mysteriously change mid-document. Why? The status bar gives you a clue: the section numbers at the left keep changing. (Text imported from WordPerfect often embeds random section breaks into a document, which can affect the headers and footers.) How much time would you have otherwise spent trying to troubleshoot that problem?

3) Ever wanted to get a quick sum or count of highlighted cells in Excel without creating a formula? Change the status bar to show Count and Sum. You can also get quick calculations of Averages, Minimums and Maximums in the status bar.

So, what items would you want to see in the status bar? Tell me about ’em in the comments below.

59 How to put multiple lines into cells in Microsoft Excel

If you use Microsoft Excel to organize data (say, a list of documents being produced), you may have run across The Cell That's Too Small For Its Data.  You know, you've got a bunch of stuff typed into a cell (not because you're rambling, but because you need all that information, dang it), and it just breaks out of the borders of the cell and keeps on going:

Text in an Excel cell not wrapped

And if that's not annoying enough, if you have to type something into the cell to the right, then you've just cut off the last part of that other cell:

Text in an Excel cell that's not wrapped and is cut off

What you want to be able to do is have the information in the first cell wrap so it appears on multiple lines within that cell.  Right?

Here are a couple of different tricks to try:

Keep reading →

Working with Word 2007 & 2010 documents in earlier versions

It’s bound to happen sooner or later.  Someone — co-counsel, client, whoever — sends you a document with a .docx extension.  You try to open it in Word 2003 or even 2002, but you get an error message.

Don’t fret — it’s an easier problem to solve than you think.

Keep reading →