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

[A M I R]

[h=2]Defining Page Setup Options

[h=3]Creating Sheet Settings

The Sheet tab in the Page Setup dialog box provides additional

print options you may want to add to your worksheet

.

​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=5]Print Area By default, Excel prints from the A1 to the last occupied cell in a worksheet. You can specify a different range of cells to print.

[h=5]Print Titles Prints column and row labels on each page of the printout. Specify these rows or columns in

the Rows to Repeat at Top and Columns to Repeat at Left textboxes.

[h=5]Print - Gridlines Determines whether gridlines are printed. However, turning off gridlines does not affect their appearance in Normal View.
[h=5]Print - Black and White If you used colors in your worksheet but don't want to waste the ink in your color printer, use black and white.
[h=5]Print - Draft Quality Choose draft quality to print the worksheet without gridlines or graphics.
[h=5]Print - Row and Column Headings Click this option to include row numbers and columns letters in your printed document.
[h=5]Page Order Determines the order in which worksheets are printed.


​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=3]Challenge!

• Open your Monthly Budget file.

• Change the right and left margins to .5".

• Verify the top and bottom margins are 1".

• Change the Page Orientation to Landscape and verify the page size is 8.5 X 11".

• Create a custom footer with your name or GCF username in the left section and the date in the right section.

• Save and close the document.

​

 

[A M I R]

[h=2]Print Management

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

• Specify a print area

• Preview a page

• Insert and remove page breaks

• Print a worksheet or workbook

​

 

[A M I R]

[h=2]Print Management

[h=3]Specify a print area
In Excel 2003 you can print an entire workbook, a worksheet, a cell range or a cell. Excel defaults to

printing the entire worksheet. But if you want to print only a certain area of a spreadsheet then you can define a print area.

​

 

[A M I R]

[h=2]Print Management

[h=5]To Specify a Print Area:

• Choose View
  
  Page Break Preview from the menu bar.
  
  
  
• A reduced image of the chart is displayed on the screen.

• Click on one of four blue-colored borders and drag to highlight and select the area to print.
  
  
  
• Choose File
  
  Print Area
  
  Set Print Area on the menu bar.
  
  
  

Only that area you defined in the print range will print when the worksheet is submitted to the printer for printing.



​

 

[A M I R]

[h=2]Print Management

[h=3]Preview a page before printing



Excel 2003 provides a Print Preview capability that shows a smaller picture of the printed page

directly on the computer screen. Print Preview is a good way for you to review the formatting and

make sure the columns, rows and margins appear exactly where you want them.

​

 

[A M I R]

[h=2]Print Management

[h=5]To Print Preview:

• Choose File
  
  Print Preview on the menu bar, or
  
  Click the Print Preview button on the standard toolbar.
  
  
  

• In Print Preview window, the document is sized so the entire page is visible on the screen. Simply check the spreadsheet for overall formatting and layout.
  
  
  

The Zoom button in Print Preview will enlarge the data so it can be read.



​

 

[A M I R]

[h=2]Print Management

[h=3]Inserting and Removing a Page Break

There are two different kinds of page breaks in Excel: soft page breaks and hard page

breaks. A soft page break is automatically inserted into a spreadsheet when there is

too much data to fit on one page. A hard page break is one that you can insert into a spreadhseet, wherever you want it to appear.

​

 

[A M I R]

[h=2]Print Management

[h=5]To Insert a Page Break:

• Move the cursor to the row where a page break needs to be inserted. This row will be the first row on the new page.

• Choose Insert
  
  Page Break from the menu bar.
  
  
  
• A page break, indicated by a dashed line, is inserted into the worksheet.

​

 

[A M I R]

[h=2]Print Management

[h=5]To Delete a Page Break:

• Move the cursor to the row where a page break appears

• Choose Insert
  
  Remove Page Break from the menu bar.
  
  
  
• The page break (represented by a dashed line) is removed from the page.

​

 

[A M I R]

[h=2]Print Management

[h=3]Printing a Worksheet or Workbook

Printing in Excel is much like printing in other Office applications like Microsoft

Word. As previously mentioned, Excel defaults to printing the entire worksheet.

​

 

[A M I R]

[h=2]Print Management

[h=5]To Print a Worksheet:

• Choose File
  
  Print from the menu bar.
  
  
  
• The Print dialog box opens.
  
  
  

• Specify the Printer Name where the spreadsheet will print. If you only have one printer in your home or office, Excel will default to that printer.

• In Print Range, choose whether to print All or a certain range of pages (Pages From n to y, where n and y are the beginning and ending page numbers.

• In Print what, choose whether to print a Selection, the Active sheet or
• the Entire Workbook (all worksheets in the workbook). Excel defaults to the Active Sheet.

• Choose the Number of Copies to print by clicking on the up or down arrows.

Don't print your Excel spreadsheet without checking spelling first! Excel

includes two tools to help correct spelling errors: AutoCorrect and Spelling

.

• Click the OK button to print the worksheet.

​

 

[A M I R]

[h=2]Print Management

[h=3]Challenge!




Open your Monthly Budget file.



Select the 2005 sheet.



Use Print Preview to view the sheet and then Print the document.



Save and close. Congratulations! You have completed all the tutorials and challenges for Excel 2003.




​

 

[A M I R]

[h=2]Using AutoF i l t e r

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

****** data in a spreadsheet

​

 

[A M I R]

[h=2]Using Auto******

[h=3]Using Auto******The Auto****** feature makes ******ing, or temporarily hiding, data

in a spreadsheet very easy. This allows you to focus on specific spreadsheet entries.

​

 

[A M I R]

[h=2]Using Auto******

[h=5]To Use Auto******:

• Select Data from the main menu.

• Select ******
  
  Auto******.

• Click the drop-down arrow next to the heading you would like to ******.

For example, if you would like to only view data from the West Sales Region, click the drop-down arrow next to Sales Region.

• Choose the data you would like to display.

In this example, you would choose West. All other data will be ******ed, or hidden, and only the West Sales Region data is visible.

Click the drop-down arrow again and select All to display all of your original data.



​

 

[A M I R]

[h=2]Using Auto******

[h=3]Challenge!
Download and save the Employee Sales spreadsheet to complete this Challenge.

• Open the Employee Sales spreadsheet.

• Use the Auto****** feature to ****** all entries except for the North Sales Region.

• Continue to use Auto****** until you are comfortable with this feature.

• Save and close the spreadsheet.

​

 

[A M I R]

[h=2]Sorting Lists

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

• Sort lists in ascending order

• Sort lists in descending order

• Sort multiple categories at the same time

​

 

[A M I R]

[h=2]Sorting Lists

[h=3]Sorting Lists



Sorting lists is a common spreadsheet task that allows you to easily reorder your

data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order

.

In this example, we will alphabetize the employee names.



​