0
What is the difference in Excel of clearing a row and deleating a row?
Wiki User
∙ 10y ago
If the row is cleared, then there will be no data in it, but the row will still be there. If the row is deleted, then it is completely gone and the rows that were below will all have moved up and been reassigned row numbers.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is the difference between the way Access saves a record and the way Excel saves a row in a work sheet?
the difference between the way Access saves a record and the way Excel saves a row in a worksheet. Answer
In what ways can you modify this Excel 2007 table using options on the Design tab of the Ribbon?
You can insert column H in the table by selecting the Resize Table button You can insert a total row from which you can access common Excel functions You can remove row 3 from the table by clearing the Header Row checkbox
What is clearing a row?
Clearing a row removes the content and format of all cells in the row, but it does not remove the row. It leaves a completely blank row in the worksheet.
When you select a row and ask Excel to insert a row where is the new row inserted?
It is inserted above it.
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.
What is the path to the sum arrow?
When you reduce the row height in excel the row is hidden
What three elements indicate an Excel table is created in a worksheet?
Header Row, Banded Row and Calculated Columns make up an Excel Table.
What is the bottom number on Microsoft Excel?
The last row number for Excel 2007 is 1048576.
What is the first row of the excel database that contains field names called?
heading row
How do you called a row from excel in Access?
In Access, a row from a spreadsheet is normally a record.
What is horizontal cells called in Excel?
A line of horizontal cells in Excel is known as a row.
What is the row height of Excel 2007?
By selecting an empty row and pressing Ctrl + 'Down arrow key', the selected cell will be the next item down the column. The row height in Excel 2010 is 1048576 cells.
