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