Subject: | |
From: | |
Reply To: | |
Date: | Wed, 17 Dec 2014 08:04:28 -0800 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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]
|
|
|