Re: Times in Excel


Adrian Spratt
 

How about turning it off? Ann gave you a masterful set of instructions.

-----Original Message-----
From: Jfw [mailto:jfw-bounces@...] On Behalf Of Apoorv
Kulkarni
Sent: Saturday, March 16, 2013 6:33 AM
To: 'The Jaws for Windows support list.'
Subject: RE: Times in Excel

Hello,

How do I use the autofill function with the virtual ribbon menu feature on?

-----Original Message-----
From: Jfw [mailto:jfw-bounces@...] On Behalf Of Ann Byrne
Sent: 16 March 2013 7:55
To: The Jaws for Windows support list.
Subject: Re: Times in Excel

In Excel 2010:

1. Place the first value--e.g., 9:15--in a1;
2. place the second value--9:30--in a2;
3. select the cells in column A starting with 9:15, going down to the
approximate end of your time list.
4. Press alt+h, then f, i, s. do not press enter.
5. In the resulting dialog, press the columns radio button.
6. Tab to the field that says 'linear, 1 of 4", and arrow down to
'autofill, 4 of 4". Do not fill in step value or stop value or trend.
7. Tab to Okay and press enter.

Autofill will derive the increase from a1 and a2.

Good luck!




_______________________________________________
Jfw mailing list
Jfw@...
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com


_______________________________________________
Jfw mailing list
Jfw@...
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

Join main@jfw.groups.io to automatically receive all group messages.