Date   
moderated Re: Looking for JAWS 7 training materials

Vaughn Brown
 

Hi there,

Have you check the training material found in the menu for this vertion?
Thank you,
Vaughn

On 6/10/19, Joseph Norton <joseph.norton@...> wrote:
Hi:



I know that FS doesn't mind copying the actual training materials,
according
to their statements in the materials, so I hope someone would be willing to
help.

I have an older machine I'm running JFW 7.10 on and I wonder if someone
could help me obtain the specific training daisy files for that version.



No big deal, but, any help would be appreciated.



Thanks!




--
Kindly,
Vaughn Brown
Vaughn's Percussionship
Heal through Feel Equine Massage
360-904-8432
http://www.vaughnbrown.net
Serving Clark County

moderated Looking for JAWS 7 training materials

Joseph Norton
 

Hi:

 

I know that FS doesn’t mind copying the actual training materials, according to their statements in the materials, so I hope someone would be willing to help.

I have an older machine I’m running JFW 7.10 on and I wonder if someone could help me obtain the specific training daisy files for that version.

 

No big deal, but, any help would be appreciated.

 

Thanks!

moderated Re: Excel rows and columns

 

As an aside, there's an upcoming free webinar on June 20th on JAWS and Excel, as well as an archived one from last year.  See:  https://support.freedomscientific.com/Services/TrainingAndCertification/FreeWebinars

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

moderated Re: jaws quick / hot key

Van Lant, Robin
 

Sieghard, this is really helpful.  That makes a lot of sense. 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Thursday, June 6, 2019 11:23 PM
To: main@jfw.groups.io
Subject: Re: jaws quick / hot key

 

This can be a very useful option for braille users who want some speech but don’t necessarily want Jaws to speak everything and it was really designed with braille users in mind. It is not a useful option for a completely blind person who relies on speech only.

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via Groups.Io
Sent: Thursday, June 6, 2019 3:06 PM
To: main@jfw.groups.io
Subject: Re: jaws quick / hot key

 

Thanks, Bill.  I’ll have to explore this.  Not sure how I’d use that yet, but it’s always good to know what JAWS is capable of doing.

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bill White
Sent: Thursday, June 6, 2019 12:44 PM
To: main@jfw.groups.io
Subject: Re: jaws quick / hot key

 

Hi, Robin. When JAWS is set to mute speech, speech is always muted. When JAWS is set to use Speech on demand, speech is usually muted, but JAWS will still speek when using commands such as,

 

Say Character

Say Prior Word

Say Next Word

Say Word

Spell Word

Say Prior Line

Say Current Line

Spell Current Line

Say All

 

etc. So, you have speech muted, but when using navigational commands except for arrow keys, JAWS will speak normally.

 

Bill White

billwhite92701@...

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Van Lant, Robin via Groups.Io
Sent: Thursday, June 6, 2019 10:39 AM
To: main@jfw.groups.io
Subject: Re: jaws quick / hot key

 

Sieghard, Are you able to articulate to me what Speech on Demand really does?  Even without following the steps you and Bill each outlined,  I was finding that the JAWS spacebar then S would mute my speech.  JAWS says Speech on Demand, but when this is active, I havent’ noticed JAWS speaking so it’s effectively been a mute function for me.  I’m not clear how someone would use Speech on Demand and am guessing that you have to customize how JAWS will or won’t speak in this mode, but can’t imagine how it’s used.

 

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Thursday, June 6, 2019 10:04 AM
To: main@jfw.groups.io
Subject: Re: jaws quick / hot key

 

Hi Bill,

 

Just for your information, you can accomplish what  you described also in the following way:

 

1. Press Jaws Key + Spacebar followed by S – this will turn on speech on demand

2. Now press Jaws Key + Spacebar followed by Shift + S – Jaws will say “Speech off set to speech mute”

3. Press Jaws Key + Spacebar followed by S again – Jaws will now say full speech and from now on when you press this layered shortcut it will toggle between mute and full speech.

If you want to go back to speech on demand simply repeat the above steps, first toggle speech to mute, then press the layered keystroke but with Shift + S and Jaws will say “Speech off set to speech on demand”, now the toggle is back between full speech and speech on demand.

 

Regards,

Sieghard

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bill White
Sent: Thursday, June 6, 2019 8:53 AM
To: main@jfw.groups.io
Subject: Re: jaws quick / hot key

 

Hi, Rick. In case all you want to do is to mute speech instead of unloading JAWS entirely, try the following,

 

1. Open Settings Center with INSERT plus six on numbers row.

2. Press CONTROL plus SHIFT plus D to load Default JAWS configuration.

3. In the search field, type

 

speech.

 

4. Arrow down to Less Speech Options.

5. Press SPACE BAR to toggle speech from Speech On Demand to Mute Speech.

6. TAB to OK, and press ENTER to save settings.

 

7. Now, INSERT plus SPACE, followed by S will mute speech instead of setting it to Speech On Demand.

 

Bill White

