A new workbook

Whenever we open a new “Workbook” in “Excel” 2010, it will be named “Book1” (1) by default. If for some reason this “Worksheet” closes, click the “File” (2) button in the “Ribbon”, choose the “New” category in the “Backstage” view and double-click the “Blank Workbook ” template.

Each new “Workbook” comes with three standard “Worksheets (3), “Sheet1” Sheet2 “and” Sheet3 “. How original….
Are you one of the many that usually works with only one “Worksheet”? If you like you can delete the unused sheets. We explained how to do this in Lesson 4 “Excel Options” – “General” category.

 

Worksheets

If you wish to give a name for a “Worksheet”, double-click on the worksheet name (1) and type a name.

If you wish to add a “Worksheet”, click the “Insert Worksheet” (2) icon at the bottom.

 

If you want to move a sheet, click and drag (1) it to the desired position. Where the black triangle appears (2), the “Worksheet” will position itself and then you can release the mouse button.

 

If you want to copy a “Worksheet”, do the same thing, but you hold the Ctrl key on your keyboard pressed.

 

To copy a “Worksheet” to another “Workbook”, open both “Workbooks” side by side (see Lesson 13), Hold the Ctrl key on your keyboard while you drag the “Worksheet” from the one “Workbook” to the other.

 

If you want to delete a “Worksheet”, right-click the tab for the worksheet and choose “Delete” from the drop-down menu.

 

If you want to change the color of a spreadsheet tab, right-click the tab, select “Tab Color” in the pop-up menu, and choose a color from the available colors panel.

 

If you want to hide a “Worksheet”, right-click the tab and click “Hide” from the pop-up menu. To show the “Worksheet” again, repeat this operation on another tab, but choose “Unhide” from the pop-up menu. A box will appear with all the hidden “Worksheets”. Select the “Worksheet” that you want to make visible again, and click the OK button.

 

Data type

The intersection of a row and a column is called a cell. We type all our data in cells. To identify a cell, we use the first column title (eg A) and the row number (eg 1). For example, in the illustration below the C5 cell is selected. You can see this because of the black delineated frame around the cell. “C5” also appears in the “Name box”.

Text is always left aligned by default and numbers are always right justified.

Once you have typed data in a cell, click the Enter key on your keyboard.

This moves your cursor one cell down in the same column. If you would like to change this, you can do this in the “Excel Options” dialog box under the “Advanced” tab.

In order to enter information into a cell, select the cell first and then start typing.

The information that you type appears in the cell and in the “Formula bar”.

To confirm click the “Enter” key on your keyboard, and to delete the contents of a cell, select the cell again and press the “Delete” key on your keyboard.

TIPS!

1. If you want to keep the cell selected when you click the Enter key, hold the Ctrl key on your keyboard pressed.
2. If you want to move your cursor to the right when pressing Enter in a cell, you can change this option in the “Excel Options” dialog box. You can also click the tab key on your keyboard.
3. If you want the cell to move to the left, you can also change this in the “Excel Options” dialog box or click the SHIFT TAB keys on your keyboard.

 

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats