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