Re: Title of column or row in Excel
FYI Hadley has an excellent course for learning excel. ? ?
toggle quoted message
Show quoted text
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
|
Re: Title of column or row in Excel
Brian,
You're very welcome and I'm glad it was helpful.
I've gotten so much helpful info from various lists through the years and it's nice to give back. Crowd sourcing is great because someone is usually out there who has come across your issue.
Alan?
toggle quoted message
Show quoted text
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
|
Re: 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
|
Re: Title of column or row in Excel
Brian, ? If I want to create an Excel formula to sum amounts in rows above it and to automatically adjust to include any inserted rows, I include a blank line between the row amounts being summed and the row containing the formula and include this blank row in the sum total. For example, if my spreadsheet contains headings in row 1, current data in rows 2 through 20, and the value to be summed in column E, I'd leave row 21 blank and place this formula in cell E22: ? =Sum(E1..E21) ? Any rows inserted beginning at blank row 21 will cause the formula in cell E22 to automatically adjust to include their values in the sum. This will also be the case if new rows are inserted at the top of the sheet beginning in row 2. ? Alan Lemly ?
toggle quoted message
Show quoted text
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
|
Re: 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 ?
toggle quoted message
Show quoted text
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 ?
|
Re: Migrating Outlook contact from broken computer to new computer
I would have to look up the instructions myself, but if you have the original disc with the original Outlook archive(s) on it, you should be able to import them wholesale into a new running instance of Outlook on another machine. See:??
or any one of a number of documents returned by:? ?
If you have an OST, a PST has to be there somewhere, too.
--
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
|
Re: Migrating Outlook contact from broken computer to new computer
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 ?
toggle quoted message
Show quoted text
From: [email protected] < [email protected]> On Behalf Of HSG Director Sent: Wednesday, September 30, 2020 2:24 AM To: [email protected]Subject: Re: [office-accessibility] Migrating Outlook contact from broken computer to new computer ? 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?
|
Re: 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
|
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 ?
|
Re: What is the process for sending emails to a group of 20 people without having to always type in their addresses
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. ? ?
toggle quoted message
Show quoted text
From: [email protected] <[email protected]> On Behalf Of chris judge
Sent: Wednesday, September 30, 2020 4:23 AM
To: [email protected]
Subject: Re: [office-accessibility] What is the process for sending emails to a group of 20 people without having to always type in their addresses? 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. ? ? From: [email protected] <[email protected]> On Behalf Of Paul Ferrara
Sent: September 29, 2020 9:21 AM
To: [email protected]
Subject: [office-accessibility] What is the process for sending emails to a group of 20 people without having to always type in their addresses ? 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@... ?
|
Some Questions About Dealing With Tables, and lists In Word 2016 and Jaws 2020
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
|
Re: What is the process for sending emails to a group of 20 people without having to always type in their addresses
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. ? ?
toggle quoted message
Show quoted text
From: [email protected] <[email protected]> On Behalf Of Paul Ferrara
Sent: September 29, 2020 9:21 AM
To: [email protected]
Subject: [office-accessibility] What is the process for sending emails to a group of 20 people without having to always type in their addresses? 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@... ?
|
Re: Migrating Outlook contact from broken computer to new computer
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. ?
toggle quoted message
Show quoted text
From: [email protected] <[email protected]> On Behalf Of Rick
Sent: 29 September 2020 21:35
To: [email protected]
Subject: Re: [office-accessibility] Migrating Outlook contact from broken computer to new computer? 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?
|
Re: replying to a message privately?
As a moderator on multiple groups, I can say with certainty that the default behavior (which can be changed, but I don't know of anyone who's done so) for a reply is "Reply to Group." For those of you who are group owners or moderators, you can check out the setting for your group this way: 1. Log in to the Groups.io website and navigate to the group for which you wish to check. 2. Activate the Admin dropdown control and then select Settings from the menu that drops down. 3. Activate the Message Policies link in Settings, which will open exactly the collection of settings its name implies. 4. Search on "Reply To".? There is a dropdown box which will contain Group (by default) and which could be changed to Sender, Moderators, Group and Sender, Topic Followers only. Since the common thing on emailing lists is to want one's replies to go to the group by default, this is virtually never changed.? --
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
|
Re: replying to a message privately?
I was using Gmail years ago and the same instructions were suggested.? Then I switched to Outlook.? I found hitting the applications key would bring
up the menu of quick print, reply, reply to all etc.? It was my understanding that hitting reply meant just to the poster.? I got it sorted out thanks to Brian.? The thing is though, on one group they had the “reply to sender” link but it was not properly
set up somehow. When you click on that link it sent your message to the entire group.? ?
?
Thank you for emailing The Diamond Touch Dog Rehabilitation Centre.??? For a full list of our services visit the following website: https://thediamondtouchdog.ca/
?
toggle quoted message
Show quoted text
From: [email protected] <[email protected]>
On Behalf Of Alan Lemly via groups.io
Sent: September 29, 2020 1:45 PM
To: [email protected]
Subject: Re: [office-accessibility] replying to a message privately?
?
I can still press JAWS key + shift + r using Fusion 2020 and Outlook 2010 to generate a private reply to a list poster.
?
Alan Lemly
?
?
Hello. With Groups.io pressing ctrl-R will still send a reply to the list. In Groups.io messages is a link for replying to the sender. Pressing enter on this link should allow you to reply to the sender only.
David Goldfield,
Assistive Technology Specialist
?
JAWS Certified, 2019
?
On 9/29/2020 12:20 PM, David Diamond wrote:
I’m using office 2019, when I hit reply, it goes to the entire group.? How do I send a message privately.? I thought to send to a group you would hit “reply to
all” Years ago when this would happen with other email programs I was told the group was not set up properly and that’s why it was not working correctly.? ?
?
Thank You for contacting
The Diamond Touch Dog Rehabilitation Centre
?
? For information on our services please go to the following website:
?
?
--
Feel free to visit the moderator's Web site
|
Re: replying to a message privately?
As I've said about many things, if there's a sure way to get something that always works, it's better to use that than things that only sometimes work. Since Groups.io gives a mechanism, the Reply to Sender link, in messages that was created with e-mail users specifically in mind, and in my experience it always works . . . Mailto: links have been in common use to cause the opening of a composition window for the purpose of writing someone for many 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
|
Re: replying to a message privately?
I can still press JAWS key + shift + r using Fusion 2020 and Outlook 2010 to generate a private reply to a list poster. ? Alan Lemly ?
toggle quoted message
Show quoted text
From: [email protected] [mailto:[email protected]] On Behalf Of David Goldfield
Sent: Tuesday, September 29, 2020 11:25 AM
To: [email protected]
Subject: Re: [office-accessibility] replying to a message privately?? Hello. With Groups.io pressing ctrl-R will still send a reply to the list. In Groups.io messages is a link for replying to the sender. Pressing enter on this link should allow you to reply to the sender only. David Goldfield, Assistive Technology Specialist ? JAWS Certified, 2019 ? On 9/29/2020 12:20 PM, David Diamond wrote: I’m using office 2019, when I hit reply, it goes to the entire group.? How do I send a message privately.? I thought to send to a group you would hit “reply to all” Years ago when this would happen with other email programs I was told the group was not set up properly and that’s why it was not working correctly.? ? ? Thank You for contacting The Diamond Touch Dog Rehabilitation Centre ? ? For information on our services please go to the following website: ? ?
--
Feel free to visit the moderator's Web site
|
Re: Migrating Outlook contact from broken computer to new computer
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 ?
toggle quoted message
Show quoted text
From: [email protected] < [email protected]> On Behalf Of Brian Vogel Sent: Monday, September 28, 2020 6:01 PM To: [email protected]Subject: Re: [office-accessibility] Migrating Outlook contact from broken computer to new computer ? 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?
|
Would anyone know how to do a message rule?
Hello to all.
Would appreciate it if anyone would know how to create a message rule, to
ship that knowledge my way please.
In WLM, it was oh so easy.
You had four columns from left to right.
The first column I always down arrowed until I saw Where To or CC contains
people.
I always made sure that one was checked.
I think I'm stuck on step two within Outlook's message rules instructions.
If anyone could show me via keyboard commands the following:
1. where the name of the rule goes.
2. Where the e-mail address for that rule goes.
3. How to make sure the mail has a audio sound and goes into the correct
mailbox.
Many thanks.
Ron who's still learning how to use the outlook mail package with JAWS 2020
In the good old days of Morse code Shorthand, 73's AKA Best Regards and or
Best Whishes,From
Ron Kolesar
Volunteer Certified Licensed Emergency Communications Station
And
Volunteer Certified Licensed Ham Radio Station
With the Call Sign of KR3DOG
Who's now also Ares and NIMS Certified as well
|
Good afternoon,
I know someone asked about using JAWS and Power Point not that long ago…I wanted to share this opportunity from APH
?
Using PowerPoint with JAWS?????
October 14, 2020, 11:30 AM-1:00 PM??EST
?
Have a terrific Tuesday!
Amy
|
Brian Vogel