Hi,

Following is a formula to calculate the day of the week  from an input date.

In the first cell, in this case A4, type in 3/12/1988 and the cell with the formula will display the week day. 

=TEXT(A4,"dddd")

Depending on where you live and the date format, you may need to change the formula a little.  This formula  works on 3 December 1988 and not December 12 format.  But then it may not need to be altered at all.  You’ll just need to experiment.

HTH

Tom

Hi.

I’m looking for a source to learn about the different formulas for Excel.  I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for.  Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work.  As an example, I’d like to know how to have Excel tell me the day of the week a date will be.  Also, I’d like to know how many days are between dates.  I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas.

Thanks for any help.  Dates aren’t the only thing I’m looking for.  I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential.

Thanks for any info.

Have a blessed day and don’t work too hard.

Kevin Minor and the amazing Jilly, Lexington, KY

I have the same settings as Bill, but since the last Windows update to

I have to manually start JAWS.
I'll be reporting this to Microsoft and VFO.
Richard




"The secret is not to make your music louder, but to make the world

- Mitch Albom from The Magic Strings of Frankie Presto, page 1

On May 11, 2018, at 11:21 AM, Sieghard Weitzel

Mine are basically the same except I don't usually check the "Start
Jaws

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
<main@jfw.groups.io<mailto:main@jfw.groups.io>> On Behalf Of Bill
White
Sent: Friday, May 11, 2018 9:06 AM
To: main@jfw.groups.io<mailto:main@jfw.groups.io>
Subject: Re: start jaws automatically after log in

Hi, Stan. Here's how I have my options in JAWS set for Start JAWS

Start JAWS at the Logon screen check box checked

Start JAWS after logon for all users check box checked

Start JAWS after logon for this user: Combo box Always

Bill White
billwhite92701@...<mailto:billwhite92701@...>

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Stan Holdeman
Sent: Friday, May 11, 2018 8:56 AM
To: jfw@groups.io<mailto:jfw@groups.io>
Subject: start jaws automatically after log in

I am running j2018 and windows 10.

Using the options/basics dialogue in j2018 I cannot get jaws to open

Appreciate your help.

Stan

It has been a while since I have done anything with the PC version, but try either control-v or alt-v and if these don't work, you might just get lucky with control-alt-v.� The change goes from a female to a male voice.� I do remember the hot key is v for voice.�

Carol

Hello All,

\

I just started using the Kindle PC software on my PC.� I want to change from the default male voice to a female, to match the author�s gender.� How do I do that?

�

Tim Ford

�

�

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of CathyAnne Murtha
Sent: Friday, May 11, 2018 4:34 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

�

I found this website to be an excellent resource.

�

You can search for formulas and review specifics for formulas and how they are used.

�

https://exceljet.net/formulas

�

�

CathyAnne

�

�

CathyAnne Murtha

Access Technology Institute, LLC

cathy@...

www.blind.training

(520) 300-7859

�

�

�

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Kevin Minor
Sent: Friday, May 11, 2018 4:31 PM
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

�

Hi.

�

I�m looking for a source to learn about the different formulas for Excel.� I purchased the book that CathyAnne Murtha wrote, but it doesn�t contain all the formulas that I�m looking for.� Essentially, I�d like a kind of Excel for Dummies where all the formulas are listed and how they work.� As an example, I�d like to know how to have Excel tell me the day of the week a date will be.� Also, I�d like to know how many days are between dates.� I looked through the book I got from Ms. Murtha, but it doesn�t list all the formulas.

�

Thanks for any help.� Dates aren�t the only thing I�m looking for.� I know Excel is a very powerful program, and I�d like to learn how to use it to its fullest potential.

�

Thanks for any info.

�

Have a blessed day and don�t work too hard.

Kevin Minor and the amazing Jilly, Lexington, KY

Hello All,

\

I just started using the Kindle PC software on my PC.� I want to change from the default male voice to a female, to match the author�s gender.� How do I do that?

�

Tim Ford

�

�

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of CathyAnne Murtha
Sent: Friday, May 11, 2018 4:34 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

�

I found this website to be an excellent resource.

�

You can search for formulas and review specifics for formulas and how they are used.

�

https://exceljet.net/formulas

�

�

CathyAnne

�

�

CathyAnne Murtha

