Structure of a Worksheet or Workbook in Excel 2013

show more The structure of a worksheet or workbook provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training show less
please wait ...

The structure of a worksheet or workbook

In Excel the term "workbook" and the term "file" mean the same thing. We are currently looking at a workbook called "01-Getting Started" and you see that name at the top of the screen. If you're working with a brand-new workbook, you'll see a name like Book 1 or Book 2 perhaps, at the top of the screen. We use those terms workbook and file interchangeably, as we work with Excel. Every workbook is comprised of at least one worksheet. At the bottom of the screen, we see a sheet tab, maybe one, two, three, perhaps many.

You can add sheets, you can delete sheets, you can change their name, you can move them left and right. Every worksheet has the same general characteristics. For example, as I use the mouse here to click on the sheet called, 2013 HOME products revenue, we see column letters across the top, row numbers down the left-hand side. A worksheet is comprised of columns and rows, and we never want to use the two terms interchangeably. Rows are horizontal, columns are vertical.

If you use the mouse to click on a cell, you've selected the cell, you'll hear that term used from time to time. Let's select a cell. This is in column G, row 1, therefore it's called "cell G1". As you work with Excel, you do frequently need to refer to a cell by its location, that address as it sometimes is called, that's cell G7. Just above the column letters over on the left-hand side, you'll see an indicator as to what the current address is.

Sometimes, you'll hold down the left mouse button and highlight more than one cell. Still, within that highlighted selection, the cell that you begin to do the dragging with is referred to as the active cell, and you see its address, once again in the upper left-hand corner. Now, if I go to a different worksheet, typically, we do this with the mouse. We can click another worksheet name at the bottom, this is for existing files where you already have data, we go to a different worksheet-- this one has a chart in it. There's another worksheet down there called Profits. Let's click on this.

Now, every one of these worksheets does have the same number of columns. In this worksheet here, the active cell is at K1, if I start pushing the right arrow keys-- and possibly we could do this by scrolling as well-- after coming to the letter Z, the lettering scheme begins all over again with AA, AB, AC, and so on. This continues for over 16,000 columns. If you happen to press Ctrl+Right Arrow by the way, this will take you to the very last column XFD, and that's over 16,000 columns.

Getting back to the upper left-hand corner of any worksheet, Ctrl+Home, nearly, always this means go to cell A1. In some case, there is an exception to that with frozen titles. As we move down the screen, pressing the Down Arrow, we see the row numbers on the left-hand side, and eventually, if we kept doing this, and it would take a long, long time, we will reach the very bottom. I'm going to press Ctrl+Down Arrow here, and we're now well over a million rows. That number by the way is a power of two, the underlying math here is all binary, we don't worry about that too much.

Ctrl+Home will take us back to the upper left-hand corner. Every worksheet has the same number of columns and rows. At different times, as you will see, we can easily adjust the width of the columns and the height of the rows as necessary. So in Excel workbook comprised of one or more sheets, you can add sheets, at anytime, take them out and the more you work with Excel, the more you will see that from time to time it will make sense to have multiple worksheets within the same workbook.

The structure of a worksheet or workbook
Video duration: 3m 41s 6h 32m Appropriate for all


The structure of a worksheet or workbook provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training

Business Education + Elearning
please wait ...