billwhite92701@...

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Rick Mladek
Sent: Thursday, June 6, 2019 8:10 AM
To:
main@jfw.groups.io
Subject: jaws quick / hot key

 

Hi all,

 

Sorry for my constant inquiries but is there a short cut for turning jaws on and off? Something more quick than alt tabbing to jaws and hitting alt F4?

 

Thanks

 

Rick



This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information.

127 Public Square, Cleveland, OH 44114


If you prefer not to receive future e-mail offers for products or services from Key
send an e-mail to mailto:DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.

moderated Re: CC to jfw@groups.io

 

On Mon, Jun 10, 2019 at 05:06 AM, MohammadAfzal wrote:
When, you reply or answer of any query then Please CC to jfw@groups.io
Why on earth would someone do that?  Replying to a Groups.io message, on any group, automatically sends it to the group as a whole (unless the owner has changed the defaults, which is not the case here).  This message was not CC ed to the group, but it will go out to it.

You need only use the group posting address if you are starting a new topic, otherwise, just hitting reply without touching either the Subject or address fields works just fine to get a message to the group.
 
--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

moderated CC to jfw@groups.io

MohammadAfzal
 

Hi All,

Happy Eid to all.

I am good and wish you all are pity well.

It's my humble request. When, you reply or answer of any query then Please CC to jfw@groups.io


with warm regards.


--
Mohammad Afzal Khan.
Mobile :91 - 9718806099
Skype : counsellor.afzal
Impossible is the means of I M Possible

moderated Re: Excel rows and columns

Ann Byrne
 

The JAWS training materials has a couple of tutorials on Excel, one illustrating the speaking of row and column titles using the bookmark feature of the Excel application.

At 07:44 PM 6/9/2019, you wrote:
I have been working on this and my original instructions, with some slight modifications, do work (or do for me with JAWS 2019 and Excel 2016).  That being said, there are multiple ways to accomplish what's being sought and I really have no idea how most who can't actually see a spreadsheet deal with across row or down column selection.One can select a range of cells, then define it as a Title Row (which is the titles of the respective columns that row is above), and the same for a Title Column, and define it that way. Or one can simply select the first cell of the title row/column, and use a special Excel Keyword for the name followed by dot dot (with no spaces) and the designation of the cell that ends the series (which will be a cell to the right if it's a Title Row or a cell below if it's a Title Column).There also exists the option of using an Excel table in the spreadsheet, too, and that can be very convenient for dealing with needs for insertion of additional rows and things like Total rows, which can just slide on down (or up, if rows are deleted) and the formulae handle this seamlessly.How do you, here, set this sort of thing up, and how do you go about multi-selection of ranges in a single row or column. Knowing about common selection methods used for blocks of cells would be interesting, too.I've never had a client where I was working with them doing heavy duty work with Excel spreadsheet creation or modification. Most of the work was about accessing existing spreadsheets, which is an entirely different kettle of fish. That's how the stuff related to designating titles came about, because it becomes rather hellish to know where you are in a complex Excel table if you are distracted, or need to shift focus to something else, and come back in without knowing the row/column you're working with and what it represents.--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Â

Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t.

    ~ Lauren Bacall

moderated Re: Excel rows and columns

 

I have been working on this and my original instructions, with some slight modifications, do work (or do for me with JAWS 2019 and Excel 2016).   That being said, there are multiple ways to accomplish what's being sought and I really have no idea how most who can't actually see a spreadsheet deal with across row or down column selection.

One can select a range of cells, then define it as a Title Row (which is the titles of the respective columns that row is above), and the same for a Title Column, and define it that way.  Or one can simply select the first cell of the title row/column, and use a special Excel Keyword for the name followed by dot dot (with no spaces) and the designation of the cell that ends the series (which will be a cell to the right if it's a Title Row or a cell below if it's a Title Column).

There also exists the option of using an Excel table in the spreadsheet, too, and that can be very convenient for dealing with needs for insertion of additional rows and things like Total rows, which can just slide on down (or up, if rows are deleted) and the formulae handle this seamlessly.

How do you, here, set this sort of thing up, and how do you go about multi-selection of ranges in a single row or column.  Knowing about common selection methods used for blocks of cells would be interesting, too.

I've never had a client where I was working with them doing heavy duty work with Excel spreadsheet creation or modification.  Most of the work was about accessing existing spreadsheets, which is an entirely different kettle of fish.  That's how the stuff related to designating titles came about, because it becomes rather hellish to know where you are in a complex Excel table if you are distracted, or need to shift focus to something else, and come back in without knowing the row/column you're working with and what it represents.

--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763  

Here is a test to find out whether your mission in life is complete.  If you’re alive, it isn’t.

       ~ Lauren Bacall

moderated Re: Inserting Rows in an existing Excel Sheet

Ann Byrne
 

f2.

At 04:25 PM 6/9/2019, you wrote:
Thanks. And, Editing Formulas?

