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

[A M I R]

[h=2]Working with multiple worksheets

[h=3]Moving Worksheets
When you move a sheet, you are moving it to a new location in this or another workbook.

​

 

[A M I R]

[h=2]Working with multiple worksheets

[h=5]To Move a Workbook:

• Select the worksheet you want to move/copy.

• Choose Edit
  
  Move or Copy from the menu bar.
  
  
  

In the Move or Copy dialog box, use the drop down boxes to select the name of the

workbook you will move the sheet to (the current workbook is the default). Also

define where you want the sheet positioned in the workbook.

• 
• Check Create a copy to copy it.

• Click the OK button to move the worksheet to its new location.

 

[A M I R]

[h=2]Working with multiple worksheets

[h=3]Copying Worksheets

When you copy a sheet, you make an exact copy of it.

​

 

[A M I R]

[h=2]Working with multiple worksheets

[h=5]To Copy a Worksheet:

• Select the worksheet you want to move/copy.

• Choose Edit
  
  Move or Copy from the menu bar.

In the Move or Copy dialog box, use the drop down boxes to select the name of the

workbook you will copy the sheet to (the current workbook is the default). Also

define where you want the sheet positioned in the workbook.

• Click the Create a copy checkbox.
• 
  
  
  
• Click OK to create an exact copy of the worksheet and move it to the location specified.

​

 

[A M I R]

[h=2]Working with multiple worksheets

[h=3]Challenge!

• Open your Monthly Budget file.

• Rename Sheet1 to 2005, Sheet2 to 2006 and Sheet3 to 2007.

• Insert two worksheets and name them 2008 and 2009.

• Move the 2008 and 2009 worksheets so they are immediately following the 2007 sheet.
• 
• Use the Grouping feature so that the 2006, 2007, 2008, and 2009 sheets contain the same information as Column A and Row 1 of the 2005 sheet.

• Delete the 2009 sheet.

• Save and close the Monthly Budget document.

​

 

[A M I R]

[h=2]Inserting and Deleting Rows and Columns

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

• Insert rows and columns

• Delete rows and columns

​

 

[A M I R]

[h=2]Inserting and Deleting Rows and Columns


[h=3]Inserting a row

You can insert a row in a spreadsheet anywhere you need it. Excel


moves the existing rows down to make room for the new one.



​

 

[A M I R]

[h=2]Inserting and Deleting Rows and Columns

[h=5]To Insert a Row:

• Click anywhere in the row below where you want to insert the new row.

• Choose Insert
  
  Rows from the menu bar.
  
  
  

• A new row is inserted above the cell(s) you originally selected.

OR

• Click anywhere in the row below where you want to insert the new row.

• Right-click and choose Insert from the shortcut menu.
  
  
  
• The Insert dialog box opens.
  
  
  
• Choose the Entire Row radio button.

• Click the OK button.

• A new row is inserted above the cell(s) you originally selected.
  
  
  

Select multiple rows before choosing Insert to add rows quickly. Excel

inserts the same number of new rows that you originally selected.


​

 

[A M I R]

[h=2]Inserting and Deleting Rows and Columns

[h=3]Inserting a column

In Excel, you can insert a column anywhere you need it. Excel

moves the existing columns to make room for the new one.

​

 

[A M I R]

[h=2]Inserting and Deleting Rows and Columns



[h=5]To Insert a Column:

• Click anywhere in the column where you want to insert a new column.

• Choose Insert
  
  Columns from the menu bar.
  
  
  
• A new column is inserted to the left of the existing column.

OR

• Click anywhere in the column where you want to insert a new column.

• Right-click and choose Insert from the shortcut menu.
  
  
  
• The Insert dialog box opens.
  
  
  
• Click the Entire Column radio button in the Insert dialog box.

• Click the OK button.

• A new column is inserted to the left of the existing column.
  
  
  

You can also select multiple columns before choosing Insert to add columns

quickly. Excel inserts the same number of new columns that you originally selected.
​

 

[A M I R]

[h=2]Inserting and Deleting Rows and Columns

[h=3]Deleting columns and rows

Columns and rows are deleted in much the same manner as inserting columns and rows.

​

 

[A M I R]

[h=2]Inserting and Deleting Rows and Columns

[h=5]To Delete a Row and All Information in It:

• Select a cell in the row to be deleted.

• Choose Edit
  
  Delete from the menu bar.

• Click the Entire Row radio button in the Delete dialog box.
  
  
  
• Click the OK button.

​

 

[A M I R]

[h=2]Inserting and Deleting Rows and Columns

[h=5]To Delete a Column and All Information in it:

• Select a cell in the column to be deleted.

• Choose Edit
  
  Delete from the menu bar.

• Click the Entire Column radio button in the Delete dialog box.
  
  
  
• Click the OK button.

​

 

[A M I R]

[h=2]Inserting and Deleting Rows and Columns

[h=3]Challenge!

• Open your Monthly Budget file.

• Delete the blank Column B.

• After you delete the blank Column B it may look like this:
• 
• Save and close the document.

​

 

[A M I R]

[h=2]Changing Column Width and Row Height

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

• Change column width

• Change row height

​

 

[A M I R]

[h=2]Changing Column Width and Row Height

[h=3]Adjusting column widths




By default, Excel's columns are 8.43 characters wide, but each

individual column can be enlarged to 240 characters wide


If the data being entered in a cell is wider or narrower than the default

column width, you can adjust the column width so it is wide enough to contain the data.

You can adjust column width manually or use AutoFit.


​

 

[A M I R]

[h=2]Changing Column Width and Row Height

[h=5]To Manually Adjust a Column Width:

• Place your mouse pointer to the right side of the gray column header.

• The mouse pointer changes to the adjustment tool (double-headed arrow).
• 
  
  
  
• Drag the Adjustment tool left or right to the desired width and release the mouse button.
• 
  
  
  

​

 

[A M I R]

[h=2]Changing Column Width and Row Height

[h=5]To AutoFit the Column Width:

• Place your mouse pointer to the right side of the column header.

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

• Double-click the column header border.

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

To access AutoFit from the menu bar, choose Format

Column

AutoFit Selection.


​

 

[A M I R]

[h=2]Changing Column Width and Row Height

[h=3]Adjusting row height


Changing the row height is very much like adjusting a column width. There will be times

when you want to enlarge a row to visually provide some space between it and another row above or below it.



​

 

[A M I R]

[h=2]Changing Column Width and Row Height

[h=5]To Adjust Row Height of a Single Row:

• 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).
• 
  
  
  
• Drag the Adjustment tool up or down to the desired height and release the mouse button.
  
  
  

​