Access Technology Institute, LLC

cathy@...

www.blind.training

(520) 300-7859

�

�

�

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Kevin Minor
Sent: Friday, May 11, 2018 4:31 PM
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

�

Hi.

�

I�m looking for a source to learn about the different formulas for Excel.� I purchased the book that CathyAnne Murtha wrote, but it doesn�t contain all the formulas that I�m looking for.� Essentially, I�d like a kind of Excel for Dummies where all the formulas are listed and how they work.� As an example, I�d like to know how to have Excel tell me the day of the week a date will be.� Also, I�d like to know how many days are between dates.� I looked through the book I got from Ms. Murtha, but it doesn�t list all the formulas.

�

Thanks for any help.� Dates aren�t the only thing I�m looking for.� I know Excel is a very powerful program, and I�d like to learn how to use it to its fullest potential.

�

Thanks for any info.

�

Have a blessed day and don�t work too hard.

Kevin Minor and the amazing Jilly, Lexington, KY

Hi.

I’m looking for a source to learn about the different formulas for Excel.  I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for.  Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work.  As an example, I’d like to know how to have Excel tell me the day of the week a date will be.  Also, I’d like to know how many days are between dates.  I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas.

Thanks for any help.  Dates aren’t the only thing I’m looking for.  I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential.

Thanks for any info.

Have a blessed day and don’t work too hard.

Kevin Minor and the amazing Jilly, Lexington, KY

I found this website to be an excellent resource.

You can search for formulas and review specifics for formulas and how they are used.

https://exceljet.net/formulas

CathyAnne

CathyAnne Murtha

Access Technology Institute, LLC

cathy@...

www.blind.training

(520) 300-7859

Hi.

I’m looking for a source to learn about the different formulas for Excel.  I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for.  Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work.  As an example, I’d like to know how to have Excel tell me the day of the week a date will be.  Also, I’d like to know how many days are between dates.  I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas.

Thanks for any help.  Dates aren’t the only thing I’m looking for.  I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential.

Thanks for any info.

Have a blessed day and don’t work too hard.

Kevin Minor and the amazing Jilly, Lexington, KY

Hi.

I’m looking for a source to learn about the different formulas for Excel.  I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for.  Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work.  As an example, I’d like to know how to have Excel tell me the day of the week a date will be.  Also, I’d like to know how many days are between dates.  I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas.

Thanks for any help.  Dates aren’t the only thing I’m looking for.  I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential.

Thanks for any info.

Have a blessed day and don’t work too hard.

Kevin Minor and the amazing Jilly, Lexington, KY

Thank you, Cathyanne.  Not sure why I did not think to try the context key.  This was way more complete of an explanation than I expected and very much appreciated.

The Download Manager of internet Explorer is pretty simple.

You can open it at any time from within internet Explorer with CTRL-J.

Once focused in the download manager focus is on the download list

• Navigate among downloads with UP and DOWN ARROW
• Once focused on a download, open the Windows Application Menu (WINDOWS APPLICATION KEY or SHIFT-F10)
• Within the Windows Application Menu are options to manage the download:
• Delete File
• Copy Download Link
• Go to Download Webpage
• Open Containing Folder
• Report that this file is unsafe
• Rerun security checks on this file
• There may be additional options available depending upon the type of download

To open a document:

• Activate the “Open Containing Folder” option
• File Explorer opens with focus on the document
• Press ENTER to open the document in its associated application

You can also press RIGHT ARROW until focus is on the “Open” button and press ENTER to open the document.

The dialog has a search field:

• Press CTRL-E at any time to focus in the search field
• Type a text string
• The download list refreshes to show only documents that match the search term

To clear the search:

• Focus in the search field (CTRL-E)
• Tap ESCAPE to clear the contents

You can clear the download list by activating the “Clear List” button of the dialog.  This clears the list but doesn’t delete the downloaded documents. They are still in your downloads folder.

Close the Download manager with ESCAPE

I hope this  basic explanation helps.

CathyAnne

CathyAnne Murtha

Access Technology Institute, LLC

cathy@...

www.blind.training

(520) 300-7859

Hi,

