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

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