Re: Excel Autofilling
- From: "Lorana" <loravara@xxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Sat, 19 Feb 2005 07:22:08 -0700
Thanks. That was exactly what I needed.
I even got to that point, but apparently, I never checked the button.
Worked fine first try.
----- Original Message -----
From: "john r vaughn" <jrvaughn44@xxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Saturday, February 19, 2005 6:17 AM
Subject: Re: Excel Autofilling
> Here is some text of a helpful hint from the old JFW lite list that may
help
> you out.
>
> John in sunny florida
>
> Excel is a spreadsheet developed by Microsoft. Excel is often used to
>
> record and perform calculations on financial data. You can create
workbooks
>
> and workbooks are made up of individual worksheets, just like a folder can
>
> have individual pages in it. A worksheet is the document where you enter
>
> the data. It has a series of columns and rows referred to as cells. For
>
> example A1 is the first cell in a worksheet. You enter your data into an
>
> individual cell.
>
>
>
> A neat trick with excel and autofill. Say that you wanted to have
headings
>
> of January through December in the first row of your worksheet. Just type
>
> in January in cell A1. Then hold down the shift key and use the right
arrow
>
> to move to cell L1. Now press alt e for the edit menu. Press i for the
>
> fill command. Press S for the series command. This brings up the series
>
> dialog. Press Alt-F to mark the AutoFill radio button. JFW announces,
"Type
>
> AutoFill Radio Button Checked." Press enter. Excel will automatically
fill
>
> in January through December for you and read it to you. Press home to
>
> return to the first cell
>
> and then right arrow to review the month in each cell that excel has
filled
>
> in for you. Excel will auto fill days of the week also and other things.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ----- Original Message -----
> From: "Lorana" <loravara@xxxxxxxxxxx>
> To: <jfw@xxxxxxxxxxxxx>
> Sent: Saturday, February 19, 2005 12:05 AM
> Subject: Excel Autofilling
>
>
> >I took a one day Excel class this week; unfortunately, the instructor was
a
> > mouse user, and didn't know how to describe the same techniques using
the
> > keyboard.
> >
> > I found most of them by just being an intrepid tester, but one eluded
me.
> >
> > I want to know how to autofill. Apparently, if I type January in one
> > cell,
> > Excel can fill in the rest of the names of the months; or, if I begin a
> > number sequence, Excel can identify the pattern and continue to fill.
> >
> > How would I accomplish this with the keyboard?
> >
> > Thanks.
> >
> > Lora
> >
> >
> > --
> > To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> > To unsubscribe from this mailing list, send a message to
> > jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> > Archives located at: //www.freelists.org/archives/jfw
> >
> > If you have any concerns about the list, post received from the list, or
> > the way the list is being run, do not post them to the list. Rather
> > contact the list owner at jfw-admins@xxxxxxxxxxxxxx
> >
>
>
> --
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> Archives located at: //www.freelists.org/archives/jfw
>
> If you have any concerns about the list, post received from the list, or
the way the list is being run, do not post them to the list. Rather contact
the list owner at jfw-admins@xxxxxxxxxxxxxx
--
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
