0
Does adding or deleting columns have any effect on formulas and functions on Microsoft excel?
Wiki User
∙ 9y ago
That depends on what columns are added or deleted and what functions are being used and what cells they are referencing. Sometime Excel can adjust the functions so that they continue to reference the correct cells. In other cases, removing a column might remove an important value for a function causing an error, such as the #REF! error. That can occur when a formula is looking for a cell that is no longer on the worksheet.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What are some words to do with spreadsheets?
Rows Columns Cells Formulas Functions Calculations Sort
How many columns are there in Microsoft Excel 2000?
Microsoft Excel 2000 has 256 columns.
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 does columns run in Microsoft Excel?
Columns are vertical cells (they run up and down).
What is a sentence using the word columns?
Microsoft Excel makes perfect columns. She took a picture of the building's granite columns.
What allows you to use rows and columns?
Microsoft Excel
When you add or delete rows or columns in a worksheet excel automatically adjust all the formulas h?
Formulas will adjust when rows and columns are added or deleted.
How many rows and columns are there in Microsoft Excel 2000?
There are 256 Columns and 65,536 Rows in Excel 2000.
What are the columns in Microsoft Access table called?
In a Microsoft Access table each column shows the information in a field. Each row shows a record.
What is a computer accounting program that represents numbers in rows and columns?
This might be referring to Microsoft Excel. It's a spreadsheet-based application that tracks information in rows and columns and can perform mathematical functions with the individual intersection points of those rows and columns, called "cells." It's usually used for accounting purposes but has many other uses.
What displays informatoin in rows and columns?
Spreadsheet, such as that in MicroSoft Excel
What are the features of Microsoft Excel that can be used for accounting?
almost unlimited arithmetic calculationsorganizing into rows and columns, like a ledgerlinking multiple worksheets together to populate a summary pagemany bult-in functions for financial calculations
