Good morning all,



I’m using Jaws 2020 and Excel 2016 and am of late having a major issue. I
cannot read cells, my arrow keys move the window up and down or left and
right. In order to read the cells I have to shift f10, escape and then read.
The process is most annoying and prevents quick and easy data access. I use
Excel for quite a few things throughout the day and really need a fix for
this rather urgently.



Thank you,

Sarah Hale

Work: 714.852.3238

Email: <mailto:sarah.hale@...> sarah.hale@...

On Oct 1, 2020, at 6:25 AM, Barry Hill via groups.io <barry.hill3@...> wrote:

?

Thanks, Alan.

The spreadsheet is for some voluntary work I’m doing for a charity.? I think I need to give you the details of what I want.?

On row one, I want the title of ‘September Monthly Record’ for September, which will obviously change each month.? I thought I’d just put this in column B as I’m only using three columns at the most.

On row 2, I want ‘Work for in column a as a heading then the address of the charity in column b.

On row 3, I want ‘Carried out by’ as a heading in column a then my name in column b and my email address in column c.

On row 4, I want ‘Reports to’ as a heading in column a then their name in column b and their email in column c.

I will leave a row space before putting the next lot of data that will go like this:

In row six, I want three headings across the columns: Date, Work carried out, then hours.

The hours then need a sum to add them up, but, ideally, I’d like this as a running total as I have a fixed number of hours that I should be doing each month.

There is a chance that these worksheets will be printed off.

So, what do you think?? Is it possible?? Is Excel the right app for this?

?

Cheers

?

Barry

?

?

?

?

From: [email protected] <[email protected]> On Behalf Of Alan Lemly
Sent: 30 September 2020 5:39 PM
To: [email protected]
Subject: Re: [office-accessibility] Title of column or row in Excel

?

Barry,

?

I need to clarify my understanding of what you're trying to do in item 1. It sounds to me as if you want two regions on the same worksheet tab. The first region will consist of two rows plus a heading row and the second region will consist of expanding rows for which one of the columns will be an amount and the second column will contain a running total of the previous column amount. It also sounds as if you want to have Excel announce the applicable row title or column heading for each region as you navigate among the cells in each.

?

I'd be happy to give instructions of how to do this but I'd much prefer that you post back to confirm this and to also give more details of what you expect to place in specific cells.

?

To answer your question 2, I'm going to give an example of a checkbook spreadsheet with the following row 1 headings in each column:

?

A - Date

B - Check number

C - Description

D - Amount

E - Running total

?

With this example, you'd start entering your actual checks in row 2. Cell E2 should contain the formula =E1+E2. Since E1 is a column heading, it will be treated as a 0 and the running total for your first check will equal its amount. When you copy the cell E2 formula down the remaining rows where you intend to enter more checks, it will automatically add the running total from the previous row to the check amount on the current row giving you a running total for new amounts entered in column D of future rows.

?

I'll tell you the steps to get Excel to speak the column headings and row titles for each region after you clarify my questions in paragraph one.

?

Alan Lemly

?

From: [email protected] [mailto:[email protected]] On Behalf Of Barry Hill via groups.io
Sent: Wednesday, September 30, 2020 9:13 AM
To: Office accessibility group
Subject: [office-accessibility] Title of column or row in Excel

?

Hi all

?

I’ve just started playing around with Excel and I have two questions:

?

1. I’m wanting to put a row heading for two rows then start a separate ?table below with column headings, but I want it all on one work sheet.? How do I lable those headings so they are headings?

?

2. In one column, I want to add up each cell and have a running total as I update the table.? Where and how do I put the sum?? The Microsoft help seems to say that I put it in the cell below the heading, but then do I have to insert a new row above it every time I want to add data?

?

Cheers

?

Barry

?

?

I'm not Alan, but that sounds like a very typical (and simple) Excel spreadsheet.? It's not unlike the billing sheet that I've used to submit hours to the Virginia Department for the Blind and Visually Impaired for years now.

--

