Nov 25 2020 12:08 AM
Good morning All,
I have a spreadsheet in which some of the cells each contain quite a large amount of text. However, I want to view all of that in-cell text 'in one go' without increasing the size of the cell itself (i.e. default/small). I have seen sometimes in the past, (on other spreadsheets - not mine), that when you roll your mouse cursor over the cell, all of the text contained in it then appears in a box ('call out box'?) right next to the cell.
Please could someone tell me how to 'make' that happen?
Many thanks in advance! :)
Nov 25 2020 12:23 AM
Perhaps that was the text in notes/comments, not in the cell itself.
Nov 25 2020 12:44 AM
Different ways lead to Rome, also with Excel different ways lead to a solution.
with formating cells:
If text in a cell extends beyond the right edge of the cell, Excel will only display it if the cell on the right is empty. If there are numbers or formula results in a cell, the contents do not protrude beyond the edge of a cell that is too narrow. Instead, Excel cuts off the contents or uses a series of hashes # to indicate that the cell is too narrow.
The following figure shows what cell contents that are too long can look like in practice:
If you want to display this content entirely in the cells, one way is to change the column width. If this is not what you want, you can also reduce the font size of the cells so that the content is fully visible. You can do this automatically in the following way:
Select the cells you want to format.
Invoke the FORMAT CELLS command.
You can do this in all Excel versions using the key combination CTRL 1.
In the dialog box that appears, activate the ALIGNMENT tab.
Click the FIT TO CELL SIZE option.
Confirm your definition with the OK button.
Excel adjusts the font size of the cell contents that cannot be displayed in the cells so that they fit into the cells.
The advantage of this method of resizing in comparison to manual formatting is that the formatting is automatically adjusted if the cell contents or column widths change.
------------------------------
with VBA:
Excel auto format cell's font size based on number value?
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Nov 25 2020 12:53 AM
Nov 25 2020 01:02 AM
Sorry, I don't know what could be the reason. On my site Refresh always works.
Nov 25 2020 01:06 AM
Nov 25 2020 01:07 AM
@NikolinoDE Hi Nikolino, Many thanks for your reply, but I want to do it without changing the cell size...
Nov 25 2020 01:16 AM
That's not "hover the mouse" as you've seen before as it works with notes/comments. With your method you may also press F2 button or check the text in formula bar.