moderated Re: Width of cell in Excel


Mario
 

in addition, alt h o i will automatically adjust the width of a column of cells to the longest width according to the number of characters.

On 10/6/2020 2:04 PM, Ann Byrne wrote:
The default width for a cell is 8.11 characters.  if there is more text, it spills over to the right into the next cell(s).  There is a JAWS setting, cell text visibility I think, that when checked will alert when the text goes into additional space.  Alt+h, o, w will tell you how wide a cell is, and allow you to change the width.
At 12:37 PM 10/6/2020, you wrote:
Actually, how much text Will fit in a cell? Iâ?Tm told if you put too much text in a cell it just plain doesnâ?Tt look right

On Sep 22, 2020, at 5:45 PM, Zel Iscel <zel@...>
wrote:

Cheers Anne, Iâ?Tll try that next time.

Zel Iscel
Inclusive World
Principle Consultant

Mobile: +61 0413813885
Email: zel@...

On 23 Sep 2020, at 5:14 am, Ann Byrne <annakb@...> 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@...>zel@...



From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard
Turner
Sent: Wednesday, 23 September 2020 3:10 AM
To: 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.microsoft.com/en-us/office/change-the-column-width-and-row-height-72f5e3cc-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>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>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.