Understanding Workbooks and Worksheets in Excel

Understanding Workbooks and Worksheets in Excel (Video transcript)

In Excel, a workbook is a file and interchangeably a file is a workbook. we can see the name of the file or the workbook at the top of the screen. If it is a new file the name will be book1.

we can open up to seee

Every workbook is comprised of at least one worksheet. usually, there are three worksheets by default.

We can add sheets. We can delete sheets. We can move them. We can copy them.
all worksheet or simply sheet is comprised of columns and rows. Columns are vertical, are identified by letters. Rows are horizontal. They’re identified by numbers.

There are about 16,384 column and 1,048576 rows down.

Every cell, in Excel, on an Excel worksheet, has an address. Right now I’m in column A, row 3.

The address is list here, we call this a Name box where I’m circling with the mouse.

So to recap a workbook is a file and a file is a workbook. we have a working sheet, each has more than a million row and more than 16,000 columns.

Add Comment