0
What effect does the insertion of rows at the top of a spreadsheet have in excel?
Wiki User
∙ 14y ago
It will push down all rows below it, renumbering them and changing the formulas as necessary.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What displays informatoin in rows and columns?
Spreadsheet, such as that in MicroSoft Excel
On an Excel spreadsheet what is in the column spaced horizontally?
Columns are vertical, rows are horizontal.
What is the effect called in Excel that displays alternate rows with color?
They are banded rows.
When a delimited file is imported into Excel fields become?
Different fields will go into columns in the spreadsheet. Records would go into rows in the spreadsheet.
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).
What is a saved workbook called in excel?
A saved workbook in excel is called a spreadsheet. It contains one or more worksheets, which is an arrangement of columns and rows.
When using spreadsheet software what are the rows and columns collectively are called?
Cells
What is the total number of rows in Microsoft Excel 2010?
In Excel 2010 the number of rows per worksheet is 1,048,576 and the number of columns is 16,384 which is column XFD. That makes 17,179,869,184 cells.
Excel spreadsheets display rows and columns which are made up of individual?
The individual box on a spreadsheet is known as a cell.
What is spreadsheet software?
A spreadsheet software is a program or application that is used to organize, analyze and store information in a digital worksheet. This type of application is commonly used in financial computations and documentations.
Can you convert an Excel 2003 spreadsheet to 2010 to add more rows?
If you have 2010, then you can open it and save it as a 2010 workbook. It won't open with Excel 2003 after that though so you cannot have the benefit of the extra rows in Excel 2003. That is one of the reasons for using 2007 or 2010.
What is a data table in Excel?
A data table in Excel is any spreadsheet tab containing information in columns and rows. Usually, but not always, the information is numbers of various sorts.