Brian?-?Windows 10 Pro, 64-Bit, Version 2004, Build 19041??

It’s hard waking up and realizing it’s not always black and white.

?????~ Kelley Boorn

On Oct 1, 2020, at 5:25 AM, Barry Hill via groups.io <barry.hill3@...> wrote:

?

Thanks, Alan.

The spreadsheet is for some voluntary work I’m doing for a charity.? I think I need to give you the details of what I want.?

On row one, I want the title of ‘September Monthly Record’ for September, which will obviously change each month.? I thought I’d just put this in column B as I’m only using three columns at the most.

On row 2, I want ‘Work for in column a as a heading then the address of the charity in column b.

On row 3, I want ‘Carried out by’ as a heading in column a then my name in column b and my email address in column c.

On row 4, I want ‘Reports to’ as a heading in column a then their name in column b and their email in column c.

I will leave a row space before putting the next lot of data that will go like this:

In row six, I want three headings across the columns: Date, Work carried out, then hours.

The hours then need a sum to add them up, but, ideally, I’d like this as a running total as I have a fixed number of hours that I should be doing each month.

There is a chance that these worksheets will be printed off.

So, what do you think?? Is it possible?? Is Excel the right app for this?

?

Cheers

?

Barry

?

?

?

?

From: [email protected] <[email protected]> On Behalf Of Alan Lemly
Sent: 30 September 2020 5:39 PM
To: [email protected]
Subject: Re: [office-accessibility] Title of column or row in Excel

?

Barry,

?

I need to clarify my understanding of what you're trying to do in item 1. It sounds to me as if you want two regions on the same worksheet tab. The first region will consist of two rows plus a heading row and the second region will consist of expanding rows for which one of the columns will be an amount and the second column will contain a running total of the previous column amount. It also sounds as if you want to have Excel announce the applicable row title or column heading for each region as you navigate among the cells in each.

?

I'd be happy to give instructions of how to do this but I'd much prefer that you post back to confirm this and to also give more details of what you expect to place in specific cells.

?

To answer your question 2, I'm going to give an example of a checkbook spreadsheet with the following row 1 headings in each column:

?

A - Date

B - Check number

C - Description

D - Amount

E - Running total

?

With this example, you'd start entering your actual checks in row 2. Cell E2 should contain the formula =E1+E2. Since E1 is a column heading, it will be treated as a 0 and the running total for your first check will equal its amount. When you copy the cell E2 formula down the remaining rows where you intend to enter more checks, it will automatically add the running total from the previous row to the check amount on the current row giving you a running total for new amounts entered in column D of future rows.

?

I'll tell you the steps to get Excel to speak the column headings and row titles for each region after you clarify my questions in paragraph one.

?

Alan Lemly

?

From: [email protected] [mailto:[email protected]] On Behalf Of Barry Hill via groups.io
Sent: Wednesday, September 30, 2020 9:13 AM
To: Office accessibility group
Subject: [office-accessibility] Title of column or row in Excel

?

Hi all

?

I’ve just started playing around with Excel and I have two questions:

?

1. I’m wanting to put a row heading for two rows then start a separate ?table below with column headings, but I want it all on one work sheet.? How do I lable those headings so they are headings?

?

2. In one column, I want to add up each cell and have a running total as I update the table.? Where and how do I put the sum?? The Microsoft help seems to say that I put it in the cell below the heading, but then do I have to insert a new row above it every time I want to add data?

?

Cheers

?

Barry

?

?

Barry,

?

I need to clarify my understanding of what you're trying to do in item 1. It sounds to me as if you want two regions on the same worksheet tab. The first region will consist of two rows plus a heading row and the second region will consist of expanding rows for which one of the columns will be an amount and the second column will contain a running total of the previous column amount. It also sounds as if you want to have Excel announce the applicable row title or column heading for each region as you navigate among the cells in each.

?

I'd be happy to give instructions of how to do this but I'd much prefer that you post back to confirm this and to also give more details of what you expect to place in specific cells.

?

