CATEGORY: Excel Format VERSIONS: Microsoft Excel 2007

To divide a title in a cell: 1. In cell A1, enter the words: Headings and Invoice Number. 2. Select cell A1, and in the Formula Bar, place the cursor after the word Headings. 3. Press Alt+Enter twice (once to wrap the text and once for an additional blank row). 4. Press Ctrl+Enter to accept the changes without moving from cell. 5. Select Home -> More Borders (from Borders icon in Font Group). 6. Select the left diagonal border. 7. Select the Alignment tab. 8. From both the Horizontal and Vertical dropdown lists, select Justify. 9. Click OK. 10. In the Formula Bar, place the cursor before the word Headings and press the Space Bar to add spaces and move the word to the right.

Rate this tip 1 2 3 4 5   RATING: 2.00   VIEWS: 1183 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner Microsoft Windows XP Step by Step (With CD-ROM) Keys to Reading an Annual Report (Barron's Business Keys) Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business Windows XP for Dummies Business Plans For Dummies®

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books