On 6/9/19, Ann Byrne <annakb@...> wrote:
Realize, though, that you can still use the Office 2003 commands. To
insert a row, I use alt-i, then r, enter. To insert a column, alt-i,
then c, enter. The applications key is your friend--so pressing it
and arrowing down will give you the insert dialog of course. But I'm
lazy and still type in the commands.
At 03:03 PM 6/9/2019, you wrote:
Alrightie Now! That's not very intuitive as it was before..:)

Thank you...much appreciated!!!

On 6/9/19, Sieghard Weitzel <@Sieghard> wrote:
As I said, you can bring up the application menu (Shift + F10), arrow
to
"Insert..." and then select insert entire column or insert entire row.


-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dave...
Sent: Sunday, June 9, 2019 9:08 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Can you also press the application key (shift+f10) and bring up the
context
menu to insert a row or column?

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Sieghard Weitzel" <@Sieghard>
To: <main@jfw.groups.io>
Sent: Sunday, June 09, 2019 09:05
Subject: Re: Inserting Rows in an existing Excel Sheet


There are quite a few ways to skin a cat so to speak in most Microsoft
programs.
What Russell describes also works just fine, if you don't highlight the
column or row and use the application menu and select "Insert..." you
get
the same dialogue as you get with control + NumPad Plus which is you get
a
little menu and you can select to Insert an entire column or entire
row.
Control + Shift + = also gets you that same menu
You can also use the ribbon shortcut Alt + H followed by I and C for
column

or R for row.
Just Alt + H followed by I gets you to the insert menu where you can
also
insert a sheet (S).
Alt + H followed by D gets you to the equivalent delete menu.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell
Solowoniuk
Sent: Sunday, June 9, 2019 8:51 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Hi George,

If you wish to insert a new column, place your cursor in the column to
the
right of where you wish to insert the new column. Select the column you
are

in by pressing CTRL + spacebar. Jaws will say "Selected entire column".
Now

press the applications key and arrow down to "Insert" and press
enter. A new

blank column will be inserted to the left of the column you were in.

If you wish to insert a new blank row, place the cursor in the row
below
where you wish the new row to be inserted. Select the entire row
by pressing

Shift + spacebar. Jaws will say "Selected entire row". Now press the
applications key and arrow down to "Insert" and press enter. A
new blank row

will be inserted above the row you were in.

If you wish to edit a formula, or see what the formula is, move to the
cell

with the formula and press F2. This will place you in edit mode and you
can

read the formula and make any changes you want.

Hope this helps.

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 9:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my
DeskTop
and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing
horizontal
Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program,
but
cannot figure it out with the Ribbons. I know how to navigate the
Ribbons
to some degree, but can't identify the Insert New Column and Edit
Formulas
items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA



















--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA





--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA

moderated Re: Inserting Rows in an existing Excel Sheet

George Gray
 

Thanks. And, Editing Formulas?

On 6/9/19, Ann Byrne <annakb@...> wrote:
Realize, though, that you can still use the Office 2003 commands. To
insert a row, I use alt-i, then r, enter. To insert a column, alt-i,
then c, enter. The applications key is your friend--so pressing it
and arrowing down will give you the insert dialog of course. But I'm
lazy and still type in the commands.
At 03:03 PM 6/9/2019, you wrote:
Alrightie Now! That's not very intuitive as it was before..:)

Thank you...much appreciated!!!

On 6/9/19, Sieghard Weitzel <@Sieghard> wrote:
As I said, you can bring up the application menu (Shift + F10), arrow
to
"Insert..." and then select insert entire column or insert entire row.


-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dave...
Sent: Sunday, June 9, 2019 9:08 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Can you also press the application key (shift+f10) and bring up the
context
menu to insert a row or column?

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Sieghard Weitzel" <@Sieghard>
To: <main@jfw.groups.io>
Sent: Sunday, June 09, 2019 09:05
Subject: Re: Inserting Rows in an existing Excel Sheet


There are quite a few ways to skin a cat so to speak in most Microsoft
programs.
What Russell describes also works just fine, if you don't highlight the
column or row and use the application menu and select "Insert..." you
get
the same dialogue as you get with control + NumPad Plus which is you get
a
little menu and you can select to Insert an entire column or entire
row.
Control + Shift + = also gets you that same menu
You can also use the ribbon shortcut Alt + H followed by I and C for
column

or R for row.
Just Alt + H followed by I gets you to the insert menu where you can
also
insert a sheet (S).
Alt + H followed by D gets you to the equivalent delete menu.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell
Solowoniuk
Sent: Sunday, June 9, 2019 8:51 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Hi George,

If you wish to insert a new column, place your cursor in the column to
the
right of where you wish to insert the new column. Select the column you
are

in by pressing CTRL + spacebar. Jaws will say "Selected entire column".
Now

press the applications key and arrow down to "Insert" and press
enter. A new

blank column will be inserted to the left of the column you were in.

If you wish to insert a new blank row, place the cursor in the row
below
where you wish the new row to be inserted. Select the entire row
by pressing

Shift + spacebar. Jaws will say "Selected entire row". Now press the
applications key and arrow down to "Insert" and press enter. A
new blank row

