toggle quoted messageShow quoted text
This is really helpful information. I am going to find the webinar and learn how to do this because I know it will make working with some of these spreadsheets a lot easier.
email@example.com <firstname.lastname@example.org> On Behalf Of
Van Lant, Robin via Groups.IoSent:
Wednesday, December 11, 2019 3:54 PMTo:
Re: Entering data in an Excel form
I learned another related approach on a JAWS webinar. I think it was to “define name” of a cell, then you can go directly to it with Control G. I set this up for a large spreadsheet where I needed to quickly jump to a particular column.
There is a way to protect cells. What that will do, is only allow you to go from one input cell to another. I will have to brush up on how to do it and get back to you. However, a Google search for protecting cells would lead you in the right direction. I hope this helps you.
On Dec 10, 2019, at 9:54 PM, Norma A. Boge <naboge@...> wrote:
Let me clarify my initial post: I am able to edit the spreadsheet, no problems there. MS calls it a template, but it has a spreadsheet extension, XLS. Kinda confusing.
Here’s my question:
If I insert text into A3, isn’t there a keystroke to jump to the next cell that needs to be filled in? Something similar to tabbing to the next edit box in an online form?
I can edit and add and remove cell titles, etc. as I see fit. After that, I have the order form for my business. When it’s time for me to take the customer’s information and fill out the order form, how do I move through the form fields?
If this is still confusing, I’m ok with that. I’m probably using the incorrect verbiage to make my explanation clear. I have other options by which to save the information. Using a “template” seemed easy. Not so much, but I’m learning. <smile> Thanks, Norma
Norma, Since your invoice is a template, try Save As and save it as an Excel document,rename it then you should be able to fill it in. The template file is probably protected.
Love in Christ
For our struggle is not against flesh and blood, but against the rulers, against the powers, against the world forces of this darkness, against the spiritual forces of wickedness in the heavenly places.
Therefore, take up the full armor of God, so that you will be able to resist in the evil day, and having done everything, to stand firm.
Ephesians 6:12, 13
Sent: Tuesday, December 10, 2019 2:40 PM
Subject: Entering data in an Excel form
I’m using Jaws 2020 with Office 365. I downloaded an invoice template, but I can’t figure out how to complete the form. I think I should be able to enter data in the first field then go directly to the next field, enter data, and so on. Right now tabbing gets me to every cell, most of which are blank. I guess what I need is how to go into forms mode in Excel. I’m sure my answer is out there somewhere, so thanks in advance!
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.