Lately, I have had several instances where I get an email receipt of an purchase made for an audio book or PDF book.  The email contains a link that, when clicked, seems to open a the download manager tool in Internet Explorer.  I have now also failed in understanding how to navigate this so that I can download my file.  I am quite comfortable downloading a file directly from a webpage, but this acts different and I have maxed out my downloads in a couple instances. 

Can some kind person explain the concept here?  Obviously clicking on the link triggers the website to think that I have downloaded it, as it’s counting my failed attempts, but it’s not automatically downloading into my downloads folder, so I must be missing steps.  All I know is that I can hit Control J from within IE to open a viewer of some sort, but I’m struggling from there. 

Robin

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key
send an e-mail to mailto:DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.

Hi CathyAnne,

Is your update to Office 2016 training books for sell?

Best:

James Malone

You can group worksheets that are next to on another with a keyboard command:

• Focus on the First worksheet you’d like to group
• Press CTRL-SHIFT-PAGE DOWN to group the next worksheet
• Press CTRL-SHIFT-PAGE UP to group the previous worksheet

After focusing on the last worksheet you’d like to group, you’re done! The worksheets are grouped.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of HH. Smith Jr.
Sent: Thursday, May 10, 2018 5:08 PM
To: main@jfw.groups.io
Subject: Re: Grouping worksheets 2016

Hi guys,

Yes, you are all correct; however, if you want to make global changes such as, adding a heading, footnote, format change to all your worksheets by changing one sheet in the workbook is the concept I am talking about. I have no issues with linking a cell reference from one sheet to another. It is the global changes. If you Google, "grouping excel worksheets," you will see exactly what I am concern about. sorry for the mix-up in communication.

-----Original Message-----

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin

Sent: Thursday, May 10, 2018 1:23 PM

To: main@jfw.groups.io

Subject: Re: Grouping worksheets 2016

Yes, if a value referenced in a formula is moved to another cell, then the formula is automatically updated to the new location.

One note, when moving the value, use cut and paste, or it will not work.

Chris

> On May 10, 2018, at 10:30 AM, Mario <mrb620@...> wrote:

> 

> when using formulas as talked about here, can the following still be used:

> =income!$d$4

> 

> meaning the linking to the value in d4 will still be referenced even

> if the value has moved to d9 or e5?

> 

> 

> -------- Original Message --------

> From: Paul Hunt [mailto:prhunt1@...]

> Sent: Wednesday, May 9, 2018 10:08 PM EST

> To: main@jfw.groups.io

> Subject: Grouping worksheets 2016

> 

> Hello. The correct term is Linking.

> I have a budget workbook with an income worksheet, a cash flow

> worksheet and an allocated spending plan worksheet.

> When my income changes in my income worksheet, it changes on my cash

> flow plan and allocated spending plan worksheet.

> Here is how it works.

>   Cell B7 on my income worksheet contains my income.

> I need my income to be in cell c46 of my cash flow worksheet so I

> enter the formula =income!b7 in cell c46.

> I also need my income to be in cell d3 of myallocated spending plan

> worksheet so I enter the formula =income!b7 in cell d3.

> I hope that this helps.

> Paul

> 

> On May 9, 2018, at 8:14 PM, HH. Smith Jr. <josham129@...> wrote:

> 

> Hi,

> 

> What I mean is, when you make a change to one worksheet it affects all

> the worksheets in the given work sheet group or grouping sheets to

> make global changes in the workbook.

> 

> -----Original Message-----

> From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne

> Sent: Wednesday, May 9, 2018 8:11 PM

> To: main@jfw.groups.io

> Subject: Re: Grouping worksheets 2016

> 

> I'm not sure what you mean by grouping worksheets.  Yu can rename and

> reorder than using alt+h, then o, then r to rename and alt+h, then o,

> then

m

> to move them.

> At 06:40 PM 5/9/2018, you wrote:

> Hello fellow listerrs,

> 

> Does anyone has an easier way to group work sheets. I'm trying to make

> monthly workbook and I want to group all the months. Any help

> appreciated.

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> .

> 

> 

> 

> 

> 

I have the same settings as Bill, but since the last Windows update to

I have to manually start JAWS.
I'll be reporting this to Microsoft and VFO.
Richard




"The secret is not to make your music louder, but to make the world

- Mitch Albom from The Magic Strings of Frankie Presto, page 1

