|
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.
toggle quoted messageShow quoted text
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.--
|
|
|
|
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.
toggle quoted messageShow quoted text
At 04:25 PM 6/9/2019, you wrote:
Thanks. And, Editing Formulas?
|
|
|
|
moderated
Re: Inserting Rows in an existing Excel Sheet
George Gray
Thanks. And, Editing Formulas?
toggle quoted messageShow quoted text
On 6/9/19, Ann Byrne <annakb@...> wrote:
Realize, though, that you can still use the Office 2003 commands. To --
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.
toggle quoted messageShow quoted text
At 03:03 PM 6/9/2019, you wrote:
Alrightie Now! That's not very intuitive as it was before..:)
|
|
|
|
moderated
Re: Inserting Rows in an existing Excel Sheet
George Gray
Alrightie Now! That's not very intuitive as it was before..:)
toggle quoted messageShow quoted text
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 --
HAVE A MAGNIFICENT DAY GEORGE BURRELL GRAY Ocean Winds Cabarete/Sosua REPUBLICA DOMINICANA
|
|
|
|
moderated
Re: Inserting Rows in an existing Excel Sheet
Sieghard Weitzel <sieghard@...>
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.
toggle quoted messageShow quoted text
-----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 <gbmagoo@...>
yes
toggle quoted messageShow quoted text
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
toggle quoted messageShow quoted text
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
Sieghard Weitzel <sieghard@...>
There are quite a few ways to skin a cat so to speak in most Microsoft programs.
toggle quoted messageShow quoted text
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,
toggle quoted messageShow quoted text
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
Sieghard Weitzel <sieghard@...>
No, I deleted them all.
toggle quoted messageShow quoted text
-----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,
|
|
|
|
moderated
Re: Excel rows and columns
Russell Solowoniuk
Hi Sieghard,
toggle quoted messageShow quoted text
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,
|
|
|
|
moderated
Re: Inserting Rows in an existing Excel Sheet
Sieghard Weitzel <sieghard@...>
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.
toggle quoted messageShow quoted text
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
|
|
|
|
moderated
Inserting Rows in an existing Excel Sheet
George Gray
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
Sieghard Weitzel <sieghard@...>
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.
toggle quoted messageShow quoted text
-----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,
|
|
|
|
moderated
Re: Excel rows and columns
Sieghard Weitzel <sieghard@...>
First I have to get it to work in the first place. For some reason I can’t get automatic readings of row and column headings to work using this method at all. I already have a template of this workbook set up and I usually just open it each time a new month starts and then use F12 to save it but giving it the name of the month. For example, my template is Sales Summary and I then save it, for example, as Sales Summary June 2019. I wouldn’t mind setting up the row and column title reading on each sheet separately if I could just get it to work.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of
Russell Solowoniuk
Sent: Sunday, June 9, 2019 7:38 AM To: main@jfw.groups.io Subject: Re: Excel rows and columns
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…” and press enter. Type “Title” 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” as the name. Continue doing this on subsequent sheets, each time increasing the number after “Title”. Note that there is no space between “Title” 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
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: main@jfw.groups.io <main@jfw.groups.io>
On Behalf Of Brian Vogel
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:
i. Open the Formula ribbon (ALT-M) ii. Activate the “Define Name” command (M) iii. Within the drop-down list, activate “Define Name” iv. The “New Name” 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:
i. Start the range name with the label that tells Excel you’re creating a title range
ii. Add a name for the range
iii. Optional - Add the last cell in the range preceded by two periods
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:
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
Ann Byrne
If you use save-as for the new sheets, it works.
toggle quoted messageShow quoted text
At 09:37 AM 6/9/2019, you wrote:
Hi Sieghard,
|
|
|
|
moderated
Re: Excel rows and columns
Russell Solowoniuk
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…” and press enter. Type “Title” 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” as the name. Continue doing this on subsequent sheets, each time increasing the number after “Title”. Note that there is no space between “Title” 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: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
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:
i. Open the Formula ribbon (ALT-M) ii. Activate the “Define Name” command (M) iii. Within the drop-down list, activate “Define Name” iv. The “New Name” 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:
i. Start the range name with the label that tells Excel you’re creating a title range
ii. Add a name for the range
iii. Optional - Add the last cell in the range preceded by two periods
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:
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: Help with printing one page of multiple pages
Ed Legge <edward.legge@...>
“Try highlighting the page you want to print and do the ctrl/p.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Laura Richardson
Sent: Saturday, June 8, 2019 10:41 AM To: main@jfw.groups.io Subject: Re: Help with printing one page of multiple pages
How do I get to the drop down box?
Laura
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
As Rick has indicated, if the page you want to print happens to be the one you currently are looking at in Word (or pretty much any program, it works the same in PDF readers and other programs, too). 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
|
|
|