1 / 11

INTRODUCTORY MICROSOFT EXCEL Lesson 3 – Organizing the Worksheet

INTRODUCTORY MICROSOFT EXCEL Lesson 3 – Organizing the Worksheet. Objectives. Copy data to other cells. Move data to other cells. Insert and delete columns and rows. Freeze titles. Use print options when printing a worksheet. Check the spelling of words in a worksheet.

troebuck
Télécharger la présentation

INTRODUCTORY MICROSOFT EXCEL Lesson 3 – Organizing the Worksheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. INTRODUCTORY MICROSOFT EXCELLesson 3 – Organizing the Worksheet

  2. Objectives • Copy data to other cells. • Move data to other cells. • Insert and delete columns and rows. • Freeze titles. • Use print options when printing a worksheet. • Check the spelling of words in a worksheet.

  3. Terms Used in This Lesson • Filling • Freezing

  4. Copy Data to Other Cells • There are several ways to copy data in a worksheet: • Copy and paste • Drag-and-drop • Fill cells

  5. Move Data to Other Cells • You can move data two ways. • Cutting and pasting • Drag-and-drop

  6. Insert and Delete Columns and Rows • When you want to delete a row or column: • Place the highlight in the row or column you want to delete. • Choose Delete on the Edit menu. • When the Delete dialog box appears, choose Entire row to delete the row, or Entire column to delete the column.

  7. Freeze Titles • Freezing keeps row or column titles on the screen no matter where you scroll in the worksheet. • To freeze titles: • Place the highlight below the row you want to freeze or to the right of the column you want to freeze. • Select Freeze Panes on the Window menu. • All rows above the highlight and columns to the left of the highlight will be frozen.

  8. Use Print Options • Before you print a worksheet, you need to design the page you are going to print. • The Page Setup command on the File menu allows you to set: • page margins • page lengths • page widths • page numbers • The Print Preview button on the Standard toolbar will display the page as it is to be printed

  9. Check the Spelling of Words • The Excel dictionary tool checks the spelling of words on a worksheet. • To spell-check a worksheet: • Select the Spelling command on the Tools menu, or • Click the Spelling button on the Formatting toolbar.

  10. Summary • The data in a worksheet can be moved or copied to another location by using the Cut, Copy, Paste, and Fill commands on the Edit menu. • Inserting or deleting rows and columns can change the appearance of the worksheet. • You can keep the titles on the screen at all times by freezing them.

  11. Summary • The Page Setup command controls the page size and the margins that will be used when printing. • Check the spelling of words in a worksheet by using the Spelling command on the Tools menu.

More Related