It's probably a simple cell formating issue...

[WestCoastKid]

Help me out Gang,
What do I need to do so that when I write to a cell the content continues to write "into" the next cell.

The problem I'm having is some of my cells allow for the content to "carry over" or write through and some do not, the content ends up being cut off by the next cell
- most importantly I don't know what mechanism is in place that controls this feature.

Any ideas?

Thanks in advance.

 

[hneal98]

You can expand the cell to the size of the content.

 

[Lilliabeth]

Text that is longer than the width of the cell will be allowed to flow out on top of (not into) ajoining cells provided the ajoining cells are empty. If the ajoining cells are not empty, either the cell will widen, or the display will be truncated (the data is not chopped off, only the display is).

Numbers will not behave this way - if they did you could easily make bad business decisions because a number could, for example, flow fom the credit column onto the debit column. If the active cell is too narrow to display the entire number, then the cell will display #'s - this is your cue to widen the cell.

You can get a decent Excel book for next to nothing and it would no doubt be a great help.

 

[lostAndConfused]

To add onto Lillebeth's post... A common mistake is that a cell with a space is not an empty cell. Make sure to press delete when clearing the contents of a cell. Otherwise, the cell will appear empty when, in fact, it is not.

 

[byundt]

A couple of tricks worth knowing:

1) Excel can adjust the column width to fit the data. To do this, select the entire column (by clicking on the letter at the top of the column), then open the Format...Column menu item. Choose AutoFit.

2) Excel can wrap the text into additional lines in the same cell, usually (but not always) increasing row height as required to display the extra lines. To do this, select the cell(s) and open the Format...Cells menu item. Go to the Alignment tab, and check the box for "Wrap text".

If you need to increase the row height to take advantage of tip #2, then click on the gridline just under the row number, hold the mouse button down and drag that gridline lower.

Brad