On May 11, 2018, at 11:21 AM, Sieghard Weitzel

Mine are basically the same except I don't usually check the "Start
Jaws

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
<main@jfw.groups.io<mailto:main@jfw.groups.io>> On Behalf Of Bill
White
Sent: Friday, May 11, 2018 9:06 AM
To: main@jfw.groups.io<mailto:main@jfw.groups.io>
Subject: Re: start jaws automatically after log in

Hi, Stan. Here's how I have my options in JAWS set for Start JAWS

Start JAWS at the Logon screen check box checked

Start JAWS after logon for all users check box checked

Start JAWS after logon for this user: Combo box Always

Bill White
billwhite92701@...<mailto:billwhite92701@...>

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Stan Holdeman
Sent: Friday, May 11, 2018 8:56 AM
To: jfw@groups.io<mailto:jfw@groups.io>
Subject: start jaws automatically after log in

I am running j2018 and windows 10.

Using the options/basics dialogue in j2018 I cannot get jaws to open

Appreciate your help.

Stan

You can group worksheets that are next to on another with a keyboard command:

• Focus on the First worksheet you’d like to group
• Press CTRL-SHIFT-PAGE DOWN to group the next worksheet
• Press CTRL-SHIFT-PAGE UP to group the previous worksheet

After focusing on the last worksheet you’d like to group, you’re done! The worksheets are grouped.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of HH. Smith Jr.
Sent: Thursday, May 10, 2018 5:08 PM
To: main@jfw.groups.io
Subject: Re: Grouping worksheets 2016

Hi guys,

Yes, you are all correct; however, if you want to make global changes such as, adding a heading, footnote, format change to all your worksheets by changing one sheet in the workbook is the concept I am talking about. I have no issues with linking a cell reference from one sheet to another. It is the global changes. If you Google, "grouping excel worksheets," you will see exactly what I am concern about. sorry for the mix-up in communication.

-----Original Message-----

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin

Sent: Thursday, May 10, 2018 1:23 PM

To: main@jfw.groups.io

Subject: Re: Grouping worksheets 2016

Yes, if a value referenced in a formula is moved to another cell, then the formula is automatically updated to the new location.

One note, when moving the value, use cut and paste, or it will not work.

Chris

> On May 10, 2018, at 10:30 AM, Mario <mrb620@...> wrote:

> 

> when using formulas as talked about here, can the following still be used:

> =income!$d$4

> 

> meaning the linking to the value in d4 will still be referenced even

> if the value has moved to d9 or e5?

> 

> 

> -------- Original Message --------

> From: Paul Hunt [mailto:prhunt1@...]

> Sent: Wednesday, May 9, 2018 10:08 PM EST

> To: main@jfw.groups.io

> Subject: Grouping worksheets 2016

> 

> Hello. The correct term is Linking.

> I have a budget workbook with an income worksheet, a cash flow

> worksheet and an allocated spending plan worksheet.

> When my income changes in my income worksheet, it changes on my cash

> flow plan and allocated spending plan worksheet.

> Here is how it works.

>   Cell B7 on my income worksheet contains my income.

> I need my income to be in cell c46 of my cash flow worksheet so I

> enter the formula =income!b7 in cell c46.

> I also need my income to be in cell d3 of myallocated spending plan

> worksheet so I enter the formula =income!b7 in cell d3.

> I hope that this helps.

> Paul

> 

> On May 9, 2018, at 8:14 PM, HH. Smith Jr. <josham129@...> wrote:

> 

> Hi,

> 

> What I mean is, when you make a change to one worksheet it affects all

> the worksheets in the given work sheet group or grouping sheets to

> make global changes in the workbook.

> 

> -----Original Message-----

> From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne

> Sent: Wednesday, May 9, 2018 8:11 PM

> To: main@jfw.groups.io

> Subject: Re: Grouping worksheets 2016

> 

> I'm not sure what you mean by grouping worksheets.  Yu can rename and

> reorder than using alt+h, then o, then r to rename and alt+h, then o,

> then

m

> to move them.

> At 06:40 PM 5/9/2018, you wrote:

> Hello fellow listerrs,

> 

> Does anyone has an easier way to group work sheets. I'm trying to make

> monthly workbook and I want to group all the months. Any help

> appreciated.

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> .

> 

> 

