Excel auto cell size adjustment Solved

Question

Hello,
I have a question about Excel regarding the automatic adjustment of cell sizes.
I have a document with a cell that refers to another cell in a different workbook.
So there is a source workbook and a target workbook.

When the source workbook is modified and I open the target workbook, I update the data.

And here is my problem: the cells do not automatically expand, which means I can't see all the data.

Do you understand me?
So I would like to know if it's possible for a cell to automatically expand if there is too much data in it.

Thank you in advance.

meléopoldine · Accepted Answer

Look under Excel:

Select the cells to adjust, whether the cells are still empty or when they are filled,
Click on format, column, auto fit!

Note from 2019: Home tab - Cell (all the way to the right) and - format - Click on row height auto fit.

Let me know if you found it!!

meléopoldine · Answer

I know that you can adjust them manually; you must be able to do that too, I think? But automatically, I don't know, but I will go and see if I can find something!

Eidole · Answer

Anyway, it really helped me!! Thank you!!

Lou · Answer

My problem is that I want to write something in a cell, but I don't have enough space! It's for an evaluation, so it's really urgent, help me!

eriiic · Answer

Hello,  simpler: select the relevant columns (or the entire page) and double-click on the separation between 2 columns (between the letters)  eric

fillvinf06 · Answer

You can adjust cells one by one by double-clicking between two cells. For example, if I want to adjust the width of cell C, I double-click BETWEEN C and D at the top, when I see the icon that allows me to enlarge/shrink the cell, and voilà! The cell will be automatically adjusted to the amount of data you have in your cell!

Dado · Answer

Thank you, it helped me a lot too!!!

sininey · Answer

Select your line(s) then click on Format, Line, Height and enter a higher number, then confirm.

Excel auto cell size adjustment

8 answers

Subliminal image in a video

I'm looking for java or jar game sites.

How to unsubscribe from jm plan cul

Edit ad on leboncoin for free

Commun.file_upload.maxsize

Problem opening modal window from another page

Thursday modification test title number 3

How to change sources on a grundig universal remote?

Adobe reader saves a file instead of printing

Is tokyvideo a reliable site? what are your opinions?