Get up to 50% Off + MORE! Code: MML18 Ends: 5/28 Details

  1. Help
Get up to 50% Off + MORE! Code: MML18 Ends: 5/28 Details

Excel Tutorial

Hello, you either have JavaScript turned off or an old version of Adobe's Flash Player. Get the latest Flash player.

Excel Tutorial - Page Text Content

4: The A, B, Cs of Formatting Using the example on the next page, note that the trailing zeros have been dropped from some of the data entries. In order to show these zeros your will need to change the numeric format of the data blocks. Part A Highlight the block of data from A3 to A8 by placing the mouse cursor on A3. Hold down the left mouse button and DRAG the cursor down to A8. The block of data should now be highlighted. Part B Hold your cursor over the highlighted block and click the RIGHT mouse button. A menu should appear. This is the Object Menu. Contained in this menu is "Format Cells". SELECT this. The window that pops up is titled Format Cells. Since you have highlighted the set of cells from A3 to A8, inclusive, on sheet 1, the changes you make will only affect these cells. Part C The Format Cells window has six folders with a menu on each. Each of the folders is labeled with a tab at the top. Number is the top folder. In this folder there is a list of categories. SELECT "Number" from this list. This will allow you to set the number of decimal places in your data. You will notice in the upper right of the Sample preview box is 32.00. We wish to have one place after the decimal, so change the value of decimal places to 1 in the box that comes up towards the top on the right. This can be done by typing 1 in or hitting the down arrow to get to 1. The preview box should now display 32.0.

Sizes: mini|medium|large|enormous
susanne gibbs
  • By: susanne g.
  • Joined: about 7 years ago
  • Published Mixbooks: 0
No contributors

About This Mixbook

  • Title: Excel Tutorial
  • An Excel tutorial geared toward middle school students.
  • Tags: excel, excel2003, microsoft, tutorial
  • Started: about 7 years ago
  • Updated: almost 7 years ago