98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Formatting
Advanced Formatting
Resolved · Low Priority · Version 2003
Andrew has attended:
Excel Intermediate course
Advanced Formatting
how do you merger and change orientation of cells
RE: Advanced Formatting
Hi Andrew, Thanks for the post, welcome to the forum, in answer to your question, well two questions actually:
1. Merging Cells; Select the cells that you wish to merge. Right-click and then select "Format Cells" from the popup menu.
When the Format Cells window appears, select the Alignment tab. Check the "Merge cells" checkbox.
Now when you return to the spreadsheet, you will find your selected cells merged into a single cell.
Alternatively, Select the cells you wish to merge, click the Merge and centre button on the Formatting toolbar.
Note: if you wish to merge cells in consecutive rows, you will be prompted with a dialog warning box stating that you will lose the data in all but the top row.
2. Re-orientate text; Hold down the left mouse button and drag across the cells or hold the
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:New Normal WorksheetDo you want all your worksheets to confirm to a certain look? Then change the Defaults!!! |