?

I'm also tired, as I should have said that inserting a row will always put that row ABOVE/BEFORE the one that you have focus on.

The CTRL plus plus sign command can also be used to insert a column if you have focus on a column rather than a row. If you do this, the new column goes in to the LEFT of the one you have focus on.

The CTRL plus minus sign command can be used to delete a row/column depending on which has focus.
--

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

?

Melissa,

? ? ? ? ? ?This downloadable PDF,??

, is about as comprehensive as I've seen, and gives a table of the special character sequences for MS-Word Find and Replace at the end, and I'd imagine the table on page 22 of the document is specifically what you're asking about.

This webpage is also an excellent reference:????

--

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 4:12 PM, Jim Fettgather <jimfettgather@...> wrote:

?Hello, I must do this all the time, so I use Find and Replace.
1. Launch the Find and Replace command with Control H.
2. In the first box, type ^T. If you do not have punctuation turned
on just in case, that is a shifted 6 followed by the letter t.
3. Tab over to the Replace edit box and type a space. At least, this
is what I type to get rid of all the tabs.
4. Press Alt A to Replace All, and that should do it.

On 10/1/20, Wayne Hinckley <wwhinckley@...> wrote:
Hi Group,



Is there a way to search for the Tab character in a Word document? I need
to
eliminate any extra ones.



Thanks for any help.



Wayne Hinckley



~~

Hi Group,



Is there a way to search for the Tab character in a Word document? I need
to
eliminate any extra ones.



Thanks for any help.



Wayne Hinckley



~~

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 12:48 PM, Sarah Hale <sarah.hale@...> wrote:

?

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: sarah.hale@...

?

?

?

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

?