will be inserted above the row you were in.

If you wish to edit a formula, or see what the formula is, move to the
cell

with the formula and press F2. This will place you in edit mode and you
can

read the formula and make any changes you want.

Hope this helps.

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 9:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my
DeskTop
and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing
horizontal
Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program,
but
cannot figure it out with the Ribbons. I know how to navigate the
Ribbons
to some degree, but can't identify the Insert New Column and Edit
Formulas
items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA



















--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA




--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA

moderated Re: Inserting Rows in an existing Excel Sheet

Ann Byrne
 

Realize, though, that you can still use the Office 2003 commands. To insert a row, I use alt-i, then r, enter. To insert a column, alt-i, then c, enter. The applications key is your friend--so pressing it and arrowing down will give you the insert dialog of course. But I'm lazy and still type in the commands.

At 03:03 PM 6/9/2019, you wrote:
Alrightie Now! That's not very intuitive as it was before..:)

Thank you...much appreciated!!!

On 6/9/19, Sieghard Weitzel <@Sieghard> wrote:
As I said, you can bring up the application menu (Shift + F10), arrow to
"Insert..." and then select insert entire column or insert entire row.


-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dave...
Sent: Sunday, June 9, 2019 9:08 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Can you also press the application key (shift+f10) and bring up the context
menu to insert a row or column?

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Sieghard Weitzel" <@Sieghard>
To: <main@jfw.groups.io>
Sent: Sunday, June 09, 2019 09:05
Subject: Re: Inserting Rows in an existing Excel Sheet


There are quite a few ways to skin a cat so to speak in most Microsoft
programs.
What Russell describes also works just fine, if you don't highlight the
column or row and use the application menu and select "Insert..." you get
the same dialogue as you get with control + NumPad Plus which is you get a
little menu and you can select to Insert an entire column or entire row.
Control + Shift + = also gets you that same menu
You can also use the ribbon shortcut Alt + H followed by I and C for column

or R for row.
Just Alt + H followed by I gets you to the insert menu where you can also
insert a sheet (S).
Alt + H followed by D gets you to the equivalent delete menu.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell
Solowoniuk
Sent: Sunday, June 9, 2019 8:51 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Hi George,

If you wish to insert a new column, place your cursor in the column to the
right of where you wish to insert the new column. Select the column you are

in by pressing CTRL + spacebar. Jaws will say "Selected entire column". Now

press the applications key and arrow down to "Insert" and press
enter. A new

blank column will be inserted to the left of the column you were in.

If you wish to insert a new blank row, place the cursor in the row below
where you wish the new row to be inserted. Select the entire row
by pressing

Shift + spacebar. Jaws will say "Selected entire row". Now press the
applications key and arrow down to "Insert" and press enter. A
new blank row

will be inserted above the row you were in.

If you wish to edit a formula, or see what the formula is, move to the cell

with the formula and press F2. This will place you in edit mode and you can

read the formula and make any changes you want.

Hope this helps.

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 9:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my DeskTop
and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing horizontal
Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program, but
cannot figure it out with the Ribbons. I know how to navigate the Ribbons
to some degree, but can't identify the Insert New Column and Edit Formulas
items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA



















--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA

moderated Re: Inserting Rows in an existing Excel Sheet

George Gray
 

Alrightie Now! That's not very intuitive as it was before..:)

Thank you...much appreciated!!!

On 6/9/19, Sieghard Weitzel <@Sieghard> wrote:
As I said, you can bring up the application menu (Shift + F10), arrow to
"Insert..." and then select insert entire column or insert entire row.


-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dave...
Sent: Sunday, June 9, 2019 9:08 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Can you also press the application key (shift+f10) and bring up the context
menu to insert a row or column?

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Sieghard Weitzel" <@Sieghard>
To: <main@jfw.groups.io>
Sent: Sunday, June 09, 2019 09:05
Subject: Re: Inserting Rows in an existing Excel Sheet


There are quite a few ways to skin a cat so to speak in most Microsoft
programs.
What Russell describes also works just fine, if you don't highlight the
column or row and use the application menu and select "Insert..." you get
the same dialogue as you get with control + NumPad Plus which is you get a
little menu and you can select to Insert an entire column or entire row.
Control + Shift + = also gets you that same menu
You can also use the ribbon shortcut Alt + H followed by I and C for column

or R for row.
Just Alt + H followed by I gets you to the insert menu where you can also
insert a sheet (S).
Alt + H followed by D gets you to the equivalent delete menu.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell
Solowoniuk
Sent: Sunday, June 9, 2019 8:51 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Hi George,

If you wish to insert a new column, place your cursor in the column to the
right of where you wish to insert the new column. Select the column you are

in by pressing CTRL + spacebar. Jaws will say "Selected entire column". Now

press the applications key and arrow down to "Insert" and press enter. A new

blank column will be inserted to the left of the column you were in.

If you wish to insert a new blank row, place the cursor in the row below
where you wish the new row to be inserted. Select the entire row by pressing

