Basic Open Office Calc Spreadsheet Tutorial

Changing Data Alignment

Basic Open Office Calc Spreadsheet Tutorial

© Ted French

Open Office Calc Formatting - Changing Data Alignment

Note: For help on these steps, refer to the image above. As well, if you place your mouse over an icon on a toolbar, the icon's name will be displayed.

1. Drag select cells A2 - D2.
   
   
2. Click on the Merge Cells icon on the Formatting toolbar to merge the selected cells.
   
   
3. Click on the Align Center Horizontally icon on the Formatting toolbar to center the title across the selected area.
   
   
4. Drag select cells B4 - B6.
   
   
5. Click on the Align right option icon on the Formatting toolbar to right align the data in these cells.
   
   
6. Drag select cells A9 - A12.
   
   
7. Click on the Align right icon on the Formatting toolbar to right align the data in these cells.
   
   
8. Drag select cells A8 - D8.
   
   
9. Click on the Align Center Horizontally icon on the Formatting toolbar to center the data in these cells.
   
   
10. Drag select cells C4 - C6.
    
    
11. Click on the Align Center Horizontally icon on the Formatting toolbar to center the data in these cells.
    
    
12. Drag select cells B9 - D12.
    
    
13. Click on the Align Center Horizontally icon on the Formatting toolbar to center the data in these cells.

Return to Index page

• Open Office Calc Step by Step Tutorial
• Entering Data into Open Office Calc
• Widening Columns
• Adding the Date and a Range Name
• Adding Formulas
• Changing Data Alignment
• Adding Number Formatting
• Changing cell background color
• Changing Font Color