?

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

?

From: [email protected] [mailto:[email protected]] On Behalf Of Brian Vogel
Sent: Wednesday, September 30, 2020 10:16 AM
To: [email protected]
Subject: Re: [office-accessibility] Title of column or row in Excel

?

I do not believe you can make two heading rows for a single table.? The text in a single row (or cell in a row) can span multiple lines, though, the cell just expands vertically to accommodate it.

You can place a sum formula anywhere you wish, for any data you wish.? If you intend to have a total row you could place that, say, 20 cells below the first data row, if your table rows will be fewer than that.? I still have never figured out how to have an "auto expanding sum" where, if I add additional rows above it, the row letters beyond those that I initially set up for the sum would be included, and I don't even know if this is possible.? ? I think that they're trying to say that it's common for total rows to appear in the same column, in some row somewhere below the heading and the intervening table rows being summed.
--

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

?

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

?

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

?

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

?

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

?

?

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 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

?

?

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

?

?

?

?

?

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

?

?

Hi Barry, Brian, and List,

?

I apologize for the delay in replying but I had other stuff going on today that delayed me. Brian, I'm not interested in any thunder so welcomed and appreciated your example Excel spreadsheet. In fact, I started with it and modified it some which I'll explain below. If someone can use it, that's great but if someone can learn something from it, that's even better.

?

Barry, I changed a couple of things from your below description. First, I changed cell A1 to Month Reported and input September, 2020 in cell B1. I figured you wanted a sheet that could be used in future months and it seemed easier to me to input the month being reported in column B than editing the description in column A. As Brian had done, I left row 2 blank and then modified the description a bit and added one additional row to end up with the following in cells A3 through A6:

?

Work performed for: Name

Work performed for: address

Work performed by

Reports to: Name and email

?

I also inserted Barry's name and email address in cells B5 and C5 so those should be verified for accuracy.

?

I expanded the section where the volunteer hours are reported. First of all, I re-ordered the first two columns to place Work Performed in column A and Date in column B. My reason for doing this is that since column A was already the widest column because of the descriptions it contains in the first section, it made sense to have the column containing the description of the work being performed also in that ?column since it contains more characters than the other info reported in section 2. Also, with the titles I've set for Excel to automatically report as one arrows through the volunteer hours being reported, I thought it made more since for Excel to announce the work performed value as opposed to the date value. Finally, I added a column D to include a running total and I added several more rows so that section 2 where the hours are reported now takes up cells A8 through D31. I copied the running total formula so it is present in cells D8 through D31. I left the sample hours Brian had previously input in column C.

?

One thing I really like about Excel is that it will announce row titles and column headings as you arrow through the spreadsheet if it is set up to do so. ?You create the ranges needed for this by accessing the range manager by pressing alt + m + n and creating a new range. The other options when opening the range manager include Edit and Delete for managing existing ranges. Here are the two ranges I created in Brian's Barry example spreadsheet:

?

TitleRegion1.a1.c6.1

TitleRegion2.a8.d31.1

?

It is imperative that Title begin the range name and I find it easier if I use Region followed by a number to distinguish separate regions so they will sort alphabetically when accessed with the Range manager. No spaces should be entered between Title and Region1 but I like to capitalize the R in region to improve synthesizer pronunciation. Note that periods separate the parts of the title range parameters. Following the first period is the cell range in the title. In my first section, A1.C6 is the range. Note that a period separates the beginning cell in the range from the ending cell in the range. The period after this range separates the trailing 1 which represents the sheet tab of the range. I think since this workbook only contains one sheet tab, the trailing period and 1 might could be omitted. As you arrow though cells B1 through C6, Excel should speak the description values in column A to identify where you are.

?

For those who haven't used titles, as you arrow right and left among columns that contain column headings, Excel should announce the value in that column heading as you move into it. By the same token, row titles if they've been define should be announced by Excel as you arrow up and down into different rows. This will be especially evident in section 2 of this sheet which will announce the work performed value that I've input in cells A9 through A11 as you arrow up and down through those rows and also announce the column heading as you arrow among columns A through D in that section.

?

I added a bunch of extra rows in section 2 for those months where someone volunteers a lot. These extra rows can be deleted without causing any issue. The worksheet when printed should also appear well on a printed page.

?

Here is a Dropbox download link for those who want to examine my attempt at this:

?

?

If there are any questions, please post back.

?

Alan Lemly

?

?

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

?

?

?

?

?

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

?

?

Barry,

I would think that the only thing you'd actually need with actual headings used in the spreadsheet is the table for date/work/hours.

All the rest of your fields would have the label read as you went down the first column of the spreadsheet prior to the table and I'd imagine the next cell over, a single tab away, is where you'd enter your data.

Apologies to both Alan and Joyce, as I'm really not trying to steal anyone's thunder, but have a look at and see if it meets your needs.? I have included some spacing with blank rows since you say this will likely be printing this, and whitespace is important to us sighted folks!
?
--

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

?