answersLogoWhite

0


Best Answer

A Microsoft Excel 97 through Excel 2003 worksheet contains 65,536 rows. A Microsoft Excel 2007 workbook saved in one of the new formats (.xlsx, .xlsm) has worksheets with 1,048,576 rows.

User Avatar

Wiki User

โˆ™ 2009-08-25 15:09:43
This answer is:
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
User Avatar
Study guides

Microsoft Excel

20 cards

How much can you sell a mirraco icon option for

Road wheel torque settings for peugeot 106 1.4

What kind of data do you write on a data table

What tab or dialog box do you use to organize your sources

โžก๏ธ
See all cards
5.0
โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…โ˜†โ˜…
1 Review

Add your answer:

Earn +20 pts
Q: How much rows does worksheet contains?
Write your answer...
Submit
Related questions

A series of rows and columns that contains related data that is managed independently from the data in other rows and columns in the worksheet is an Excel?

table


How many rows are there in a worksheet?

There are 1,048,576 rows in each Excel 2007 worksheet.


How are rows identified in a worksheet?

They appear Horizontally in a worksheet


How can you determine if rows in an Excel worksheet are hidden?

Row numbers for the hidden rows will be missing on the side of the worksheet.


How may rows in an Excel Worksheet?

The rows on exel are endless


Grid of columns and rows in excel?

A worksheet.


What contains descriptive information about items in rows or contain information that helps to group the data in the worksheet?

They would be called headings or labels.


What appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window?

Rows.


When using a spreadsheet the rows and columns collectively are called?

Worksheet


How can you increase number of rows in a worksheet?

The amount of rows in a worksheet is fixed, so you cannot increase the amount of rows. What you can do is insert rows into part of a spreadsheet. It will have the effect of pushing rows down, but it will not increase the amount of rows in the worksheet. One of the reasons there are so many rows is that you will never use all of them, so it can push rows down to accommodate inserted rows and get rid of blank rows, but not increase the amount of rows that are in the worksheet. Excel 2007 has more rows than many of the earlier versions. It is has 1,048,576 rows whereas many of the earlier versions had 65,536 rows. Even that is more than enough to accommodate the spreadsheets that people normally create.


How are rows and columns in a worksheet identified?

Rows are horizontal and numbered; columns are vertical and lettered.


How much cells can a spreadsheet in Microsoft Excel have?

Excel 2003 and earlier has 16,777,216 cells per worksheet (65,536 rows * 256 columns). Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).


How do you keep the titles and column labels of a worksheet on the screen no matter the worksheet is scrolled?

By freezing the rows


What does Excel call a worksheet that contains contiguous rows and columns of data where the first row of each column serves as a label?

That can be called a table.


What is the difference between sheet tabs and worksheets?

A worksheet contains columns, rows and cells and is where you do your work. Each worksheet has a name. You can have more than one worksheet in a workbook. Each worksheet has a tab at the bottom of the screen, with its name on it. This is a sheet tab. It allows you to identify the different worksheets and by clicking on a sheet tab, you can change from one worksheet to another.


What cells is a spreadsheet are arranged in columns and rows on a?

A worksheet consists of columns and rows, making up cells.


What can be the maximum number of rows available in an excel worksheet?

there are 65,536 rows and over 200 cells (IV) (:


What is the definiton of chart sheet?

It is a sheet that only contains a chart and has no columns or rows. It shows a chart completely on its own sheet instead of being embedded in a worksheet.


The worksheet that contains the totals from other worksheets is?

a summary worksheet


How many rows are on a single page of Excel 2007?

In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.In terms of the worksheet, there are 1,048,576 rows on a single worksheet in Excel 2007. If you are talking about how many will appear on a single page when printing, that will depend on how you scale your page and things like the size of the rows or your text. It might be 20 rows, it could be 50 rows. The way you have your page or printer set can also affect the amount of rows on a page. So there is no single answer to the question.


A worksheet has rows that run vertically and columns that run horizontally?

No. Rows run horizontally and columns run vertically.


What in a worksheet typically contain information that is similar to items in a list?

Rows


How are individual rows identified on a worksheet?

by numbers on the left side of the screen


An excel worksheet is divided into?

Rows and columns, which in turn gives you cells.


A worksheet with financial data laid out in rows and columns?

It is called a spreadsheet.