Shift + spacebar. Jaws will say "Selected entire row". Now press the
applications key and arrow down to "Insert" and press enter. A new blank row

will be inserted above the row you were in.

If you wish to edit a formula, or see what the formula is, move to the cell

with the formula and press F2. This will place you in edit mode and you can

read the formula and make any changes you want.

Hope this helps.

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 9:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my DeskTop
and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing horizontal
Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program, but
cannot figure it out with the Ribbons. I know how to navigate the Ribbons
to some degree, but can't identify the Insert New Column and Edit Formulas
items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA


















--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA

moderated Re: Inserting Rows in an existing Excel Sheet

 

As I said, you can bring up the application menu (Shift + F10), arrow to "Insert..." and then select insert entire column or insert entire row.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dave...
Sent: Sunday, June 9, 2019 9:08 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Can you also press the application key (shift+f10) and bring up the context menu to insert a row or column?

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Sieghard Weitzel" <@Sieghard>
To: <main@jfw.groups.io>
Sent: Sunday, June 09, 2019 09:05
Subject: Re: Inserting Rows in an existing Excel Sheet


There are quite a few ways to skin a cat so to speak in most Microsoft
programs.
What Russell describes also works just fine, if you don't highlight the
column or row and use the application menu and select "Insert..." you get
the same dialogue as you get with control + NumPad Plus which is you get a
little menu and you can select to Insert an entire column or entire row.
Control + Shift + = also gets you that same menu
You can also use the ribbon shortcut Alt + H followed by I and C for column
or R for row.
Just Alt + H followed by I gets you to the insert menu where you can also
insert a sheet (S).
Alt + H followed by D gets you to the equivalent delete menu.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell
Solowoniuk
Sent: Sunday, June 9, 2019 8:51 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Hi George,

If you wish to insert a new column, place your cursor in the column to the
right of where you wish to insert the new column. Select the column you are
in by pressing CTRL + spacebar. Jaws will say "Selected entire column". Now
press the applications key and arrow down to "Insert" and press enter. A new
blank column will be inserted to the left of the column you were in.

If you wish to insert a new blank row, place the cursor in the row below
where you wish the new row to be inserted. Select the entire row by pressing
Shift + spacebar. Jaws will say "Selected entire row". Now press the
applications key and arrow down to "Insert" and press enter. A new blank row
will be inserted above the row you were in.

If you wish to edit a formula, or see what the formula is, move to the cell
with the formula and press F2. This will place you in edit mode and you can
read the formula and make any changes you want.

Hope this helps.

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 9:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my DeskTop
and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing horizontal
Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program, but
cannot figure it out with the Ribbons. I know how to navigate the Ribbons
to some degree, but can't identify the Insert New Column and Edit Formulas
items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA

moderated Re: Inserting Rows in an existing Excel Sheet

george b
 

yes

if you do this arrow down and you will see in the list insert and down again
and you will see deleate

hit enter on which you wish to do and a dialog box comes up with the choices
of cells rows collums choose which it is a radio button and hit enter

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dave...
Sent: June 9, 2019 9:08
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Can you also press the application key (shift+f10) and bring up the context
menu to insert a row or column?

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Sieghard Weitzel" <@Sieghard>
To: <main@jfw.groups.io>
Sent: Sunday, June 09, 2019 09:05
Subject: Re: Inserting Rows in an existing Excel Sheet


There are quite a few ways to skin a cat so to speak in most Microsoft
programs.
What Russell describes also works just fine, if you don't highlight the
column or row and use the application menu and select "Insert..." you get
the same dialogue as you get with control + NumPad Plus which is you get a
little menu and you can select to Insert an entire column or entire row.
Control + Shift + = also gets you that same menu
You can also use the ribbon shortcut Alt + H followed by I and C for column
or R for row.
Just Alt + H followed by I gets you to the insert menu where you can also
insert a sheet (S).
Alt + H followed by D gets you to the equivalent delete menu.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell
Solowoniuk
Sent: Sunday, June 9, 2019 8:51 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Hi George,

If you wish to insert a new column, place your cursor in the column to the
right of where you wish to insert the new column. Select the column you are
in by pressing CTRL + spacebar. Jaws will say "Selected entire column". Now
press the applications key and arrow down to "Insert" and press enter. A new

blank column will be inserted to the left of the column you were in.

If you wish to insert a new blank row, place the cursor in the row below
where you wish the new row to be inserted. Select the entire row by pressing

Shift + spacebar. Jaws will say "Selected entire row". Now press the
applications key and arrow down to "Insert" and press enter. A new blank row

will be inserted above the row you were in.

If you wish to edit a formula, or see what the formula is, move to the cell
with the formula and press F2. This will place you in edit mode and you can
read the formula and make any changes you want.

Hope this helps.

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 9:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my DeskTop
and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing horizontal
Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program, but
cannot figure it out with the Ribbons. I know how to navigate the Ribbons
to some degree, but can't identify the Insert New Column and Edit Formulas
items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA

moderated Re: Inserting Rows in an existing Excel Sheet

Dave...
 