To answer your question 2, I'm going to give an example of a checkbook spreadsheet with the following row 1 headings in each column:

?

A - Date

B - Check number

C - Description

D - Amount

E - Running total

?

With this example, you'd start entering your actual checks in row 2. Cell E2 should contain the formula =E1+E2. Since E1 is a column heading, it will be treated as a 0 and the running total for your first check will equal its amount. When you copy the cell E2 formula down the remaining rows where you intend to enter more checks, it will automatically add the running total from the previous row to the check amount on the current row giving you a running total for new amounts entered in column D of future rows.

?

I'll tell you the steps to get Excel to speak the column headings and row titles for each region after you clarify my questions in paragraph one.

?

Alan Lemly

?

?

Hi all

?

I’ve just started playing around with Excel and I have two questions:

?

1. I’m wanting to put a row heading for two rows then start a separate ?table below with column headings, but I want it all on one work sheet.? How do I lable those headings so they are headings?

?

2. In one column, I want to add up each cell and have a running total as I update the table.? Where and how do I put the sum?? The Microsoft help seems to say that I put it in the cell below the heading, but then do I have to insert a new row above it every time I want to add data?

?

Cheers

?

Barry

?

?

FYI

Hadley has an excellent course for learning excel.

?

?

?

Alan,

? ? ? ? ? ? Thanks much for that tip, which will go into my files.? It's been a long while since I needed to do a complex spreadsheet from scratch, but when I last did it frustrated me to no end that I could not seem to find "the magic search terms" to get me to precisely the advice you've given.? It made no sense to me that there would not be a way to create a "self adjusting summation" when there are so many occasions where the next row will be added as needed and you just want that sum to take it in to consideration.
--

Brian?-?Windows 10 Pro, 64-Bit, Version 2004, Build 19041??

It’s hard waking up and realizing it’s not always black and white.

?????~ Kelley Boorn

FYI

Hadley has an excellent course for learning excel.

?

?

From: [email protected] <[email protected]> On Behalf Of Brian Vogel
Sent: Wednesday, September 30, 2020 1:27 PM
To: [email protected]
Subject: Re: [office-accessibility] Title of column or row in Excel

?

Alan,

? ? ? ? ? ? Thanks much for that tip, which will go into my files.? It's been a long while since I needed to do a complex spreadsheet from scratch, but when I last did it frustrated me to no end that I could not seem to find "the magic search terms" to get me to precisely the advice you've given.? It made no sense to me that there would not be a way to create a "self adjusting summation" when there are so many occasions where the next row will be added as needed and you just want that sum to take it in to consideration.
--

Brian?-?Windows 10 Pro, 64-Bit, Version 2004, Build 19041??

It’s hard waking up and realizing it’s not always black and white.

?????~ Kelley Boorn

?

Control #3 for contact list.

Alt h, c, g name the contact group

Alt h, m a ?to get to contacts in your address book.

and down arrow through your contact list

press Enter on names you want to add to the group

Then tap to ok when finished with the entire list and

Alt s to save group list.

?

?

?

I’m lazy.? I type in the recipients of the group I’m going to send to often in a message.? Then I copy and paste the list into a notepad file and put it in a handy place with a memorable name.? Notably, I only do this with groups I regularly send to such as my Board of Directors or staff.

?

?

?

Hi Paul. For sure creating groups in outlook can be tedious. Here’s what I do. If I have a group that I post to on a regular basis I create a simple spreadsheet in excel with each persons email address going down the left-hand column. Start at row 1 column 1 and enter each address in a separate cell down the column. Save this sheet with the group name, or whatever you wish. When you want to post to the group, open the sheet and select column A by holding control Shift and pressing down arrow. Copy the selected cells to clip board. Next, open outlook and begin composing a new message. Paste the contents of the clip board in to the To field and go ahead with the rest of the message.

?

Hope this helps.

?

?

?

Using Outlook 2016, JAWS 2020.

I have created groups, however, people are saying it doesn’t work and/or I have had issues adding people to them.

