Worksheets

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

The most common type of sheet is a worksheet, which is what people normally think of when they think of a spreadsheet. Worksheets contain cells, and the cells store data and formulas.

Every Excel worksheet has 256 columns and 65,536 rows. And, to answer a common question, the number of rows and columns cannot be changed. You can hide unneeded rows and columns to keep them out of view, but you cannot increase the number of rows or columns. The ability to increase the number of columns is probably among the top ten requests from Excel users, but Microsoft continues to ignore such requests. The reason is that it would require extensive rewriting of a large portion of the code.

Versions prior to Excel 97 had only 16,384 rows.

Versions prior to Excel 97 had only 16,384 rows.

The real value of using multiple worksheets in a workbook is not access to more cells. Rather, multiple worksheets enable you to organize your work better. Back in the old days, when a file comprised a single worksheet, developers wasted a lot of time trying to organize the worksheet to hold their information efficiently. Now you can store information on any number of worksheets and still access it instantly by clicking a sheet tab.

As you know, a worksheet cell can hold a constant value or the result of a formula. The value may be a number, a date, a Boolean value (True or False), or text. Every worksheet also has an invisible drawing layer, which lets you insert graphic objects, such as charts, diagrams, drawing objects, UserForm controls, pictures, and embedded objects.

You have complete control over the column widths and row heights — in fact, you can even hide rows and columns (as well as entire worksheets). Text in a cell can be displayed vertically (or at an angle) and even wrap around to occupy multiple lines.

Was this article helpful?

0 0

Post a comment