answersLogoWhite

0

A formula can be in the last cell of a row or column, but not actually outside of the worksheet itself. Formulas must be in actual cells.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

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 can you fix a spreadsheet if the user has forgotten to enter some important data?

It depends on what is missing. It might be a case of inserting a few blank rows or columns to enter the data in. You can do that by putting the cursor where you want the extra rows or columns to be and go to the Insert menu and pick Rows or pick Columns. You can then enter the data that is missing and redo the formulas. Whatever is missing, all you can do is enter it and fix up the spreadsheet. If you know what is missing and where you want to put it, then it is not a major problem. Before doing it, save a copy of the file as it is, with a different name, in case you need to go back to it and start again.


What are some words to do with spreadsheets?

Rows Columns Cells Formulas Functions Calculations Sort


What is a table or worksheet of data arranged in rows and columns using formulas to calculate data?

array


Do tables have both rows and cloumns?

yes - columns run vertically (top to bottom) and rows run horizontally (left to right)


What are data and rows in Microsoft Excel?

Anything you type into a cell like text, numbers, dates etc. is data. You can then enter formulas to do things with the data, and also use other facilities to do things with it. Rows are horizontal arrangements of cells. A worksheet is arranged in a grid. You therefore have rows and columns of cells.


How many rows and columns are there in chessboard?

There are eight rows and eight columns .


What is A grid comprised of horizontal rows an vertical columns into which you can enter data?

Generically it is called a table.


What is the difference between rows and columns?

Rows are horizontal and columns are vertical.


What are two names for rows in the periodic table?

Periods and the vertical columns are groups


How many rows and columns are there on the monitor screen?

10 rows and 80 columns


Limitations of msexcel rows and columns?

msexcel have 1048576 rows and 16386 columns