Computer Frequently Asked Questions (FAQ) -- Excel:  Tips and Tricks

Enter a Line Break Within a Cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

1. Click the cell where you want the label or heading to appear.
2. Type the first line of information.
3. Press ALT+ENTER.
4. Type the second line. Then repeat step 3 if you have additional lines to enter.
5. Press ENTER when you've finished typing.

Color-Code Your Excel Sheet Tabs

In Excel 2002, you can color-code sheet tabs for easier identification or grouping of related sheets. Here's how:

1. Select the sheets you want to color by holding down the CTRL key and clicking the tabs.
2. On the Format menu, point to Sheet, and then click Tab Color. You can also right-click the sheet tab and then click Tab Color.
3. Click the color you want, and click OK.

< Back to Oregon Intranet