moderated Re: Width of cell in Excel


 

Brian,



How much text will fit in a cell depends on the width of the column in which the cell resides. I don't believe Excel allows setting the width of individual cells. How text which takes more space than the width of its column appears will depend on what the cell to its immediate right has in it. If that cell is blank, the too wide text will spill over and display in the adjacent cell. If the adjacent cell is not blank, the too wide text will be cut off and not displayed even though it is still in the cell.



You can change the format of individual cells to set them to wrap text when the text they contain is too wide to fit in the width of their column. This will cause the row they are in to expand in height in order to display the wrapped text. To do this, place focus in the cell you wish to have the text wrapped or select an entire column or a group of cells for which you want to wrap text and then:



1. Press ctrl + 1 to open the format dialog box.

2. Press ctrl + tab to move to the alignment tab in the format dialog box.

3. Press tab until you reach the wrap text checkbox and press space to check it.

4. Press tab until you reach the Ok button and press enter.



Alan Lemly

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of brian albriton
Sent: Tuesday, October 06, 2020 12:38 PM
To: main@jfw.groups.io
Subject: Re: Width of cell in Excel



Actually, how much text Will fit in a cell? I m told if you put too much text in a cell it just plain doesn t look right



On Sep 22, 2020, at 5:45 PM, Zel Iscel < <mailto:zel@inclusiveworld.com.au> zel@inclusiveworld.com.au> wrote:
Cheers Anne, I ll try that next time.
Zel Iscel
Inclusive World
Principle Consultant
Mobile: +61 0413813885
Email: <mailto:zel@inclusiveworld.com.au> zel@inclusiveworld.com.au
On 23 Sep 2020, at 5:14 am, Ann Byrne < <mailto:annakb@sbcglobal.net> annakb@sbcglobal.net> wrote:
?Often if the screen is restored, not maximized, the commands don't work as advertised.
At 02:38 PM 9/22/2020, you wrote:
For automatic row height adjustment, it's alt h then o then a.
To manually adjust row height, it's alt h then o then h.
For automatic column width, it's alt h then o then i.
To manually adjust column width, it's alt h then o then w.
My Jaws versions of 2018 and 2019 don't always respond to these commands so I press alt h then tab to cells format then press enter, and I can choose between row height, column width,etc with the up and down arrows. Or sometimes I'll restart Jaws, but that doesn't always help either.
Hope that helps.
Zel
image001.jpg
Zel Iscel
Disability Specialist
Inclusive World
Mobile: 0413813885
Email: < <mailto:zel@inclusiveworld.com.au> mailto:zel@inclusiveworld.com.au> <mailto:zel@inclusiveworld.com.au> zel@inclusiveworld.com.au
From: <mailto:main@jfw.groups.io> main@jfw.groups.io < <mailto:main@jfw.groups.io> main@jfw.groups.io> On Behalf Of Richard
Turner
Sent: Wednesday, 23 September 2020 3:10 AM
To: <mailto:main@jfw.groups.io> main@jfw.groups.io
Subject: Re: Width of cell in Excel
Well, it seems to be less obvious these days.
I'll post a link to a Microsoft support page below, but one way to get there is to press alt+q, type cell width, arrow down to cell width and hit enter.
Maybe there is a more direct way.
Here is the page I got from searching the web:
<https://support.microsoft.com/en-us/office/change-the-column-width-
and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46> <https://support> https://support.
microsoft.com/en-us/office/change-the-column-width-and-row-height-72
f5e3cc-994d-43e8-ae58-9774a0905f46
Richard
"He that cannot forgive others breaks the bridge over which he must
pass himself," and we forget that only grace can break the cycle of
ancient hatreds among peoples. (It is notable that while I have
regretted not granting grace to others, I've never once regretted
extending it.)" - Edward Herbert
From: < <mailto:main@jfw.groups.io> mailto:main@jfw.groups.io> <mailto:main@jfw.groups.io> main@jfw.groups.io
<< <mailto:main@jfw.groups.io> mailto:main@jfw.groups.io> <mailto:main@jfw.groups.io> main@jfw.groups.io> On Behalf Of kevin
meyers
Sent: Tuesday, September 22, 2020 10:48 AM
To: < <mailto:main@jfw.groups.io> mailto:main@jfw.groups.io> <mailto:main@jfw.groups.io> main@jfw.groups.io
Subject: Width of cell in Excel
Hello, I'm using most recent versions of windows10 and Jaws2020. I'm also using Office 2016. I want to change the width of a cell. When I got to the spot to change the width it said it was 8.11. Is that the number of characters that can fit in the cell?
Then to change the width of a entire column, I would have to
highlight the column and then make the size of the cell wider.
Cheers, Kevin

Join main@jfw.groups.io to automatically receive all group messages.