Hampden-Sydney College | Academic Computing
Tuesday, December 02, 2008
  TECHNOLOGY
 
  Blackboard
  Blackboard Help
  Faculty Awards
  Software Downloads
  Software Tutorials
  Teaching Links
  Technology Lunch Table

  H-SC HOME
 
  Academics
  Admissions
  Alumni
  Athletics
  Blackboard
  Bookstore
  Calendar
  Commencement
  Computing Center
  E-mail Online
  Financial Aid
  Fitness
  Instr Technology
  Leadership Center
  Library
  Making A Gift
  News
  Parents
  Paying for College
  Search
  Site Index
  Student Life
  Visiting HSC

  CONTACT US
 
  Students
  Faculty & Staff
  Faculty Profiles
  Staff Profiles
  Job Openings

 
   INSTRUCTIONAL TECHNOLOGY
 ALIGNING CELLS

Now we'll type some more. Go to

C3 SEPT (Type in and tap Enter)

 

Notice again how SEPT is automatically left aligned. Logically, since you are using Excel in the English version, the text is left aligned so that all of the text lines up nicely in the column cells. One way to do center SEPT is to simply click-on the Center button in the button bar at the top of the screen. Make sure that you are ON cell C3 when you click (see image above right).

 

 

 

 

 

 

Another way to do this is to center the word simply click right on cell C3. Then click on Format Cells.

 

 

 

 

 

 

 

When the Format Cells Menu appears, click-on the – Alignment Tab and then click-on -- Horizontal - Center --Vertical - Center -- OK. Try it.

This is how you can align words for neatness. You can also point to several cells you want aligned and do this. We'll try that next.

 

Now type in the cells indicated.

 

D3 OCT

E3 NOV

F3 DEC

G3 MONTHLY TOTALS (correct the width)

 

Next we’ll highlight cells D3 through G3. To do this, point to D3 and click the Left

Mouse button. Then, holding down the left mouse button, drag the mouse to the right through G3 – when the cells are highlighted – take your finger off of the left mouse button. Then point to the group of cells and click the right mouse button to bring up the Format Cells menu. Click on Alignment and choose Center. Then point to OK and click the left mouse button. All of the cells will then be as you desire. Finish off by clicking on Center.

You could also click the Center button as you did before.

MONTHLY TOTALS will not fit its space when you do this. But, you know what to do. Move the cursor over the line between cells G and H and drag the line to the right to widen the G cell just like you did a few minutes ago.

 

Up ] Starting Excel 2000 ] Moving Around the Spreadsheet ] Widening Columns ] Inserting Rows ] [ Aligning Cells ] Saving and Exiting Spreadsheets ] Retrieving Spreadsheets ] Adding Numbers ] Function Pasting ] AutoSum function and Subtraction ] More Cell Formatting ] New Page 3 ] Division and Percent ] Copying ] Entering Formulas in Monthly Totals ] Absoluting ] Printing ] Highlighting Multiple Ranges ] Graphics ] More Graphics ]


© Copyright 2007 H-SC | Site Index | E-mail a link | Hampden-Sydney College, Hampden-Sydney, VA 23943 | 434-223-6000 | webmaster@hsc.edu