Can you also press the application key (shift+f10) and bring up the context
menu to insert a row or column?

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer

----- Original Message -----
From: "Sieghard Weitzel" <@Sieghard>
To: <main@jfw.groups.io>
Sent: Sunday, June 09, 2019 09:05
Subject: Re: Inserting Rows in an existing Excel Sheet


There are quite a few ways to skin a cat so to speak in most Microsoft
programs.
What Russell describes also works just fine, if you don't highlight the
column or row and use the application menu and select "Insert..." you get
the same dialogue as you get with control + NumPad Plus which is you get a
little menu and you can select to Insert an entire column or entire row.
Control + Shift + = also gets you that same menu
You can also use the ribbon shortcut Alt + H followed by I and C for column
or R for row.
Just Alt + H followed by I gets you to the insert menu where you can also
insert a sheet (S).
Alt + H followed by D gets you to the equivalent delete menu.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell
Solowoniuk
Sent: Sunday, June 9, 2019 8:51 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Hi George,

If you wish to insert a new column, place your cursor in the column to the
right of where you wish to insert the new column. Select the column you are
in by pressing CTRL + spacebar. Jaws will say "Selected entire column". Now
press the applications key and arrow down to "Insert" and press enter. A new
blank column will be inserted to the left of the column you were in.

If you wish to insert a new blank row, place the cursor in the row below
where you wish the new row to be inserted. Select the entire row by pressing
Shift + spacebar. Jaws will say "Selected entire row". Now press the
applications key and arrow down to "Insert" and press enter. A new blank row
will be inserted above the row you were in.

If you wish to edit a formula, or see what the formula is, move to the cell
with the formula and press F2. This will place you in edit mode and you can
read the formula and make any changes you want.

Hope this helps.

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 9:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my DeskTop
and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing horizontal
Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program, but
cannot figure it out with the Ribbons. I know how to navigate the Ribbons
to some degree, but can't identify the Insert New Column and Edit Formulas
items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA

moderated Re: Inserting Rows in an existing Excel Sheet

 

There are quite a few ways to skin a cat so to speak in most Microsoft programs.
What Russell describes also works just fine, if you don't highlight the column or row and use the application menu and select "Insert..." you get the same dialogue as you get with control + NumPad Plus which is you get a little menu and you can select to Insert an entire column or entire row. Control + Shift + = also gets you that same menu
You can also use the ribbon shortcut Alt + H followed by I and C for column or R for row.
Just Alt + H followed by I gets you to the insert menu where you can also insert a sheet (S).
Alt + H followed by D gets you to the equivalent delete menu.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk
Sent: Sunday, June 9, 2019 8:51 AM
To: main@jfw.groups.io
Subject: Re: Inserting Rows in an existing Excel Sheet

Hi George,

If you wish to insert a new column, place your cursor in the column to the right of where you wish to insert the new column. Select the column you are in by pressing CTRL + spacebar. Jaws will say "Selected entire column". Now press the applications key and arrow down to "Insert" and press enter. A new blank column will be inserted to the left of the column you were in.

If you wish to insert a new blank row, place the cursor in the row below where you wish the new row to be inserted. Select the entire row by pressing Shift + spacebar. Jaws will say "Selected entire row". Now press the applications key and arrow down to "Insert" and press enter. A new blank row will be inserted above the row you were in.

If you wish to edit a formula, or see what the formula is, move to the cell with the formula and press F2. This will place you in edit mode and you can read the formula and make any changes you want.

Hope this helps.

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 9:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my DeskTop and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing horizontal Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program, but cannot figure it out with the Ribbons. I know how to navigate the Ribbons to some degree, but can't identify the Insert New Column and Edit Formulas items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA

moderated Re: Inserting Rows in an existing Excel Sheet

Russell Solowoniuk
 

Hi George,

If you wish to insert a new column, place your cursor in the column to the right of where you wish to insert the new column. Select the column you are in by pressing CTRL + spacebar. Jaws will say "Selected entire column". Now press the applications key and arrow down to "Insert" and press enter. A new blank column will be inserted to the left of the column you were in.

If you wish to insert a new blank row, place the cursor in the row below where you wish the new row to be inserted. Select the entire row by pressing Shift + spacebar. Jaws will say "Selected entire row". Now press the applications key and arrow down to "Insert" and press enter. A new blank row will be inserted above the row you were in.

If you wish to edit a formula, or see what the formula is, move to the cell with the formula and press F2. This will place you in edit mode and you can read the formula and make any changes you want.

Hope this helps.

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 9:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my
DeskTop and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing horizontal Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program,
but cannot figure it out with the Ribbons. I know how to navigate the
Ribbons to some degree, but can't identify the Insert New Column and
Edit Formulas items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA

moderated Re: Excel rows and columns

 

No, I deleted them all.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk
Sent: Sunday, June 9, 2019 8:40 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

Hi Sieghard,

Yes, if you go to Save As and save the workbook with a new name, the defined cell names are saved to the new workbook.

