You can also do this manually by typing the item to be duplicated into one
cell. Then staying in that cell hit copy ctrl C. Then highlight the entire
row or column by holding the shift key while hitting end, then an arrow
key. For instance, if you want to copy into the whole column hold shift
while hitting end then down arrow. This highlights the column. Then hit
paste ctrl V. down. Personally I like this method better than any of the
auto fill methods as it is more reliable and you have complete control.

HTH
Bill


-----Original Message-----
From: Visually Impaired Computer Users' Group List
[mailto:[log in to unmask]] On Behalf Of Ana G
Sent: Wednesday, December 17, 2014 9: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]