Anything Under the Sun

1.) Navigating the Microsoft Excel Program



2.) Activating and Selecting Cells
- A cell is the intersection of a column and a row.

• To Activate a Cell

-> Click the cell you want to activate.

• To Select a Range of Cells

-> Click the first cell that you want to select.
Drag the mouse to highlight the selected cells.

• To Select Multiple Ranges

-> Click the first cell of the range.
Hold down the CTRL key, then drag to select the second cell or the range of cells.

• To Select an Entire Column

-> Click the Column Heading of the column that you want to select.
Please CTRL + Spacebar to select the row in which the active cell belongs to.

• To Select an Entire Row

-> Click the Row Heading of the row you want to select.
-> Press SHIFT + Spacebar to select the row in which the active cell belongs to.

3.) Creating a New Workbook
- A Blank Workbook is an empty workbook file with the default settings of Excel.

• To Create a Blank Workbook

-> On the File Menu, click New. Click Blank Workbook on the New Workbook Task Pane,
-> Click the New Button on the Standard Toolbar.
-> Press CTRL + N.

• To Create a Workbook Based on a Template

-> In the File Menu, click New.
->Choose General Template on the New Workbook Task Pane.
-> Click the Spreadsheet Solution Tab or the tab listing your custom templates.
-> Double-click the template for the workbook that you want to create.

4. Saving A Workbook
- A workbook file name can be as long as 255 characters, inclusive of spaces. A file name cannot contain any of the following characters: \ / : * ? “ < >

• To Save a Workbook for the First Time

-> Click the Save Button on the Standard Toolbar.
-> On the File Menu, click Save.
-> Press CTRL + S.

• To Save a Workbook Under a Different Name, File Type and/or Location

-> On the File Menu, click Save As.
-> Press F12

• To Save Changes to a Workbook

-> Click the Save Button on the Standard Toolbar.
-> On the File Menu, click Save.
-> Press CTRL + S.

5.) Protecting a Workbook

• To Protect a Workbook from Viewing

-> On the File Menu, click Save As.
-> Choose the Tools Menu, and then click General Options.
-> Type a password for Password to Modify.
-> Click OK.
-> Retype your Password to Modify for confirmation.
-> Click Save.

• To Protect a Workbook from Editing

-> On the File Menu, click Save As.
-> Choose the Tools Menu, and then click General Options.
-> Type a Password for Password to Modify.
-> Click OK.
-> Retype your Password to Modify for confirmation.
-> Click Save.

6.) Locate a File

• To Search for a Workbook File Containing a Specified Text

-> Click Search on the Standard Toolbar.
-> On the File Menu, click Search.
-> Choose Search on the Task Pane.

• To Search for a Workbook File Based on One or More Properties

-> Click Search on the Standard Toolbar
-> On the File Menu, click Search.
-> Choose Search on the Task Panel.

7.) Getting Help
- Office Assistant is an animated character that appears on your screen and responds to your questions.

• To Use of the Office Assistant

-> In the Help Menu, click Show Office Assistant.
-> Press F1.

• To Change the Office Assistant

-> Right-click the Office Assistant.
-> Choose Choose Animate. The Office Assistant Dialog Box opens.
-> Click the Gallery Tab.
-> Click Back or Next to see other Office Assistants.
-> Click OK to change the Office Assistant Character, otherwise, click Cancel.

• To Use the Ask Question Box

-> Click the Ask a Question Box on the Menu bar.
-> Type your question and press the Enter key.
-> Click one of the topics that encompasses your question (The Help Window displays the topic.)
-> Click the Help Window Close Button to close Help Window.