Software

Save steps when wrapping text and inserting worksheets in Excel 2007

Excel 2007 contains a number of improvements that make your job easier. Here are two tips that, prior to Excel 2007, required multiple mouse clicks. Now you can perform these tasks with a single click of the mouse.

Prior to Excel 2007, if you wanted to enter First Quarter 2006 Sales on two lines in a single cell, you had two choices: You could type First Quarter, press [Alt][Enter], type Sales, and then press [Enter]; or, you could right-click the cell, select Format Cells, click the Wrap Text check box on the Alignment tab, and then click OK. When you typed the text in the cells, it would wrap automatically. In Excel 2007, you can accomplish the same thing with one mouse click. After typing the text in the cell, simply click the Wrap Text button on the Home ribbon (near the center).

Also, in earlier versions of Excel, you had two choices for adding a worksheet to your workbook, both of which involved at least two mouse clicks. You could go to Insert | Worksheet, or you could right-click a Sheet tab, click Insert, and then click OK. With Excel 2007, you simply click the Insert Sheet button to the right of the Sheet tabs to add a new worksheet.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

3 comments
rdb
rdb

Excel used to have a Justify function that was sort of a rudimentary word processing tool- it would break a long text entry into the rows below it, and could make the lines what ever length you wanted, depending the area you indicated by selecting. 2007 seems to have left this function out, and replaced it instead with a justify command that really is only a wrap text command. The old Justify, if added to the menu, could have performed Mary Ann's trick with one click. A lot of times I don't want to wrap text and mess up the whole row's height. I for one will miss the old Justify command. I started using Excel 2007 a few weeks ago. I wasn't really pleased so many familar things were either moved or gone. It's sort of like trying to use something Apple created- it's a different sort of intuitiveness that what I have. I immediately populated the quick bar with my favorite icons- if I could find them. I found myself needing to make more clicks than with previous versions. That's getting better though as I become more familar with the ribbon thing. I probably don't matter though; I still miss the old Lotus 123 macro language and would gladly trade visual basic for it back.

hdn.de
hdn.de

I'm using Office 2007 for some weeks now and in my experience i tend to need more mouse clicks than in previous versions. Sometimes i find myself constantly switching between two tabs and your example also does only work with one click if the home tab is already opened. Although I have to appreciate the new UI to be helpful in more creative phases of document creation. especially when i try function i never used before, doing well known repetitive tasks can easily evolve to using many more clicks than in older Office versions.

Fil0403
Fil0403

I'm using Office 2007 for months now and in my experience I tend to need way less mouse clicks than in previous versions, since Office 2007 changes ribbon automatically depending on what is selected, so what I want to do is usually only one click away. Besides, you can customize the quick bar with commands you usually use, so they're always avilable no matter what.

Editor's Picks