Subject: | |
From: | |
Reply To: | |
Date: | Wed, 17 Dec 2014 23:41:20 -0600 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
I'm not exactly sure what you're trying to do, but do you mean control+d
instead of alt+d? Control+d will copy what's in the cell above into the
current cell. Also, control+r will copy what's in the cell to the left
into the current cell.
On 12/17/2014 01:14 PM, Jim and Anne Murphy wrote:
> 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]
>
--
Christopher (CJ)
chaltain at Gmail
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]
|
|
|