> 

> 

> 

I have the same settings as Bill, but since the last Windows update to

I have to manually start JAWS.
I'll be reporting this to Microsoft and VFO.
Richard




"The secret is not to make your music louder, but to make the world

- Mitch Albom from The Magic Strings of Frankie Presto, page 1

On May 11, 2018, at 11:21 AM, Sieghard Weitzel

Mine are basically the same except I don't usually check the "Start
Jaws

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
<main@jfw.groups.io<mailto:main@jfw.groups.io>> On Behalf Of Bill
White
Sent: Friday, May 11, 2018 9:06 AM
To: main@jfw.groups.io<mailto:main@jfw.groups.io>
Subject: Re: start jaws automatically after log in

Hi, Stan. Here's how I have my options in JAWS set for Start JAWS

Start JAWS at the Logon screen check box checked

Start JAWS after logon for all users check box checked

Start JAWS after logon for this user: Combo box Always

Bill White
billwhite92701@...<mailto:billwhite92701@...>

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Stan Holdeman
Sent: Friday, May 11, 2018 8:56 AM
To: jfw@groups.io<mailto:jfw@groups.io>
Subject: start jaws automatically after log in

I am running j2018 and windows 10.

Using the options/basics dialogue in j2018 I cannot get jaws to open

Appreciate your help.

Stan

I have the same settings as Bill, but since the last Windows update to

I have to manually start JAWS.
I'll be reporting this to Microsoft and VFO.
Richard




"The secret is not to make your music louder, but to make the world

- Mitch Albom from The Magic Strings of Frankie Presto, page 1

On May 11, 2018, at 11:21 AM, Sieghard Weitzel

Mine are basically the same except I don't usually check the "Start
Jaws

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
<main@jfw.groups.io<mailto:main@jfw.groups.io>> On Behalf Of Bill
White
Sent: Friday, May 11, 2018 9:06 AM
To: main@jfw.groups.io<mailto:main@jfw.groups.io>
Subject: Re: start jaws automatically after log in

Hi, Stan. Here's how I have my options in JAWS set for Start JAWS

Start JAWS at the Logon screen check box checked

Start JAWS after logon for all users check box checked

Start JAWS after logon for this user: Combo box Always

Bill White
billwhite92701@...<mailto:billwhite92701@...>

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Stan Holdeman
Sent: Friday, May 11, 2018 8:56 AM
To: jfw@groups.io<mailto:jfw@groups.io>
Subject: start jaws automatically after log in

I am running j2018 and windows 10.

Using the options/basics dialogue in j2018 I cannot get jaws to open

Appreciate your help.

Stan

I have the same settings as Bill, but since the last Windows update to

I have to manually start JAWS.
I'll be reporting this to Microsoft and VFO.
Richard




"The secret is not to make your music louder, but to make the world

- Mitch Albom from The Magic Strings of Frankie Presto, page 1

On May 11, 2018, at 11:21 AM, Sieghard Weitzel

Mine are basically the same except I don't usually check the "Start
Jaws

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
<main@jfw.groups.io<mailto:main@jfw.groups.io>> On Behalf Of Bill
White
Sent: Friday, May 11, 2018 9:06 AM
To: main@jfw.groups.io<mailto:main@jfw.groups.io>
Subject: Re: start jaws automatically after log in

Hi, Stan. Here's how I have my options in JAWS set for Start JAWS

Start JAWS at the Logon screen check box checked

Start JAWS after logon for all users check box checked

Start JAWS after logon for this user: Combo box Always

Bill White
billwhite92701@...<mailto:billwhite92701@...>

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Stan Holdeman
Sent: Friday, May 11, 2018 8:56 AM
To: jfw@groups.io<mailto:jfw@groups.io>
Subject: start jaws automatically after log in

I am running j2018 and windows 10.

Using the options/basics dialogue in j2018 I cannot get jaws to open

Appreciate your help.

Stan

You can group worksheets that are next to on another with a keyboard command:

• Focus on the First worksheet you’d like to group
• Press CTRL-SHIFT-PAGE DOWN to group the next worksheet
• Press CTRL-SHIFT-PAGE UP to group the previous worksheet

