Re: Excel Autofilling
- From: "john r vaughn" <jrvaughn44@xxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Sat, 19 Feb 2005 08:17:10 -0500
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
Other related posts:
