آموزش کامل Excel 2003 -EN

[A M I R]

[h=2]Changing Column Width and Row Height

[h=5]To AutoFit the Row Height:

• Place your mouse pointer to the lower edge of the row heading you want to adjust.

• The mouse pointer changes to the adjustment tool (double-headed arrow).

• Double-click to adjust the row height to "AutoFit" the font size.

• Excel 2003 "AutoFits" the row, making the entire row slightly larger than the largest entry contained in the row.

​

 

[A M I R]

[h=2]Changing Column Width and Row Height

[h=3]Challenge!

• Open your Monthly Budget file.

• AutoFit the column width of Column A.

Manually adjust the column width for any columns that you need to enlarge. For

example, Column J may need to be adjusted so the word September fits in the cell.

• Adjust the row height of Row 1 to at least double its current width
• .
  

• Save and close the document.

​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=3]Introduction[h=4]By the end of this lesson, learners should be able to:

• Insert cells

• Delete cells

• Merge cells

​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=3]Inserting a cellWhen working in an Excel 2003 worksheet, you may need to

insert or delete cells without inserting or deleting entire rows or columns.

​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=5]To Insert Cells:

• Select the location where the new cell(s) should be inserted. It can be a single cell or a range of cells.

• Right-click and choose Insert.
  
  Note: You could also choose Insert
  
  Cell on the menu bar.
  
  
  
• The Insert dialog box opens. Select either:

• Shift cells right to shift cells in the same row to the right.

• Shift cells down to shift selected cells and all cells in the column below it downward.
  
  
  
• Choose an option and click the OK button.

• Your result displays in the spreadsheet.
  
  
  

Remember, you can also use the Insert dialog box to insert or delete columns and rows.



​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=3]Deleting a cell [h=5]To Physically Delete the Cell from the Spreadsheet:

• Right-click and choose Delete.
• 
  
  
  
• The Delete dialog box opens. Select either:

• Shift cells left to shift cells in the same row to the left.

• Shift cells up to shift selected cells and all cells in the column above it upward.
  
  
  
• Choose an option and click the OK button.

• Your result displays in your spreadsheet.

​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=3]Merging cells

In Excel 2003, you have another alignment option available to you: merge

and center. This is performed when you want to select one or more cells

and merge them into a larger cell. The contents will be centered across the new merged cell.


The picture below shows why we might want to merge two cells. The spreadsheet presents

Last Month and This Month Sales and Expenses for Sally. Notice that Sally's name appears

above the Last Month column. To evenly center Sally's name across the two cells we would perform a merge and center.

​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=5]To Merge Two Cells Into One:

• Select the cells that you want to merge. It can be cells in a column, row or both columns and rows.

• Click the
  
  Merge and Center button on the standard toolbar.
  
  
  
  
• The two cells are now merged into one.
  
  
  

​

 

[A M I R]

[h=2]Inserting and Deleting Cells

[h=3]Challenge!

• Open your Monthly Budget file.

• Insert a blank row above the current Row 1, which contains the months of the year.

• Type My Budget in A1.

• Use the merge and center function to center My Budget over Columns A through N.
• 
• Save and close the document.

​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=3]Introduction[h=4]By the end of this lesson, learners should be able to:

• Change horizontal cell alignment

• Change vertical cell alignment

• Change text control

• Change text orientation

​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=3]Using the Standard Toolbar to Align Text and Numbers in Cells

You've probably noticed by now that Excel 2003 left-aligns text (labels) and

right-aligns numbers (values). This makes data easier to read.

You do not have to leave the defaults. Text and numbers can be defined as left-aligned, right-aligned

or centered in Excel 2003. The picture below shows the difference between these alignment types when applied to labels.

Text and numbers may be aligned using the left-align, center and right-align buttons of the Formatting toolbar:

​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=5]To Align Text or Numbers in a Cell:

• Select a cell or range of cells

• Click on either the Left-Align, Center or Right-Align buttons in the standard toolbar.

• The text or numbers in the cell(s) take on the selected alignment treatment.

​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=3]Changing Horizontal Cell Alignment

We've previously seen how to align text or numbers using the left-align, center and right-align

buttons in the standard toolbar. You can also define alignment in the Alignment tab of the Format Cells dialog box.

The Horizontal section features a drop-down that contains the same

left, center, and right alignment options in the picture above and several more:

---

[h=5]Fill "Fills" the cell with the current contents by repeating the contents for the width of the cell.



[h=5]Justify If the text is larger than the cell width, Justify wraps the text in the cell and adjusts the spacing within each line so that all lines are as wide as the cell.



[h=5]Center Across Selection Contents of the cell furthest to the left are centered across the selection of cells. Similar to merge and center, except the cells are not merged.









​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=5]To Change Horizontal Alignment using the Format Cells Dialog Box:

• Select a cell or range of cells.

• Choose Format
  
  Cells from the menu bar.
  
  
  
  
  
  (You could also right-click and choose Format Cells from the shortcut menu.)

• The Format Cells dialog box opens.

• Click the Alignment tab.
  
  
  
• Click the Horizontal drop-down menu and select a horizontal alignment treatment.

• Click OK to apply the horizontal alignment to the selected cell(s).

​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=3]Changing Vertical Cell Alignment


You can also define vertical alignment in a cell, similar to how it is done for

horizontal alignment. In Vertical alignment, information in a cell can be

located at the top of the cell, middle of the cell or bottom of the cell. The default is bottom.

​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=5]To Change Vertical Alignment using the Format Cells Dialog Box:

• Select a cell or range of cells.

• Choose Format
  
  Cells from the menu bar.
  
  (You could also right-click and choose Format Cells from the shortcut menu.)
• The Format Cells dialog box opens.

• Click the Alignment tab.

• Click the Vertical drop-down menu and select a vertical alignment treatment.

• Click OK to apply the vertical alignment to the selected cell(s).

​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=3]Changing Text Control

Text Control allows you to control the way Excel 2003 presents information

in a cell. There are three types of Text control: Wrapped Text, Shrink-to-Fit and Merge Cells.

The Wrapped Text wraps the contents of a cell across several lines if it's too

large than the column width. It increases the height of the cell as well.

Shrink-to-Fit shrinks the text so it fits into the cell; the more text in the cell the smaller it will appear in the cell.

Merge Cells can also be applied by using the

Merge and Center button on the standard toolbar.


​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=5]To Change Text Control using the Format Cells Dialog Box:

• Select a cell or range of cells.

• Choose Format
  
  Cells from the menu bar.

• The Format Cells dialog box opens.

• Click the Alignment tab.

• Click on either the Wrapped Text, Shrink-to-Fit or Merge Cells check boxes-or any combination of them-as needed.

• Click the OK button.

​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=3]Changing Text Orientation

The fourth type of cell alignment in the Format Cells dialog box is

Text Orientation, which allows text to be oriented 90 degrees in either direction up or down.

​

 

[A M I R]

[h=2]Text and Cell Alignments

[h=5]To Change Text Orientation using the Format Cells Dialog Box:

• Select a cell or cell range to be subject to text control alignment.

• Choose Format
  
  Cells from the menu bar.

• The Format Cells dialog box opens.

• Click the Alignment tab.

• Increase or decrease the number shown in the Degrees field or spin box.

• Click the OK button.

​