When I go to a already existing spreadsheet in numbers to make a change, the cell I am changing takes up that cell and the one below, would like it to just take up the one cell.
MacBook Pro 13″, macOS 10.13
each column or row cell now only has 1 digit
The column to the left of your digit has text that is wrapping to a second line within that cell. All it takes is one cell in the row to do this and the entire row will do it. All cells in a row are the same height (unless you have merged cells which you are not showing in your screenshot). Your screenshot does not show the text or your digit "taking up the cell and the one below". Each is in one cell as it should be. The cell/row height increased is all.
Was this file imported from another app, like Excel? It is possible it did not set the row heights upon import and left them to vary with the contents of the cells. It is possible the rows heights "fix" themselves to fit the data when you edit. If you want them to be a particular height and not change, select the rows you are concerned about, go to the Table tab in the sidebar on the right, scroll down until you see "row height", and type a number in there (even the same number will do if it is what you want).
Conversely, if it was imported it is possible it did set the row heights but didn't actually apply those settings to what you see and whenever you edit a row it "fixes" them. Just throwing out ideas. I've not seen this happen
each column or row cell now only has 1 digit
The column to the left of your digit has text that is wrapping to a second line within that cell. All it takes is one cell in the row to do this and the entire row will do it. All cells in a row are the same height (unless you have merged cells which you are not showing in your screenshot). Your screenshot does not show the text or your digit "taking up the cell and the one below". Each is in one cell as it should be. The cell/row height increased is all.
Was this file imported from another app, like Excel? It is possible it did not set the row heights upon import and left them to vary with the contents of the cells. It is possible the rows heights "fix" themselves to fit the data when you edit. If you want them to be a particular height and not change, select the rows you are concerned about, go to the Table tab in the sidebar on the right, scroll down until you see "row height", and type a number in there (even the same number will do if it is what you want).
Conversely, if it was imported it is possible it did set the row heights but didn't actually apply those settings to what you see and whenever you edit a row it "fixes" them. Just throwing out ideas. I've not seen this happen
It's hard to tell from you screenshot because you don't include the crucial row numbers and column letters.
Do you have something like this?
That is exactly the same as this:
The only difference between the two is that in the second won I made column A wider so the text doesn't wrap in cell A2.
SG
Can you post a screenshot? (shift-command-4, select area with cross-hairs, release, then start a new post here and use the 'mountains and moon' icon below the compose window to insert the screenshot image from the Desktop).
SG
Best I can tell is you have two cells merged. That is the only way I can think of for a cell to take up two rows. Right click on the cell and choose "unmerge cells" from the menu that pops up. That should separate them into two cells.
We can only guess because you are very sparse with the information you provide here.
However, I would guess that you have one or more columns that are narrow enough to have wrapping text in them.
That means that the height in the cells in the other columns expands to match the height of the cells in the columns with the text wrap.
SG
Well, it's good that you found your own post helpful.😀
Obviously, if you expand columns, you wouldn't expand the column with one digit. You'd want to expand any other columns that have wrapping text.
But again, we can't see what you see, and as you haven't posted details in a spreadsheet, it's just wild guessing at this point.
SG
"The column to the left of your digit has text that is wrapping to a second line within that cell. "
@ Badunit:
Good eye! I had to go back and look at that tiny screen shot to see the bit of an n (or m) at the left edge of the image.
Regards,
Barry
Here is a screen shot of what is happening when I enter a value - it takes up 2 cells.
Here is a screen shot of what is happening when I enter a value in a cell - it takes up 2 cells
It is just not a specific cell, row or column, every cell in the spreadsheet does this when I enter data. I have other spreadsheets that do not do that but can not see where the difference is.
I can expand columns as you suggest. But, each column or row cell now only has 1 digit, so hard to believe something is wrapping around, but will try it.
Got it fixed thabks
problem with adding data in a field in numbers
