Lesson 1 - Spreadsheet Creation and Management

# Module 1 ms office ms excel 32 navigating the

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: to desired cell, by typing the cell reference IT Training Module 1 MS OFFICE (MS Excel) 33 Navigating the Worksheet Navigating the Worksheet CTRL + HOME To go to the FIRST COLUMN & FIRST ROW = (A1) IT Training Module 1 MS OFFICE (MS Excel) 34 Selecting Cell/Cells Selecting Cell/Cells Workingusing the with 1.Click at the cell mouse. Worksheets OR 2. Use the arrow keys. IT Training Module 1 MS OFFICE (MS Excel) 35 Selecting Adjacent Range of Cells Selecting Adjacent Range of Cells • Click at the beginning cell. • Drag to the next cell or range of cells beginning cell (C4) Cell range is: C4:C11 C4:C11 IT Training Module 1 last cell (C11) MS OFFICE (MS Excel) 36 Selecting Non- Adjacent Range of Cells Selecting Non- Adjacent Range of Cells • Click at the beginning cell. • Press the CTRL key, then click to the the next cell or range of cells Selected using a CTRL key IT Training Module 1 MS OFFICE (MS Excel) 37 Selecting ALL Cells Selecting ALL Cells • Click the ALL CELLS BOX IT Training Module 1 MS OFFICE (MS Excel) 38 Selecting ROW/S Selecting ROW/S • Click the row number Entire row of A6 : IV6 A6 IT Training Module 1 MS OFFICE (MS Excel) 39 Selecting COLUMN/S Selecting COLUMN/S • Click the column letter Entire column of D1 : D65,536 D1 IT Training Module 1 MS OFFICE (MS Excel) 40 Increasing/Decreasing Column Width Increasing/Decreasing Column Width 1. Select the cell where the column will be increased/decreased. • Click the FORMAT menu •...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online