answersLogoWhite

0

The CELL function is used to get information about a cell. This can be things like its address, format, filename etc. While some of those things can be obvious, there are times when it is useful to get them. If you are looking for the address of a cell that has been given a name for example, as in the following example. The characteristic that you are looking for must be enclosed in brackets, and they are given to you to choose from as you enter the function. The following example gets the address of a cell that has been given the name TotalSales.

=CELL("address", TotalSales)

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

What does Insert Function mean on Excel?

Insert Function in Excel allows you to enter a function into your worksheet. You can choose your function from different categories fo functions. It will also give you a little help on the function so that you can use it in the correct way.


What does today mean in Excel?

The TODAY function returns the current date when the function is executed. That would be when you open the document or when you insert the function for the first time in a cell.


In Excel what displays the cell address the Insert Function button and the contents of the current cell?

The Formula Bar shows those things. Included in it is what is specifically known as the Name Box, which is where the address is shown. The Insert Function button is beside that and then the Formula Box part, when you can see the contents of the cell.


What can be used to find an Excel function by typing a description of the formula?

You can use the Insert Function button fx on the Formula bar to find an Excel function by typing a description of the formula at the Insert Function dialog box, in the Search for a function text box and then click Go.


How do you insert a picture in an Excel cell?

You cannot actually put a picture into a cell in Excel. Pictures and graphics sit on top of the worksheet but are not tied to any cell and so are not in a cell. So you can basically put a picture or graphic over a cell, but it is not actually in a cell, like you can put numbers or dates or text into a cell. They can be put into a worksheet by using the Insert Tab in newer versions of Excel, or the Insert menu in older versions. It can also be done through the Drawing toolbar.


How can you add comments in a cell of Microsoft Excel?

Right-click on the cell and select Insert Comments, then enter your comment.


What keyboard combination will insert a line break inside a cell in Excel?

Alt+Enter


When the function argument box appears in excel?

When you choose the Insert Function command and then pick a function to use, it will appear so that you can type arguments into it.


Can you place a photo in a cell of an Excel chart?

Yes. Click on Insert and then Picture.


What is the dialog box containing predefined functions available in Excel?

The Insert Function dialog box.


What is an excel function used to enter the system date in a cell in a worksheet?

The NOW function


What function in Excel moves the cell pointer to cell A1?

Press Ctrl - Home.