After focusing on the last worksheet you’d like to group, you’re done! The worksheets are grouped.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of HH. Smith Jr.
Sent: Thursday, May 10, 2018 5:08 PM
To: main@jfw.groups.io
Subject: Re: Grouping worksheets 2016

Hi guys,

Yes, you are all correct; however, if you want to make global changes such as, adding a heading, footnote, format change to all your worksheets by changing one sheet in the workbook is the concept I am talking about. I have no issues with linking a cell reference from one sheet to another. It is the global changes. If you Google, "grouping excel worksheets," you will see exactly what I am concern about. sorry for the mix-up in communication.

-----Original Message-----

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Chaffin

Sent: Thursday, May 10, 2018 1:23 PM

To: main@jfw.groups.io

Subject: Re: Grouping worksheets 2016

Yes, if a value referenced in a formula is moved to another cell, then the formula is automatically updated to the new location.

One note, when moving the value, use cut and paste, or it will not work.

Chris

> On May 10, 2018, at 10:30 AM, Mario <mrb620@...> wrote:

> 

> when using formulas as talked about here, can the following still be used:

> =income!$d$4

> 

> meaning the linking to the value in d4 will still be referenced even

> if the value has moved to d9 or e5?

> 

> 

> -------- Original Message --------

> From: Paul Hunt [mailto:prhunt1@...]

> Sent: Wednesday, May 9, 2018 10:08 PM EST

> To: main@jfw.groups.io

> Subject: Grouping worksheets 2016

> 

> Hello. The correct term is Linking.

> I have a budget workbook with an income worksheet, a cash flow

> worksheet and an allocated spending plan worksheet.

> When my income changes in my income worksheet, it changes on my cash

> flow plan and allocated spending plan worksheet.

> Here is how it works.

>   Cell B7 on my income worksheet contains my income.

> I need my income to be in cell c46 of my cash flow worksheet so I

> enter the formula =income!b7 in cell c46.

> I also need my income to be in cell d3 of myallocated spending plan

> worksheet so I enter the formula =income!b7 in cell d3.

> I hope that this helps.

> Paul

> 

> On May 9, 2018, at 8:14 PM, HH. Smith Jr. <josham129@...> wrote:

> 

> Hi,

> 

> What I mean is, when you make a change to one worksheet it affects all

> the worksheets in the given work sheet group or grouping sheets to

> make global changes in the workbook.

> 

> -----Original Message-----

> From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne

> Sent: Wednesday, May 9, 2018 8:11 PM

> To: main@jfw.groups.io

> Subject: Re: Grouping worksheets 2016

> 

> I'm not sure what you mean by grouping worksheets.  Yu can rename and

> reorder than using alt+h, then o, then r to rename and alt+h, then o,

> then

m

> to move them.

> At 06:40 PM 5/9/2018, you wrote:

> Hello fellow listerrs,

> 

> Does anyone has an easier way to group work sheets. I'm trying to make

> monthly workbook and I want to group all the months. Any help

> appreciated.

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> 

> .

> 

> 

> 

> 

> 

I have the same settings as Bill, but since the last Windows update to

I have to manually start JAWS.
I'll be reporting this to Microsoft and VFO.
Richard




"The secret is not to make your music louder, but to make the world

- Mitch Albom from The Magic Strings of Frankie Presto, page 1

On May 11, 2018, at 11:21 AM, Sieghard Weitzel

Mine are basically the same except I don't usually check the "Start Jaws

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
<main@jfw.groups.io<mailto:main@jfw.groups.io>> On Behalf Of Bill
White
Sent: Friday, May 11, 2018 9:06 AM
To: main@jfw.groups.io<mailto:main@jfw.groups.io>
Subject: Re: start jaws automatically after log in

Hi, Stan. Here's how I have my options in JAWS set for Start JAWS

Start JAWS at the Logon screen check box checked

Start JAWS after logon for all users check box checked

Start JAWS after logon for this user: Combo box Always

Bill White
billwhite92701@...<mailto:billwhite92701@...>

From: main@jfw.groups.io<mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Stan Holdeman
Sent: Friday, May 11, 2018 8:56 AM
To: jfw@groups.io<mailto:jfw@groups.io>
Subject: start jaws automatically after log in

I am running j2018 and windows 10.

Using the options/basics dialogue in j2018 I cannot get jaws to open

Appreciate your help.

Stan