0
If you have a cell with a value in it in the bottom row or last column and then try to insert extra rows or columns, it will be forcing that data off, which would mean losing data, so you are not allowed to do so. Either make sure there is nothing in the last row or column, and if there is, you could move the data elsewhere.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
The grid of rectangular cells is called?
If you are talking about an individual cell it's a field. If you are talking about the whole thing, that is your spread sheet.
What is the formula used to duplicate a cell on a different sheet in excel?
To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25To specify something on a separate sheet you need to type the sheet name and an exclamation mark and then the cell reference. So if you wanted to show what was in cell C25 on Sheet1 on a different sheet, on the other sheet you would type:=Sheet1!C25
How do you copy a protected cell in excel without removing the protection to another excel sheet?
Cell protection only kicks in when you protect the entire sheet. So for the cell to be protected, then the sheet has to be protected.
What is a cell refrence?
A cell reference is a cell that identifies a particular cell in a spread sheet.
What do you call a reference cell on another sheet?
There is no particular name in full, except we do talk about part of it being a sheet reference. So you have a sheet reference and a cell reference together. To do the reference you need the sheet name, followed by an exclamation mark, followed by the cell. The following refers to cell C3 on Sheet2: =Sheet2!C3
What has a thin double layered sheet around the cell?
cell memrane
Thin double layered sheet around the cell?
cell membrane
In Excel 2007 how can you add a cell from one sheet to a cell on another sheet of the same workbook?
To specify a cell on another sheet, you need to use the name of the sheet and an exclamation mark before the cell reference. If you do not put a sheetname before a cell, it assumes the cell is from the current sheet. So if you were on Sheet2 and wanted to add a value in cell C5 on Sheet1 to cell C6 on Sheet2, then the formula would be: =Sheet1!C5+C6 If you were on Sheet3 and wanted to add a value in cell C5 on Sheet1 to cell C6 on Sheet2, then the formula would be: =Sheet1!C5+Sheet2!C6 If you have renamed your sheets then you use the new names for the sheets, rather that Sheet1, Sheet2 etc.
What is the first cell address in an excel sheet?
A1 is the address of the first cell.
How do you transer just the particular cells from one sheet to another i.e. automatically after one fills in sheet 1 in a random cell it will appear in a designated cell in sheet 2?
Just copy and paste :P
Single box in a spread sheet is called?
A cell.
What is the advantages of a spread sheet?
A spread sheet is good for complicated equations, such as if statements and absolute cell reference.