I wonder if you go to "Name Manager", under the Formula tab, press CTRL+ right arrow and you should land on "Name Manager", and from there delete any names you have defined, and then define all your cell names again? I wonder if there are names defined already that might be causing things not to work as they ought to?

Cheers,

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Sunday, June 9, 2019 9:15 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

I assume if I could get it to work for the template I made and then as you said use F12 to save the Excel file with a different name that the name definitions should also be saved in the new file.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Sunday, June 9, 2019 8:13 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

If you use save-as for the new sheets, it works.
At 09:37 AM 6/9/2019, you wrote:
Hi Sieghard,

I’m not able to set this up by defining a name on a worksheet and
then copying that sheet multiple times. Even if I set the scope to the
worksheet rather than the workbook, Jaws doesn’t read column or row
headings on the next sheets.

What you want can be done easily manually by first creating copies of
your first sheet 31 times, one sheet for each day of the month.
Then, place your cursor in the cell of the first sheet where you want
to define the name, press the applications key, up arrow to “Define
name…â€&#65533; and press enter. Type “Titleâ€&#65533;&#65533; if you
wish both column and row headings to be read by Jaws and press enter.
Now, move to sheet two and do the same, except this time type
“Title2â€&#65533; as the name. Continue doing this on subsequent
sheets, each time increasing the number after “Titleâ€&#65533;. Note
that there is no space between “Titleâ€&#65533; and the number.

Not sure if this helps or if you wanted a more automatic method, but I
can’t seem to do it any other way. I even tried grouping the sheets
and then defining a name, but this doesn’t work.

Cheers,

Russell

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard
Weitzel
Sent: Friday, June 7, 2019 12:08 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

Hi Brian,

I attached a little sample spreadsheet I made. I thought I followed
your steps to set it up so Jaws will read the column and row titles,
but I can’t get it to work, what am I doing wrong?

Sieghard

From:
<mailto:main@jfw.groups.io>main@jfw.groups.io
<<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of Brian
Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: Excel rows and columns

Pardon my error, that last technique is the "when I only want it during
this session" method
with JAWS. This is how to set them in the
spreadsheet itself such that JAWS will recognize their existence and
announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles)
in Excel

You can assign column and row titles in Excel.
These are nice because they always work with Excel and are saved to the
workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:
* Focus on the first cell in the row or column or at the first
cell where the title row and title column intersect
* Open the Name dialog:


i. Open the Formula ribbon (ALT-M)


ii. Activate the “Define Nameâ€&#65533; command (M)


iii. Within the drop-down list, activate “Define Nameâ€&#65533;


iv. The “New Nameâ€&#65533; dialog opens



Focus is placed in the name field. Within the name field, you can name
the focused cell or selected range of cells. In this case, we’re
naming the column or row title:
* Name the cell using the following rules

i. Start the range name with the label
that tells Excel you’re creating a title range
* Title – This tells Excel the column and row that intersect at
the active cell are a title row and column
* ColumnTitle – This tells Excel the focused column contains the
titles for the rows within the range
* RowTitle – this tells Excel the focused row contains titles for
thee columns in the range

ii. Add a name for the range
* Title_WidgetSales
* ColumnTitle_WidgetSales
* RowTitle_WidgetSales

iii.
Optional - Add the last cell in the range preceded by two periods
* Use this when you have multiple regions in a worksheet
* Title_WidgetSales..J25
* ColumTitle_WidgetSales..h32
* RowTitle_WidgetSales..r12
* Remember the cell address referenced is the last cell in the
range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a
combo box. Use UP and DOWN ARROW to choose from between:
* Workbook - the title Is unique and can’t be used elsewhere in
a workbook
* A Specific Worksheet - the name can be used elsewhere in a
workbook

You can add a comment for the named cell or region, this is strictly
for your personal reference and doesn’t affect the echo of the column
or row title name

The last field references the cell name or range of selected cells
you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on
any computer.

If you have titles set to echo in JAWS, the titles will echo and you
won’t lose the settings.
--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763

Here is a test to find out whether your mission in life is complete.
If you’re alive, it isn’t.

~ Lauren Bacall

moderated Re: Excel rows and columns

Russell Solowoniuk
 

Hi Sieghard,

Yes, if you go to Save As and save the workbook with a new name, the defined cell names are saved to the new workbook.

I wonder if you go to "Name Manager", under the Formula tab, press CTRL+ right arrow and you should land on "Name Manager", and from there delete any names you have defined, and then define all your cell names again? I wonder if there are names defined already that might be causing things not to work as they ought to?

Cheers,

Russell

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Sunday, June 9, 2019 9:15 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

I assume if I could get it to work for the template I made and then as you said use F12 to save the Excel file with a different name that the name definitions should also be saved in the new file.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Sunday, June 9, 2019 8:13 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

If you use save-as for the new sheets, it works.
At 09:37 AM 6/9/2019, you wrote:
Hi Sieghard,

I’m not able to set this up by defining a name on a worksheet and
then copying that sheet multiple times. Even if I set the scope to the
worksheet rather than the workbook, Jaws doesn’t read column or row
headings on the next sheets.

