0
There are lots of reasons why you might hide cells. You may have a background calculation that is used by the more important formulas but which does not need to be shown on the worksheet. You might have something in a cell that does not need to be seen, maybe like some text that gives you information about the calculations. You may hide cells for formatting or layout purposes, like to have values in two columns or rows appearing beside each other when in reality there are columns or rows between them. You may want to hide a different version of a formula that is being shown.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What Are the Intersecting structures of an Excel worksheet called?
Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.Rows and columns intersect to form cells on an Excel worksheet.
How do you collapse rows in Excel?
There is no function to collapse rows in Excel, but you can hide rows you do not want to display. Highlight the rows you would like to hide and select Format | Hide and Unhide | Hide Rows.
How to hide columns of a spreadsheet in Microsoft Excel 2007 with the steps?
To hide columns of a spreadsheet in Microsoft Excel 2007 simply select the columns and click on the hide option.
How do I hide a row in Excel?
There are a few ways. You can use the Hide options in the menus on the old versions of Excel, under the Rows option on the Format menu. On the newer versions, you'll find it in the Visibility group in the Format options on the cells group. You can also hide a row by reducing its height until it cannot be seen. You can also use the Ctrl - 9 key combination.
How many cells in a 2007 Excel sheet?
17,179,869,184 cells in one excel
What security features are available in Excel to secure data?
A password can be put on a spreadsheet so it can't be opened. You can also allow it to be opened but have cells locked, using a password, so that the cells can't be changed. It is also possible to hide columns and rows and so hide the formulas.
What is the adjustment cells in Excel called?
Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.Adjusting what is in cells in Excel is known as editing. Changing the look of the content of cells or the cells themselves can be called formatting.
What is horizontal cells called in Excel?
A line of horizontal cells in Excel is known as a row.
What does alt f1 do in excel 2007?
Hide The menu Options.
What is the total maximum cells worksheet in 2007?
There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.There are 16,384 columns and 1,048,576 rows which makes 17,179,869,184 cells in an Excel 2007 worksheet.
How many cells in Excel 2007?
Excel 2007 has 1,048,576 rows and 16,384 columns, so you it has a total of 17,179,869,184 cells.
How many intersection of row and column in ns Excel?
Each intersection of a row and column is a cell. So it will depend on which version of Excel you have There are 16,777,216 cells in Excel 2003 and earlier. There are 17,179,869,184 cells in Excel 2007 and after.
