Exploring Your Excel Workbook

How do you feel about Excel? Is it difficult? If the previous content is about basic about Excel, so today will I share his connection to Excel usage?

Lets exploring your Excel workbook!

To explore your workbook, you must be using your worksheets.

First, Using Worksheets

Excel 2016 gives you one worksheet in a workbook, but you can add more worksheets (and other types of sheets, such as a chart sheet, macro sheet, or dialog sheet), rename them, or delete them as needed.

The name (or title) of a worksheet appears on its sheet tab at the bottom of the screen. By default, the name is Sheet1, Sheet2, and so on, but you can give any worksheet a more appropriate name.

Note: Sheet tabs are displayed by default. If you don't see them, click Options > Advanced > Display options for this workbook > Show Sheet tabs. 

To using a worksheet you must insert a new worksheet. See below.

Insert a new worksheet

Do one of the following:

• Click the New sheet button at the bottom of the screen.

• To insert a new worksheet in front of an existing worksheet, select the existing worksheet and then, click Home > Insert, > Insert Sheet.

To change the order of the worksheets in a workbook, click the tab of the worksheet that you want to move, and then drag it to the location that you want.

Insert multiple worksheets at the same time

1. Press Shift and select the same number of existing sheet tabs of the worksheets that you want to insert in the open workbook. For example, to add three worksheets, select three existing sheet tabs. 
2. Click Home > Insert > Insert Sheet.

To change the order of the worksheets in a workbook, click the tab of the worksheet that you want to move, and then drag it to the location that you want.

Change the default number of worksheets in a new workbook

1. Click the File tab.
2. Click Options. 
3. In the General category, under When creating new workbooks, in the Include this many sheets box, enter the number of sheets that you want to include by default when you create a new workbook.

Rename a worksheet 

1. On the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename.
   
2. Select the current name, and then type the new name.

Delete one or more worksheets

1. Select the worksheet or worksheets that you want to delete.
2. Click Home, click the arrow below Delete, and then click Delete Sheet.

You can also right-click the sheet tab of a worksheet or a sheet tab of any selected worksheets that you want to delete, and then click Delete Sheet.

Some tips for you when you select multiple worksheets, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

Second is the Active Cell

Active cell address appears on the Name Box to the left of the formula bar.

Third is Selecting Cells

To select a cell, simply click on a cell under a column from a row. You will see the cell address appears on the Name Box to the left of the formula bar.

Fourth is Using Zoom

To zoom, go to Zoom group in View tab or use the zoom slider

For your information, each Excel 2016 worksheet have 1,048,576 rows and 16,384 colums (Last column = XFD).

As a beginner, you need to use Excel productively. So if you often use Excel you'll get used to it and it's easier to use Excel in everyday life.