What you want can be done easily manually by first creating copies of
your first sheet 31 times, one sheet for each day of the month.
Then, place your cursor in the cell of the first sheet where you want
to define the name, press the applications key, up arrow to “Define
name…â€&#65533; and press enter. Type “Titleâ€&#65533;&#65533; if you
wish both column and row headings to be read by Jaws and press enter.
Now, move to sheet two and do the same, except this time type
“Title2â€&#65533; as the name. Continue doing this on subsequent
sheets, each time increasing the number after “Titleâ€&#65533;. Note
that there is no space between “Titleâ€&#65533; and the number.

Not sure if this helps or if you wanted a more automatic method, but I
can’t seem to do it any other way. I even tried grouping the sheets
and then defining a name, but this doesn’t work.

Cheers,

Russell

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard
Weitzel
Sent: Friday, June 7, 2019 12:08 AM
To: main@jfw.groups.io
Subject: Re: Excel rows and columns

Hi Brian,

I attached a little sample spreadsheet I made. I thought I followed
your steps to set it up so Jaws will read the column and row titles,
but I can’t get it to work, what am I doing wrong?

Sieghard

From:
<mailto:main@jfw.groups.io>main@jfw.groups.io
<<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of Brian
Vogel
Sent: Thursday, June 6, 2019 8:42 PM
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: Excel rows and columns

Pardon my error, that last technique is the "when I only want it during
this session" method
with JAWS. This is how to set them in the
spreadsheet itself such that JAWS will recognize their existence and
announce them whenever you open a specific spreadsheet:

Assigning a Title Row (Column Titles) and/or Title Column (Row Titles)
in Excel

You can assign column and row titles in Excel.
These are nice because they always work with Excel and are saved to the
workbook. There's no risk of losing a setting in your screen reader.

To add column and row title names:
* Focus on the first cell in the row or column or at the first
cell where the title row and title column intersect
* Open the Name dialog:


i. Open the Formula ribbon (ALT-M)


ii. Activate the “Define Nameâ€&#65533; command (M)


iii. Within the drop-down list, activate “Define Nameâ€&#65533;


iv. The “New Nameâ€&#65533; dialog opens



Focus is placed in the name field. Within the name field, you can name
the focused cell or selected range of cells. In this case, we’re
naming the column or row title:
* Name the cell using the following rules

i. Start the range name with the label
that tells Excel you’re creating a title range
* Title – This tells Excel the column and row that intersect at
the active cell are a title row and column
* ColumnTitle – This tells Excel the focused column contains the
titles for the rows within the range
* RowTitle – this tells Excel the focused row contains titles for
thee columns in the range

ii. Add a name for the range
* Title_WidgetSales
* ColumnTitle_WidgetSales
* RowTitle_WidgetSales

iii.
Optional - Add the last cell in the range preceded by two periods
* Use this when you have multiple regions in a worksheet
* Title_WidgetSales..J25
* ColumTitle_WidgetSales..h32
* RowTitle_WidgetSales..r12
* Remember the cell address referenced is the last cell in the
range for which you are creating titles

The next field in the dialog sets the scope for the name. this is a
combo box. Use UP and DOWN ARROW to choose from between:
* Workbook - the title Is unique and can’t be used elsewhere in
a workbook
* A Specific Worksheet - the name can be used elsewhere in a
workbook

You can add a comment for the named cell or region, this is strictly
for your personal reference and doesn’t affect the echo of the column
or row title name

The last field references the cell name or range of selected cells
you’re naming. You can leave this field alone.

Activate the OK button to save the name and close the dialog.

Save the workbook and the titles are permanently saved and will work on
any computer.

If you have titles set to echo in JAWS, the titles will echo and you
won’t lose the settings.
--

Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763

Here is a test to find out whether your mission in life is complete.
If you’re alive, it isn’t.

~ Lauren Bacall

moderated Re: Inserting Rows in an existing Excel Sheet

 

I find the easiest shortcut for inserting new rows and columns is Control + NumPad Plus, it will ask you if you want to insert a new row or a new column, Insert + NumPad Minus allows you to delete a column or row.
As for copying, all you have to do is press Control + C on a cell containing a formula.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray
Sent: Sunday, June 9, 2019 8:22 AM
To: main@jfw.groups.io
Subject: Inserting Rows in an existing Excel Sheet

Hola!

I am using the latest versions of Win10 and Office (not 365) on my DeskTop and I have a couple of questions, if I may:

1. How can I Insert a new vertical Column between the existing horizontal Rows,

2. How can I Copy and then Edit the existing Formulas?

I knew how to accomplish these actions within the old Excel program, but cannot figure it out with the Ribbons. I know how to navigate the Ribbons to some degree, but can't identify the Insert New Column and Edit Formulas items.

Thanks in advance.

--
HAVE A MAGNIFICENT DAY

GEORGE BURRELL GRAY

Ocean Winds
Cabarete/Sosua
REPUBLICA DOMINICANA