Enter text without changing the underlying cells in Excel 2007
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:
- Click the Insert tab and then click Text Box.
- Click and drag to draw a text box from D3:K6.
- Right-click the text box border.
- Click on Size And Properties.
- Under the Properties tab, click to select Move but don't size with the Cells button.
- Click Close.
- Right-click the text box border.
- Click Format Shape.
- Click Text Box.
- Click the Resize Shape To Fit Text check box and then click Close.
- 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
|
|
|
|
|
|
White Papers, Webcasts, and Downloads
- How Windows Server 2008 R2 Helps Optimize IT and Save You Money Microsoft A key goal for customers over the next several years will be to reduce ... Download Now
- Qwest Network Services for Healthcare Providers Qwest Communications Demands for improved quality care and increased satisfaction require a ... Download Now
- Enterprise social software IBM Corp. In June 2009, IBM sponsored an interactive webinar to explore the ... Download Now
- Business Analytics and Optimization for the Intelligent Enterprise IBM Corp. IBM Global Business Services, through the IBM Institute for Business ... Download Now
- Easily Monitor Virtual/Physical/Cloud and Save Budget. up.time - Free Trial Uptime Software Need Deep Systems Management for Virtual/Physical/Cloud that Saves you ... Download Now
Article Categories
- Security
- Security Solutions, IT Locksmith
- Networking and Communications
- E-mail Administration NetNote, Cisco Routers and Switches
- CIO and IT Management
- Project Management, CIO Issues, Strategies that Scale
- Desktops, Laptops & OS
- Windows 2000 Professional, Microsoft Word, Microsoft Excel, Microsoft Access, Windows XP,
- Data Management
- Oracle, SQL Server
- Servers
- Windows NT, Linux NetNote, Windows Server 2003
- Career Development
- Geek Trivia
- Software/Web Development
- Web Development Zone, Visual Basic, .NET
