Category Archives for "Excel 2007"

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.

2 Reader Question: Cannot select single cell, row, or column

One reader wrote in recently that she was having a problem selecting cells in Microsoft Excel:

When in a spreadsheet and I click on a line it selects at least four lines.

In other words, she couldn’t select a single cell or just one row in the spreadsheet. It was as if her mouse cursor had a mind of its own!

Well, this was certainly a new one for me. I personally had never run across that particular problem, so I had no solution off the top of my head.

So what did I do? I went to Microsoft Answers (http://answers.microsoft.com) and did a little search. And not one but two possible solutions presented themselves.

Keep reading →

[Insanely] Popular Post: Printing Those Monster Excel Sheets

Because I’m always trying to make sure I’m posting tutorials that help as many readers as possible, I regularly check out the statistics on what current posts are getting the most eyeballs (so I can do “more like that“). Sometimes, the stats surprise me.

For instance, who’d have guessed that a post on how to print large Excel spreadsheets would be the #1 most popular post on this blog? Not me.

But it is. And don’t get me wrong: I’m glad it’s helping so many people, especially considering how much work went into it.

In fact, at the time I originally posted it six months ago, I had done a video tutorial to go with the illustrations and text. Unfortunately, I was still scaling the learning curve on my newly-purchased screencasting software, and since I couldn’t figure out how to get rid of the irritating background whine in the the audio portion of the video, I set the video aside and published the post without it.

Now, I’ve gone back and fixed the original video showing the 5 steps to formatting a large Excel spreadsheet for printing, and I’ve added it to the post. So if printing in Excel is a mystery to you, click here to check out the post and the new companion video. (There’s even a downloadable transcript of the video in case the narration’s not 100% clear — I had to talk a little faster than normal in some spots when re-recording the narration!)

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 →

1 Summarizing Excel data with Pivot Tables

If you've ever been presented with an Excel spreadsheet with a gosh-awful number of rows and/or columns in it and assigned the task of making sense of all those numbers (grouping, summarizing, or making other calculations), you need to learn about Pivot Tables.

Okay, people, I hear yawning out there! Seriously, this is a good skill to have in your back pocket, even if you only work with Excel occasionally, because it saves so much time. So to motivate you properly, here's a fun little YouTube introduction to the whys behind Pivot Tables:

Keep reading →

7 Customizing the Quick Access Toolbar

Want one-click access to the commands you use most in the ribbon versions of Microsoft Office? Then you need to be taking full advantage of the Quick Access Toolbar!

The Quick Access Toolbar really lives up to its name: it provides one-click access to virtually any command you want. All you have to do is customize it.

And one of the great things about the Quick Access Toolbar (or QAT) is that it's virtually the same throughout Microsoft Office. Sure, the commands vary according to the application, but the way you update it is the same across the Office Suite.

Here are two ways to add your favorite commands to the QAT:

Keep reading →

27 Printing those monster Excel sheets

My friend Karen has issues.  No, I'm not talking about those kinds of issues.  She's got issues with Microsoft Excel.

Every time her boss gives her one of those monster Microsoft Excel spreadsheets (the kind that span 10 pages across and have 20,000 rows of data) and says, "Print this," she panics.  And then she comes to my desk and begs me to print it for her.

I can't say I blame her.  Unless you've worked with Microsoft Excel a fair bit, the prospect of formatting something that large for printing is pretty daunting.  (I always felt the same way about Lotus 1-2-3 for DOS back in its heyday.  Yes, I am that old.)

I promised her I'd break this process down for her so, in case I'm on vacation one day when she really, really needs something printed now, she'll know how to do it herself.

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 tried to find templates online, but nothing really seemed geared to a legal context.

I tried solving this problem in Word, but no real luck.  So, since 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:

Keep reading →

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

Click the image above for a full-size version

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:

Keep reading →

58 How to put multiple lines into cells in Microsoft Excel

If you use Microsoft Excel to organize data (say, a timeline or a list of documents being produced), you may have run into the problem of having more text than will fit into a normal cell.  You need to either wrap text like a paragraph or insert line breaks in the middle of the Excel cell, because otherwise the text 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 either (a) have the information in the first cell wrap text in Excel like a paragraph so it appears on multiple lines within that cell or (b) insert a line break like you would in a word processor.  

Right?

Here's how you do each:

Keep reading →