0
Cell display is what you see when you look at a cell and cell contents are what is in the cell. Sometimes they are the same, like when you type a number into a cell. Sometimes they are different, like when you type in a formula. When you've entered the formula the cell will normally show some value that the formula creates, like a total. So you might see a number, which is the cell display, but the cell still contains a formula, which is the cell content. If you put the cursor onto a cell and look at the formula bar, it will show you what is in the cell.
Formatting a cell can also change the cell display, but not the contents. If you put a number into a cell and format it to currency, you will see the currency value, with a currency symbol and probably two decimal places, but the cell still just contains the number you originally entered.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Why do you manipulate a spreadsheet cell?
to get them to look how you want them to look
Where would value be located in excel?
Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.
What is the purpose of the entry and formula bar in a spreadsheet?
View existing contents of a cell, and enter a formula or other contents into the cell.
What does a series of number signs mean in a cell?
Assuming you mean a cell in a spreadsheet program, when the contents are displayed as #####, it usually means the cell is not wide enough to display the contents. One way to widen the cell is to click and drag the mouse pointer at the edge of the column header. Another is to select the column and change the column width.
What display the contents of the active cell?
formula bar
What is a spreadsheet display bar?
You may be referring the formula bar. It displays the cells contents, which can be values or formulas.
What does it mean when a cell in a spreadsheet is active?
The Active Cell on a spreadsheet is the cell where the cursor is pointing. That means that you can write to or erase the contents that cell location directly. A spreadsheet program has the entire array in memory, but the Active Cell is the place where it is 'looking or thinking about' at any particular moment.
What does align center mean?
Configure a cell to display the cell contents in the middle of the cell (with the same amount of space on both sides of the contents).
Arithmetic operator that divides contents of cell?
The / is used for division in spreadsheet formulas.
What does the formula box display?
It displays contents of the active cell.
Can I display a formula instead of the value in a spreadsheet?
To display the formula, not its results, in a cell, a user can choose a format for "text."
In excel why does text appear as hash?
If you see a cell with a lot of has symbols in it, like #####, it usually means the cell is not wide enough to display its contents. This normally applies to numbers, not text. If you widen the column that the cell is in, it will display the contents correctly.
