0
What problems could result from deleting an entire row or column from a worksheet?
Wiki User
∙ 11y ago
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Sometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoSometimes the loss of a column or row that has data will cause formulas to give #REF! errors as formulas are trying reference cells that are no longer on the worksheet.
Add your answer:
Earn +20 pts
What is the function of the gray rectangle in the upper-left corner of a worksheet where the row and column heading meet?
You can click on it for a quick way to select the entire worksheet.
What action occurs when clicking the diamond icon located between the row numbers and the column letters in excel?
You select the entire worksheet.
How do you hilight all the rows in excel?
Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.Click on the box that is above the heading for Row 1 and to the left of the heading for Column A. It will select the entire worksheet.
How do you erase all the columns in Excel?
It depends on if you want to delete only the contents of the column or remove the entire column from the worksheet. If you want to remove the entire column, right-click on the column heading and click on the delete menu option. If you want to leave the column, and delete only the contents, right-click on the column heading and press the Delete key.
How do you highlight all the cells in a worksheet in Excel?
Click on the Select All button. It is in the top corner of the spreadsheet, above the 1 for row 1 and to the left of the A for column A, and is a blank button. Clicking on that will select the entire worksheet.
Can you format an entire column once?
You cannot format an entire column at once
What is the math symbol worksheet answers?
For copyright reasons WikiAnswers can not give out entire worksheet answers.
What button is used to hide an entire worksheet?
minimize
Used to hide an entire worksheet?
hide command
What button selects the entire worksheet in Excel?
Ctrl and A is one way. You can click on the Select All button, which is the blank button above the heading for row 1 and to the left of column A. Ctrl - Shift - Spacebar will also do it.
Can you reference an entire column or an entire row in a function argument by listing only the column or only the row?
yes
What symbol lets you select an entire column?
Just click the column header (where the column letter is).
