how to do a carriage return in excel for a mac

Use the appropriate flair for non-questions.

Post titles must be specific to your problem.

Think ahead if other people might be using this sheet, and not be expecting to have some data hidden.

This can cause its own set of problems if one or two digits are neatly hidden away. They will simply truncate anything that doesn't fit.īe careful now, because parts of your data may be hidden. Your cells will now not spill over either horizontally or vertically. Check the height of an adjacent row for a good value. Now select the row(s) in question and manually set the row height, by right clicking the row number and selecting 'Row Height'. Select the cells in question and turn on text wrapping (Format>Cells>Alignment>Wrap Text). This is unnecessary, a pain in the but, and will mess up any ISBLANK type formulas, among other things. Some people have suggested putting a space in the next cell. Each of those solutions can mess up the layout of your sheet. Of course, you can make the column wider or turn on text wrapping, but you might not want to. How can you prevent a cell's contents from overflowing into the next cell? I am posting this solution for anybody still struggling with this. I saw two threads in this forum that asked this question, with no good answer. I tried it on several new/different spreadsheets but it keeps happening. I ran a scan for viruses and none were found. Has anyone ever seen this before? I have no idea what is going on. It is like the act of putting the cursor in the formula activates it to work properly but until it is activated that C cell shows the value of the cell which it was dragged down from. When I click on the Column C cells and then it shows the formula up top in the formula bar and if I put my cursor anywhere in the formula bar and hit Return the formula does not change however the correct value then appears in the Column C cell. For instance, the formula in C2 is =A2/B2 however the value of that cell showed 542 which was not the correct math/value.īut it gets even more weird. And when I went to check to see if the formula was correctly dragged it was. So I dragged that formula down and it showed 542 in all column C cells which is not correct. The math was correct it showed 542 in the C1 cell. then in column C, I made the formula C1=A1/B1. I typed in values for column A rows 1 through 10 then values for column B rows 1 through 10.

How to do a carriage return in excel for a mac