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]