To want to see my Excel columns?

[FlamedToACrisp]

I can't figure out how to make the wording in all my columns visible simultaneously, like it is in an ordinary table. What should I do to fix it?

You either need to make the columns wider or format the cells to 'merge' (which will be better)

Wrap the text?
Right mouse click on the cell, select format cells and its in there somewhere

Double click at the top of the col where the letter is and it will expand to the longest think in it

autosize the columns - click on the arrow top left to select everything, then click on one of the column divider lines

Wrap text.

I think if you right click on the cell and select format, theres an option to wrap the words

so they go down
line by line
like this
in the cell
is that what
you wanted to know?

Or you can set the whole column to word wrap (think that's what its called years since I've used excel)

Wrap the text - don’t ‘merge’

Merged cells are the devil.

Select the cells you want to fix and click "wrap text" - I think it's under Formatting

Wrap it

support.microsoft.com/en-us/office/wrap-text-in-a-cell-2a18cff5-ccc1-4bce-95e4-f0d4f3ff4e84

Agree, wrap the text.
Merge cells are shit.

just another one to say DO NOT MERGE.

Definitely wrap text

this will make every column as wide as it needs to be to show all the writing in it - as pp said you may need to wrap text if thats too wide

Exactly what @meryoldgoat said - sorry OP, I was working on a spreadsheet and browsing mumsnet at the same time

Agree, wrap don't merge

yes, avoid merge, its hideous

Make the cells wider if you want it all on one line but if you have a long sentence it will make the table wide.

Wrap the text and it will be in lines in the cell.

Yes, wrap. Highlight the cells you want to deal with, select Format cells/alignment. Then select vertical alignment to top and tick the wrap text box.

WRAP NOT MERGE!

unless it’s a sheet which you’re using as a one-off for display purposes and will never ever want to use or copy again I guess.

Wow! Thank you all for the super-quick responses! Right, I'm off to try merging (just kidding!) I will try WRAPPING the text.

I'm very happy because I thought you were going to say, "Tough luck - Excel doesn't do that!"

My excel columns concealed
Words that I wanted revealed
I asked on mumsnet
They said to wrap text
And now my spreadsheet's ideal

After wrapping you may need to make the row deeper to see all the text

If you don't want the text wrapped and would prefer it in a straight line. You can select the cells you want the text to spread over. Right click. Format. Then alignment tab. Centre across selection. This looks like merge. But does not act like a merge and the cells work independently.

cava

I love a MN excel thread.

@victopai

Oh I need this one! For headers of tables. Totally playing with this tomorrow

OP did you WRAP THE TEXT?