moderated
Re: Excel rows and columns
Russell Solowoniuk
Hi Sieghard,
toggle quoted messageShow quoted text
Yes, if you go to Save As and save the workbook with a new name, the defined cell names are saved to the new workbook. I wonder if you go to "Name Manager", under the Formula tab, press CTRL+ right arrow and you should land on "Name Manager", and from there delete any names you have defined, and then define all your cell names again? I wonder if there are names defined already that might be causing things not to work as they ought to? Cheers, Russell
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel Sent: Sunday, June 9, 2019 9:15 AM To: main@jfw.groups.io Subject: Re: Excel rows and columns I assume if I could get it to work for the template I made and then as you said use F12 to save the Excel file with a different name that the name definitions should also be saved in the new file. -----Original Message----- From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne Sent: Sunday, June 9, 2019 8:13 AM To: main@jfw.groups.io Subject: Re: Excel rows and columns If you use save-as for the new sheets, it works. At 09:37 AM 6/9/2019, you wrote: Hi Sieghard,
|
|
moderated
Re: Inserting Rows in an existing Excel Sheet
I find the easiest shortcut for inserting new rows and columns is Control + NumPad Plus, it will ask you if you want to insert a new row or a new column, Insert + NumPad Minus allows you to delete a column or row.
toggle quoted messageShow quoted text
As for copying, all you have to do is press Control + C on a cell containing a formula.
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of George Gray Sent: Sunday, June 9, 2019 8:22 AM To: main@jfw.groups.io Subject: Inserting Rows in an existing Excel Sheet Hola! I am using the latest versions of Win10 and Office (not 365) on my DeskTop and I have a couple of questions, if I may: 1. How can I Insert a new vertical Column between the existing horizontal Rows, 2. How can I Copy and then Edit the existing Formulas? I knew how to accomplish these actions within the old Excel program, but cannot figure it out with the Ribbons. I know how to navigate the Ribbons to some degree, but can't identify the Insert New Column and Edit Formulas items. Thanks in advance. -- HAVE A MAGNIFICENT DAY GEORGE BURRELL GRAY Ocean Winds Cabarete/Sosua REPUBLICA DOMINICANA
|
|
moderated
Inserting Rows in an existing Excel Sheet
George Gray
Hola!
I am using the latest versions of Win10 and Office (not 365) on my DeskTop and I have a couple of questions, if I may: 1. How can I Insert a new vertical Column between the existing horizontal Rows, 2. How can I Copy and then Edit the existing Formulas? I knew how to accomplish these actions within the old Excel program, but cannot figure it out with the Ribbons. I know how to navigate the Ribbons to some degree, but can't identify the Insert New Column and Edit Formulas items. Thanks in advance. -- HAVE A MAGNIFICENT DAY GEORGE BURRELL GRAY Ocean Winds Cabarete/Sosua REPUBLICA DOMINICANA
|
|
moderated
Re: Excel rows and columns
I assume if I could get it to work for the template I made and then as you said use F12 to save the Excel file with a different name that the name definitions should also be saved in the new file.
toggle quoted messageShow quoted text
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne Sent: Sunday, June 9, 2019 8:13 AM To: main@jfw.groups.io Subject: Re: Excel rows and columns If you use save-as for the new sheets, it works. At 09:37 AM 6/9/2019, you wrote: Hi Sieghard,
|
|
moderated
Re: Excel rows and columns
First I have to get it to work in the first place. For some reason I can’t get automatic readings of row and column headings to work using this method at all. I already have a template of this workbook set up and I usually just open it each time a new month starts and then use F12 to save it but giving it the name of the month. For example, my template is Sales Summary and I then save it, for example, as Sales Summary June 2019. I wouldn’t mind setting up the row and column title reading on each sheet separately if I could just get it to work.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of
Russell Solowoniuk
Sent: Sunday, June 9, 2019 7:38 AM To: main@jfw.groups.io Subject: Re: Excel rows and columns
Hi Sieghard,
I’m not able to set this up by defining a name on a worksheet and then copying that sheet multiple times. Even if I set the scope to the worksheet rather than the workbook, Jaws doesn’t read column or row headings on the next sheets.
What you want can be done easily manually by first creating copies of your first sheet 31 times, one sheet for each day of the month. Then, place your cursor in the cell of the first sheet where you want to define the name, press the applications key, up arrow to “Define name…” and press enter. Type “Title” if you wish both column and row headings to be read by Jaws and press enter. Now, move to sheet two and do the same, except this time type “Title2” as the name. Continue doing this on subsequent sheets, each time increasing the number after “Title”. Note that there is no space between “Title” and the number.
Not sure if this helps or if you wanted a more automatic method, but I can’t seem to do it any other way. I even tried grouping the sheets and then defining a name, but this doesn’t work.
Cheers,
Russell
From: main@jfw.groups.io <main@jfw.groups.io>
On Behalf Of Sieghard Weitzel
Hi Brian,
I attached a little sample spreadsheet I made. I thought I followed your steps to set it up so Jaws will read the column and row titles, but I can’t get it to work, what am I doing wrong?
Sieghard
From: main@jfw.groups.io <main@jfw.groups.io>
On Behalf Of Brian Vogel
Pardon my error, that last technique is the "when I only want it during this session" method with JAWS. This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet: Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader. To add column and row title names:
i. Open the Formula ribbon (ALT-M) ii. Activate the “Define Name” command (M) iii. Within the drop-down list, activate “Define Name” iv. The “New Name” dialog opens
Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:
i. Start the range name with the label that tells Excel you’re creating a title range
ii. Add a name for the range
iii. Optional - Add the last cell in the range preceded by two periods
The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:
You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name The last field references the cell name or range of selected cells you’re naming. You can leave this field alone. Activate the OK button to save the name and close the dialog. Save the workbook and the titles are permanently saved and will work on any computer. If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings. -- Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall
|
|
moderated
Re: Excel rows and columns
Ann Byrne
If you use save-as for the new sheets, it works.
toggle quoted messageShow quoted text
At 09:37 AM 6/9/2019, you wrote:
Hi Sieghard,
|
|
moderated
Re: Excel rows and columns
Russell Solowoniuk
Hi Sieghard,
I’m not able to set this up by defining a name on a worksheet and then copying that sheet multiple times. Even if I set the scope to the worksheet rather than the workbook, Jaws doesn’t read column or row headings on the next sheets.
What you want can be done easily manually by first creating copies of your first sheet 31 times, one sheet for each day of the month. Then, place your cursor in the cell of the first sheet where you want to define the name, press the applications key, up arrow to “Define name…” and press enter. Type “Title” if you wish both column and row headings to be read by Jaws and press enter. Now, move to sheet two and do the same, except this time type “Title2” as the name. Continue doing this on subsequent sheets, each time increasing the number after “Title”. Note that there is no space between “Title” and the number.
Not sure if this helps or if you wanted a more automatic method, but I can’t seem to do it any other way. I even tried grouping the sheets and then defining a name, but this doesn’t work.
Cheers,
Russell
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Friday, June 7, 2019 12:08 AM To: main@jfw.groups.io Subject: Re: Excel rows and columns
Hi Brian,
I attached a little sample spreadsheet I made. I thought I followed your steps to set it up so Jaws will read the column and row titles, but I can’t get it to work, what am I doing wrong?
Sieghard
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Pardon my error, that last technique is the "when I only want it during this session" method with JAWS. This is how to set them in the spreadsheet itself such that JAWS will recognize their existence and announce them whenever you open a specific spreadsheet: Assigning a Title Row (Column Titles) and/or Title Column (Row Titles) in Excel You can assign column and row titles in Excel. These are nice because they always work with Excel and are saved to the workbook. There's no risk of losing a setting in your screen reader. To add column and row title names:
i. Open the Formula ribbon (ALT-M) ii. Activate the “Define Name” command (M) iii. Within the drop-down list, activate “Define Name” iv. The “New Name” dialog opens
Focus is placed in the name field. Within the name field, you can name the focused cell or selected range of cells. In this case, we’re naming the column or row title:
i. Start the range name with the label that tells Excel you’re creating a title range
ii. Add a name for the range
iii. Optional - Add the last cell in the range preceded by two periods
The next field in the dialog sets the scope for the name. this is a combo box. Use UP and DOWN ARROW to choose from between:
You can add a comment for the named cell or region, this is strictly for your personal reference and doesn’t affect the echo of the column or row title name The last field references the cell name or range of selected cells you’re naming. You can leave this field alone. Activate the OK button to save the name and close the dialog. Save the workbook and the titles are permanently saved and will work on any computer. If you have titles set to echo in JAWS, the titles will echo and you won’t lose the settings. -- Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall
|
|
moderated
Re: Help with printing one page of multiple pages
Ed Legge <edward.legge@...>
“Try highlighting the page you want to print and do the ctrl/p.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Laura Richardson
Sent: Saturday, June 8, 2019 10:41 AM To: main@jfw.groups.io Subject: Re: Help with printing one page of multiple pages
How do I get to the drop down box?
Laura
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
As Rick has indicated, if the page you want to print happens to be the one you currently are looking at in Word (or pretty much any program, it works the same in PDF readers and other programs, too). Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall
|
|
moderated
Re: Help with printing one page of multiple pages/Problem solved
Laura Richardson
I got it …… After I placed myself on the page I wanted to print, I pressed control p and started tabbing through …… I found it where it said “settings group box print what? Combo box use the arrow keys to make a selection”. I pressed alt and down arrow to open the combo box where it then gave me choices of all pages, current page, etc. BTW; I also was able to make my choice by just arrowing down (not pressing alt down arrow to open a combo box.
Thanks for the help.
Laura
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
On Sat, Jun 8, 2019 at 11:40 AM, Laura Richardson wrote:
I'm currently using NVDA, but all I do is tab to it. It announces "Settings Grouping" then that I'm on the combo box (what I called a dropdown, because if you can't enter text into it it's really not a combo box), and I can either hit spacebar or enter to make it open to select what I want. Then I navigate back to the Print button and hit it (or, hit ALT+F,P,P from wherever you happen to be to activate it without having to navigate back). Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall
|
|
moderated
Re: problem with crome and staying loggin in
What Chrome Extensions do you have installed? It sounds like some sort of privacy related extension is deleting all your cookies upon exiting Chrome, and Chrome does not support this by default. Either that, or you're firing up Chrome in incognito mode (which takes some very intentional doing) in which case nothing is preserved when the incognito session is closed.
-- Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall
|
|
moderated
Re: Help with printing one page of multiple pages
On Sat, Jun 8, 2019 at 11:40 AM, Laura Richardson wrote:
How do I get to the drop down box?I'm currently using NVDA, but all I do is tab to it. It announces "Settings Grouping" then that I'm on the combo box (what I called a dropdown, because if you can't enter text into it it's really not a combo box), and I can either hit spacebar or enter to make it open to select what I want. Then I navigate back to the Print button and hit it (or, hit ALT+F,P,P from wherever you happen to be to activate it without having to navigate back). I also have the screen reader announcing the keyboard shortcut sequence to achieve the same thing without having to navigate to that dropdown, but you'd have to get there once to hear it. ALT+F,P,A shoots you straight to the dropdown, which is expanded when you land on it, and you can select current page. ALT+F,P,S takes you straight to the select page range edit box, where you can enter a page number, series of numbers, series of ranges, or any combination thereof. Office 365 is built principally upon Office 2016 as its baseline, with a bit of 2019 thrown in. There should be no significant differences in the File Tab between the three, which is where all this stuff is controlled. -- Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall
|
|
moderated
Re: Help with printing one page of multiple pages
Laura Richardson
How do I get to the drop down box?
Laura
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
As Rick has indicated, if the page you want to print happens to be the one you currently are looking at in Word (or pretty much any program, it works the same in PDF readers and other programs, too). Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall
|
|
moderated
Re: Help with printing one page of multiple pages
Laura Richardson
After I pressed control P I then tabbed until I heard it say “current page” (I was on the page I wanted to print) but it printed the entire document.
Laura
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Rick Mladek
Sent: Saturday, June 8, 2019 9:45 AM To: main@jfw.groups.io Subject: Re: Help with printing one page of multiple pages
Hi,
When you hit control p to print, tab down until you hear print current page and hit enter. Be sure you are on the page you want printed.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Laura Richardson
Hello,
I have a multi-page document that I need to print just one page. Example; I need to print just page 4 of the 10 page document. I generally press control plus p and press enter which prints the entire 10 page document and I can’t figure out how to print just one page, not the entire document.
I’m using Jaws 18, HP laser jet printer, Word 2016 and Windows 10. Could somebody please help?
Laura
|
|
moderated
Re: problem with crome and staying loggin in
Ashleigh Piccinino
You might want to contact Jim Fettgather on this issue. He probably is subscribe to this group, so he’ll be better able to help you then I will.
toggle quoted messageShow quoted text
On Jun 4, 2019, at 9:25 PM, John Covici <covici@ccs.covici.com> wrote:
|
|
moderated
Re: Finding my list of friends in Facebook?
Ashleigh Piccinino
Hello Tim,
If no one else has suggested this yet, try the following. 1. Please open the Facebook Mobile app.
2. After logging into your account, go to the friends tab. If you're using an iPhone, this tab is the second tab from the bottom left of your screen.
3. After double-tapping on friends, swipe rightwards upon knowing you're at the begining of the screen.
4. Go to "find friends" and double-tap.
5. On that screen, make sure that friends is selected instead of the apparent default, suggestions. Hope this helps!
thank you for your question,
Ashleigh Piccinino
On Jun 4, 2019, at 12:45 PM, Marty Hutchings <mhutchings@...> wrote:
|
|
moderated
Re: Help with printing one page of multiple pages
Rick Mladek
Now you lead me to a question lol. Is 2016 and 2019 more the same or is 2019 more like 365?
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
As Rick has indicated, if the page you want to print happens to be the one you currently are looking at in Word (or pretty much any program, it works the same in PDF readers and other programs, too). Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall
|
|
moderated
Re: Help with printing one page of multiple pages
As Rick has indicated, if the page you want to print happens to be the one you currently are looking at in Word (or pretty much any program, it works the same in PDF readers and other programs, too).
Things did change in the Word 2016 print dialog, though. At one time the "current page," "all pages," and "page range" options were presented as radio buttons, where if you used the page range option you then had to enter something like 2-7 if you wanted pages 2 through 7 of the current document to print. In Word 2016, there is now a dropdown box, the first one in the settings section, that allows you to pick full document (Print all pages, the default), current page, or specific pages (page range). You must use the dropdown if you want to choose current page and don't know or don't want to check the current page number, but if you want a page range, immediately under that dropdown is an edit box for pages, where you can enter a single page, e.g., 7, a contiguous page range, e.g. 2-5, or a combination of both, e.g. 3,7-11,14,19-25. If you enter anything in that box it automatically switches the dropdown to reflect specific pages. The dropdown box also allows you to print out certain properties associated with your document, rather than document pages. You can review what those are if you expand the dropdown. -- Brian - Windows 10 Pro, 64-Bit, Version 1809, Build 17763 Here is a test to find out whether your mission in life is complete. If you’re alive, it isn’t. ~ Lauren Bacall
|
|
moderated
Re: How to get to a YouTube Skip Ads popup?
Once you searched for something the way Rick described there is a much easier way to search again, simply press F3.
toggle quoted messageShow quoted text
The very first time you use Jaws search pressing F3 actually should give you the same result as Jaws Key + Control + F which his to bring up the following: JAWS Find dialog Find what: edit combo Type in your search term and press enter, then, as I said, simply press F3 to search for the same search term again, if you want to search for something else then you have to press Jaws Key + Control + F.
-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Rick Mladek Sent: Saturday, June 8, 2019 6:43 AM To: main@jfw.groups.io Subject: Re: How to get to a YouTube Skip Ads popup? Hi, Simple search for skip. Insert +control +f. type in skip and hit enter. The first skip will be found. Be sure it says skip add. Otherwise, do the search as noted again. When you hear skip ad, hit enter and the said ad is done. You can also continuously hit the b key and when yu hear skip ad, hit enter. This will be easier but with so many buttons, you could be hitting this and the ad may end before you find the correct button to skip the ad. -----Original Message----- From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of David Pearson Sent: Saturday, June 8, 2019 9:26 AM To: main@jfw.groups.io Subject: Re: How to get to a YouTube Skip Ads popup? Hi all: What is the key sequence for Jaws "skip ad" that is mentioned in this post. Sincerely, David S. Pearson
|
|
moderated
Re: Help with printing one page of multiple pages
Rick Mladek
Hi,
When you hit control p to print, tab down until you hear print current page and hit enter. Be sure you are on the page you want printed.
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Laura Richardson
Sent: Saturday, June 8, 2019 10:37 AM To: jfw@groups.io Subject: Help with printing one page of multiple pages
Hello,
I have a multi-page document that I need to print just one page. Example; I need to print just page 4 of the 10 page document. I generally press control plus p and press enter which prints the entire 10 page document and I can’t figure out how to print just one page, not the entire document.
I’m using Jaws 18, HP laser jet printer, Word 2016 and Windows 10. Could somebody please help?
Laura
|
|
moderated
Help with printing one page of multiple pages
Laura Richardson
Hello,
I have a multi-page document that I need to print just one page. Example; I need to print just page 4 of the 10 page document. I generally press control plus p and press enter which prints the entire 10 page document and I can’t figure out how to print just one page, not the entire document.
I’m using Jaws 18, HP laser jet printer, Word 2016 and Windows 10. Could somebody please help?
Laura
|
|