The First Encounter with Microsoft Excel – Part III

Continuing the lesson from Part II:

Khawla wants to add a title above the table in the center. She selects the cells in Row 2 that are exactly above the table …

Microsoft Excel 2003: Adding a Title

… and merges them. Then she writes inside “Personal Balance Sheet”, deselects the merged cells, right-clicks, selects Format Cells, clicks on the Font tab and makes the following changes:

Microsoft Excel 2003: Editing the Font

Clicking OK, the title looks as follows:

Microsoft Excel 2003: Adding a Title

Now, after finishing the first part of the table for year 2010, Khawla wants to add the part of the table for year 2011. She selects 2010 months …

Microsoft Excel 2003: Select 2010 Months

… and drags the mouse 12 cells down …

Microsoft Excel 2003: Dragging Down

… to add the months from January to December for 2011 using auto-complete:

Microsoft Excel 2003: Adding 2011 Months

Notice that dragging the cells not only auto-completed the months, but has also copied the cells’ format (borders’ color, width and style).

Then, Khawla wants to add “2011” in the Year column. Simply, she selects the “2010” cell and drags it down once:

Microsoft Excel 2003: Adding 2011 Cell

But, the 2011 cell must cover the months from January to December. She selects the the 2011 cell as well as the 6 cells below, right-clicks, selects Format Cells, clicks on the Alignment tab, and ticks Merge cells

Microsoft Excel 2003: Merging Cells

… and clicks OK. All of the 12 cells have been merged into one:

Microsoft Excel 2003: 2011 Cell Added

Khawla now selects all the cells for “Start Balance”, “Inflows”, “Outflows”, and “End Balance” for 2010 and drags down to the last edited row:

Microsoft Excel 2003: Dragging 2010 Cells Down

… and the cells have been added:

Microsoft Excel 2003: Adding 2011 Cells

She wants to change the color of the thick border that separates 2010 and 2011. She selects the Year cells containing 2010 and and then 2011, presses the Ctrl button on the keyboard to select as well the row cells for the month December for both 2010 and 2011:

Microsoft Excel 2003: Select the Cells

Then, she right-clicks, selects Format Cells, clicks the Border tab, chooses the thickest border, chooses a darker color, and clicks on the button for the lower border …

Microsoft Excel 2003: Adding the Border

… and clicks OK. And this is the result:

Microsoft Excel 2003: 2010 Separated from 2011

STOP.

Save your work.

I will continue some time in the near future.

Advertisements

Tags: ,


%d bloggers like this: