Re: Times in Excel


Ann Byrne
 

Press alt to get to the home tab.
Down arrow to the edit submenu and open it with right arrow or enter.
Arrow to 'fill button, drop down' and press spacebar.
Arrow to series and press spacebar.

You are now in the fill dialog,.

At 05:33 AM 3/16/2013, you wrote:
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.