I have a simple formula in my Excel spreadsheet '=B-5'. Looks fine but when I print it off a hard copy on my printer, the cell shows '######'. This is happening w/ all my formulas. Any ideas?
2007-08-15 04:36:35 · 9 answers · asked by lavender 1 in Computers & Internet ➔ Software
make the column wider
2007-08-15 04:43:55 · answer #1 · answered by Anonymous · 0⤊ 0⤋
It could be that you don't have the cell wide enough. Normally Excell will give you a ###### when it can't fit the contents in the cell. However, your formula doesn't look right either.
You have "=B-5"
If you are referring to the cell B5, that should be:
=B5
There shouldn't be a hyphen between the column letter and the row number. If you have that hyphen there, Excel will think you are referring to a named cell range called B. So according to your formula, Excel is trying to subtract 5 from a cell range called B and it can't do that if there isn't a range named B.
If you are typing the formula in, you can avoid this happening by selecting the cells you want to refer to in your formula instead of trying to type them out. If you want to use different absolute references for the cell. Just hit F4 to select through the different types of references.
2007-08-16 05:13:43 · answer #2 · answered by devilishblueyes 7 · 0⤊ 0⤋
The cell is not wide enough. Format/ Column Width and make it 12. It should print fine then.
2007-08-15 04:44:03 · answer #3 · answered by Stareyes 5 · 0⤊ 0⤋
File -> Page Set up. Select the sheet tab. There should be an option about half way down that says "gridlines" check that checkbox. Excel will only print gridlines around the information you have in the cells, no more.
2016-05-18 03:52:20 · answer #4 · answered by ? 3 · 0⤊ 0⤋
The value is to big to display in the cell. Double click the column to auto fit the contents. Use Print Preview to see how it will look before you print it.
2007-08-15 04:45:21 · answer #5 · answered by The Desert Bird 5 · 0⤊ 0⤋
expand the width of the cell with the formula
2007-08-15 04:44:08 · answer #6 · answered by mamaboy7 3 · 0⤊ 0⤋
Make the cell wider. That is the solution to this
2007-08-15 04:44:11 · answer #7 · answered by flip_can 3 · 0⤊ 0⤋
you need to make the cell a bit wider
whilst it may fit into the cell on screen, it may not when trying to fit it onto a bit of paper.
2007-08-15 04:43:40 · answer #8 · answered by Dave 4 · 0⤊ 0⤋
your cell width is too small - increase the width of the column to
see the entire amount .
2007-08-15 04:43:49 · answer #9 · answered by jonbel 3 · 0⤊ 0⤋