Ok
I know this one
Once putt he datea in the cell you are in
Arrow down to the cell below
Just do a alt D and there you can
Youcan do this each each cell
HTH


-----Original Message-----
From: Visually Impaired Computer Users' Group List
[mailto:[log in to unmask]] On Behalf Of Ana G
Sent: Wednesday, December 17, 2014 10:04 AM
To: [log in to unmask]
Subject: [VICUG-L] Auto Fill in Excel 2013

Hi All,

How do you quickly put the same value in all of the cells of a column or row
in Excel?

I'm submitting grades for my classes. On one of my campuses, I also need to
submit a spreadsheet that shows attendance: p for present, a for absent, x
for holidays. Rather than manually typing all of this for every student as I
do every semester, I'd like to use the auto fill feature.

I've found two sets of instructions for doing this. One says I can use 
ctrl+d or ctrl+r to duplicate information from the adjacent cell above
or to the left. The other says I can highlight the row or column, go into
the Home tab, and select the appropriate option from the edit group; I don't
remember the key sequence off hand.

I've tried both methods, but only one additional cell gets filled, not the
entire row or column.

Any suggestions? I'm using Windows 8.1 and Office 2013.

Ciao


    VICUG-L is the Visually Impaired Computer User Group List.
Archived on the World Wide Web at
    http://listserv.icors.org/archives/vicug-l.html
    Signoff: [log in to unmask]
    Subscribe: [log in to unmask]


    VICUG-L is the Visually Impaired Computer User Group List.
Archived on the World Wide Web at
    http://listserv.icors.org/archives/vicug-l.html
    Signoff: [log in to unmask]
    Subscribe: [log in to unmask]