Enter text without changing the underlying cells in Excel 2007

by Mary Ann Richardson | Jun 19, 2007 12:00:00 AM

Tags: Mary Ann Richardson, Microsoft Office, Microsoft Excel, spreadsheets, desktops, Box, Cell, Productivity, Office Suites, Software, Microsoft Office Suite Excel Tips Newsletter

Takeaway: Mary Ann Richardson discusses text boxes, which can hold unlimited amounts of text without affecting any of the cells in your Excel 2007 spreadsheet.

Excel cells are limited to 256 characters. However, the cell's size and ability to display its contents change with the size of its surrounding columns. Excel 2007's text boxes overcome these potential limitations.

For example, say you have allotted each department $5,000 per month for new computer equipment. The departments will need to start replacing notebook computers for the next release, and they will need to know how many they can replace on that budget. You decide to create a spreadsheet that calculates how much they can finance at the different interest rates they can obtain from local banks. Your spreadsheet lets each department enter a monthly payment within their equipment budget, and then click a button to get the result. To put these instructions into a text box at the top of the worksheet, follow these steps:

1. Click the Insert tab and then click Text Box.
2. Click and drag to draw a text box from D3:K6.
3. Right-click the text box border.
4. Click on Size And Properties.
5. Under the Properties tab, click to select Move but don't size with the Cells button.
6. Click Close.
7. Right-click the text box border.
8. Click Format Shape.
9. Click Text Box.
10. Click the Resize Shape To Fit Text check box and then click Close.
11. Click within the text box to type your text. If the text extends below row 6, the box will expand vertically to accommodate the extra text. (Note: You can change the widths of the underlying columns, and the text box will retain its original size.)

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.

Print/View all Posts Comments on this article

Maximum Number of Characters/Cell = 32,767 AtCollege | 02/29/08

Characters in a spreed sheet jennifer.hayducka@... | 03/12/08

RE: Enter text without changing the underlying cells in Excel 2007 bros3n@... | 06/03/08