Home
 ACAD
 Computer Studies
 Graphical
 Knot Making
 Photoshop
 Sudoku


Excel and formatting

  • Formatting of Cells.
    • In Excel we can format our cells, we can either
      1. right click on the cell and choose “format cells” or
      2. click on “Format” and then choose “Cells”
    • A dialog box appears with tabs. Mostly we use the:
      1. Alignment
      2. Font
      3. Border and
      4. Pattern tab. <>



  • The Alignment lets us choose if we want the text horizontally or vertically placed, with their options. We can also write text at an angle.
    • The Font is similar to the Word and we can choose the font we like along with some effects.
    • The border tab lets us add a border to the table and choose a style.
    • The patterns tab is full of colours to use and we can add patterns as well.
  • We can fill the cells with colour and also print the text in colour.
  • We change paper layout from File > Page setup > Landscape.
  • When we format our tables, we make them more attractive and easier to read.
  • We use the A-> Z or Z->A tools to sort our data in ascending order or descending. We must select the heading and all contents cells to sort data.



Practice:
Use the Formatted Tables handout and carry it out

Handout:

formatting in excel





play free sudoku online

Quick links:
Home - Free vectors - pet health care - free stained glass patterns - Free Cross stitch - Free coloring pages - Colorful stained glass patterns for free - Eggart by Candice - Top Cocktail Recipes - Link to us - Paid Links