The group is part of a team in Teams so perhaps the team email is the best way to go.

I need to reach this group with information and want to avoid having to remember and add in each person each time I want to contact the group.

Suggestions please.

Thank you.

?

?

Paul Ferrara, CPACC and

?

Communications Accessibility Editor, Dot6

American Printing House

1839 Frankfort Avenue, Louisville, KY 40206

Main 502 895 2396

pferrara@...

?

?

I’m lazy.? I type in the recipients of the group I’m going to send to often in a message.? Then I copy and paste the list into a notepad file and put it in a handy place with a memorable name.? Notably, I only do this with groups I regularly send to such as my Board of Directors or staff.

?

?

?

Hi Paul. For sure creating groups in outlook can be tedious. Here’s what I do. If I have a group that I post to on a regular basis I create a simple spreadsheet in excel with each persons email address going down the left-hand column. Start at row 1 column 1 and enter each address in a separate cell down the column. Save this sheet with the group name, or whatever you wish. When you want to post to the group, open the sheet and select column A by holding control Shift and pressing down arrow. Copy the selected cells to clip board. Next, open outlook and begin composing a new message. Paste the contents of the clip board in to the To field and go ahead with the rest of the message.

?

Hope this helps.

?

?

?

Using Outlook 2016, JAWS 2020.

I have created groups, however, people are saying it doesn’t work and/or I have had issues adding people to them.

The group is part of a team in Teams so perhaps the team email is the best way to go.

I need to reach this group with information and want to avoid having to remember and add in each person each time I want to contact the group.

Suggestions please.

Thank you.

?

?

Paul Ferrara, CPACC and

?

Communications Accessibility Editor, Dot6

American Printing House

1839 Frankfort Avenue, Louisville, KY 40206

Main 502 895 2396

pferrara@...

?

?

Hello:

?

As I said in my original email, I only have access to the hard disk where the account resides. The computer is broken, so exporting from the original computer is not an option.

?

Rick

?

?

You will need to export your contacts as a PST file and then, import them in Outlook on the new machine. Look under the file menu, import and export or Google it for step by step instructions.

?

?

Hello:

?

Thanks for the suggestions. The email account is a Comcast account. However, my address book and groups are not stored online so that is not an option.

?

Rick

?

?

On Mon, Sep 28, 2020 at 05:57 PM, Shaun Everiss wrote:

if you have used imap, your contacts are probably all online, just resync your account and it work fine enough.

-
At least for Gmail, I have always needed to use add-ons to force the sync of contacts and calendar.? Pure IMAP does not do it with Outlook or Thunderbird.? Why this is remains a mystery to me.? Who would want to sync only e-mail messages rather than e-mail and contacts/address book at a minimum?

Good morning everyone. My name is Owais, and I have some questions regarding
tables in any apps, particularly, Word 2016.
1. How do I add a table, and from there add more rows and collumns to it?
2. Should tables be left justified, centered, or, right justified on a page?
3. What are the steps to adding a tittle for each cell? To clarify, some
tables have a cell above the one under it which indicates the informwhn that
needs to be entered in the cell bel? How do I do th?
4. How can I copy the entire table including the text it contains all at
once?
Lists:
1. What are the steps to inserting a bulleted list in my document, so that
screen readers like Voiceover, Jaws etc will indicate when a list begins or
ends?
Thank you very much and have an awesome day.
Sincerely, Owais

?

Alan,

? ? ? ? ? ? Thanks much for that tip, which will go into my files.? It's been a long while since I needed to do a complex spreadsheet from scratch, but when I last did it frustrated me to no end that I could not seem to find "the magic search terms" to get me to precisely the advice you've given.? It made no sense to me that there would not be a way to create a "self adjusting summation" when there are so many occasions where the next row will be added as needed and you just want that sum to take it in to consideration.
--

Brian?-?Windows 10 Pro, 64-Bit, Version 2004, Build 19041??

It’s hard waking up and realizing it’s not always black and white.

?????~ Kelley Boorn