114076 SayPro Lesson 8.4 Formatting your worksheet

Email: info@saypro.online Call/WhatsApp: + 27 84 313 7407

SayPro is a Global Solutions Provider working with Individuals, Governments, Corporate Businesses, Municipalities, International Institutions. SayPro works across various Industries, Sectors providing wide range of solutions.

Several formatting features are available within MS Excel 2010 to effectively display your data (we are going to only with some basic ones which were also available in the previous versions of MS Excel).  Text and individual characters can be formatted to make them stand out (you can format all of the text in a cell or only selected characters).  You may also rotate text (in a column for example) as well as add borders, colors, and patterns to distinguish among different types of information in a worksheet.  Also, you can use number formats to change the appearance of numbers (including dates and times) without changing the number behind the appearance.  Finally, you can format cells and lists quickly using the “Cell Styles” button from the “Styles” group of the “Home” tab.  Cells could even be formatted as tables using the “Format as Table” button from the “Styles” group.

To demonstrate how to go about formatting a worksheet quickly, please follow the following steps:

Formatting Cells

To Change the Font:

  1. Select the cells you want to modify.
  2. Click the drop-down arrownext to the font command on the Home tab. The font drop-down menu appears.
  3. Move your mouse over the various fonts. A live preview of the font will appear in the worksheet.

  1. Select the font you want to use.

To Change the Font Size:

  1. Select the cells you want to modify.
  2. Click the drop-down arrownext to the font size command on the Home tab. The font size drop-down menu appears.
  3. Move your mouse over the various font sizes. A live preview of the font size will appear in the worksheet.

  1. Select the font size you want to use.

You can also use the Grow Font and Shrink Font commands to change the size.

To Use the Bold, Italic, and Underline Commands:

  1. Select the cells you want to modify.
  2. Click the Bold (B), Italic (I), or Underline (U) command on the Home tab.

To Add a Border:

  1. Select the cells you want to modify.
  2. Click the drop-down arrownext to the Borders command on the Home tab. The border drop-down menu appears.

  1. Select the border style you want to use.

You can draw borders and change the line style and colour of borders with the Draw Borders tools at the bottom of the Borders drop-down menu.

To Change the Font Colour:

  1. Select the cells you want to modify.
  2. Click the drop-down arrownext to the font colour command on the Home tab. The colour menu appears.
  3. Move your mouse over the various font colours. A live preview of the colour will appear in the worksheet.

  1. Select the font colour you want to use.

Your colour choices are not limited to the drop-down menu that appears. Select More Colours at the bottom of the menu to access additional colour options.

To Add a Fill Colour:

  1. Select the cells you want to modify.
  2. Click the drop-down arrownext to the fill colour command on the Home tab. The colour menu appears.
  3. Move your cursor over the various fill colours. A live preview of the colour will appear in the worksheet.

  1. Select the fill colour you want to use.

To Change Horizontal Text Alignment:

  1. Select the cells you want to modify.
  2. Select one of the three horizontal Alignmentcommands on the Home tab.
    • Align Text Left:Aligns text to the left of the cell.
    • Center: Aligns text to the center of the cell.
    • Align Text Right:Aligns text to the right of the cell.

To Change Vertical Text Alignment:

  1. Select the cells you want to modify.
  2. Select one of the three vertical Alignmentcommands on the Home tab.
    • Top Align:Aligns text to the top of the cell.
    • Middle Align: Aligns text to the middle of the cell.
    • Bottom Align:Aligns text to the bottom of the cell.

By default, numbers align to the bottom-right of cells and words or letters align to the bottom-left of cells.

Formatting Numbers and Dates

One of the most useful features of Excel is its ability to format numbers and dates in a variety of ways. For example, you might need to format numbers with decimal places, currency symbols ($), percent symbols (%), etc.

To Format Numbers and Dates:

  1. Select the cells you want to modify.
  2. Click the drop-down arrownext to the Number Format command on the Home tab.

  1. Select the number format you want. For some number formats, you can then use the Increase Decimal and Decrease Decimalcommands (below the Number Format command) to change the number of decimal places that are displayed.

Working with Cells

To Copy and Paste Cell Contents:

  1. Select the cells you wish to copy.
  2. Click the Copy The border of the selected cells will change appearance.

  1. Select the cell or cells where you want to paste the content.
  2. Click the Paste The copied content will be entered into the highlighted cells.
  3. Select the cell or cells where you want to paste the content.
  4. Click the Paste The copied content will be entered into the highlighted cells.

To Cut and Paste Cell Content:

  1. Select the cells you wish to cut.
  2. Click the Cut The border of the selected cells will change appearance.

  1. Select the cells where you want to paste the content.
  2. Click the Paste The cut content will be removed from the original cells and entered into the highlighted cells.

To Drag and Drop Information:

  1. Select the cells that you wish to move.
  2. Position your mouse on one of the outside edgesof the selected cells. The mouse changes from a white cross   to a black cross with 4 arrows .

  1. Click and drag the cellsto the new location.
  2. Release your mouse and the cells will be dropped there.

To Use the Fill Handle to Fill Cells:

  1. Select the cell or cells containing the content you want to use. You can fill cell content either vertically or horizontally.
  2. Position your mouse over the fill handleso that the white cross   becomes a black cross .
  1. Click and drag the fill handleuntil all the cells you want to fill are highlighted.
  2. Release the mouse and your cells will be filled.

  • Neftaly Malatjie | CEO | SayPro
  • Email: info@saypro.online
  • Call: + 27 84 313 7407
  • Website: www.saypro.online

SayPro ShopApp Jobs Courses Classified AgriSchool Health EventsCorporate CharityNPOStaffSports

Comments

Leave a Reply