Help!

Keyboard shortcut for autofill

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  Formula - help 3  
Author Message
Russ
External


Since: Oct 14, 2003
Posts: 1



PostPosted: Tue Oct 14, 2003 1:28 pm    Post subject: Keyboard shortcut for autofill
Archived from groups: microsoft>public>excel>newusers (more info?)

I believe this is kind of a newbie question ....

I know how to use autofill. However, I also know that
there is a series of keyboard shortcuts by which you can
use autofill, too, but I cannot find info about this
anywhere.

I am familiar with using <shift> and/or <control> with
either <Page UP/Page Down> or <Up/Down arrow>, but I have
not yet figured out the correct combination of these that
will allow me to autofill without using the mouse.

In case you're curious, I am working with *thousands* of
entries, and it would be much, much easier to work with
the keyboard shortcuts than with the mouse, in this case.

Thanks very much in advance!

-Russ
Back to top
Peo Sjoblom
External


Since: Oct 06, 2003
Posts: 118



PostPosted: Tue Oct 14, 2003 5:40 pm    Post subject: Re: Keyboard shortcut for autofill [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Shift + down arrow select one cell at a time, shift + page down select a
page, ctrl + shift & down arrow select all to the end. Now to fill down with
the same value as in the first cell is
ctrl + d, to get 1, 2 and so on put 1 in the first 2 in the second, then
select as far you want it, then do
alt + e, i, s, then tab until you get to the to the type, then tap down
arrow until you get to autofill.
To fill a formula just select as far you want it and do ctrl + d
(ctrl + r for filling rows to the right)

to autofill values (as in 1,2 etc) is probably best to record a macro and
attach it to a shortcut

--

Regards,

Peo Sjoblom


"Russ" wrote in message

 > I believe this is kind of a newbie question ....
 >
 > I know how to use autofill. However, I also know that
 > there is a series of keyboard shortcuts by which you can
 > use autofill, too, but I cannot find info about this
 > anywhere.
 >
 > I am familiar with using <shift> and/or <control> with
 > either <Page UP/Page Down> or <Up/Down arrow>, but I have
 > not yet figured out the correct combination of these that
 > will allow me to autofill without using the mouse.
 >
 > In case you're curious, I am working with *thousands* of
 > entries, and it would be much, much easier to work with
 > the keyboard shortcuts than with the mouse, in this case.
 >
 > Thanks very much in advance!
 >
 > -Russ
Back to top
David McRitchie
External


Since: Aug 24, 2003
Posts: 682



PostPosted: Wed Oct 15, 2003 4:16 pm    Post subject: Re: Keyboard shortcut for autofill [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Sounds more like you need to work with macros if you have to
work with thousands of entries.

If you want to do exactly the same thing on
several sheets you can group your sheets, do your
thing then you must ungroup the sheets or you start destroying
your work by continuing to make changes to all the grouped sheets.
Group by selecting a sheet and using Ctrl to add more, or SHIFT to
add inclusively back to the last selected. To ungroup right-click
on sheet tab or pick an unselected sheet.

Some help in finding Excel shortcut keys by having them listed in
one place. http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Doing things without the mouse is increasingly difficult as things
are made easier. How did you make a selection in the first place
that you wanted to use autofill shortcut keys on.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Peo Sjoblom" wrote in message
 > Shift + down arrow select one cell at a time, shift + page down select a
 > page, ctrl + shift & down arrow select all to the end. Now to fill down with
 > the same value as in the first cell is
 > ctrl + d, to get 1, 2 and so on put 1 in the first 2 in the second, then
 > select as far you want it, then do
 > alt + e, i, s, then tab until you get to the to the type, then tap down
 > arrow until you get to autofill.
 > To fill a formula just select as far you want it and do ctrl + d
 > (ctrl + r for filling rows to the right)
 >
 > to autofill values (as in 1,2 etc) is probably best to record a macro and
 > attach it to a shortcut
 >
 > --
 >
 > Regards,
 >
 > Peo Sjoblom
 >
 >


  > > I believe this is kind of a newbie question ....
  > >
  > > I know how to use autofill. However, I also know that
  > > there is a series of keyboard shortcuts by which you can
  > > use autofill, too, but I cannot find info about this
  > > anywhere.
  > >
  > > I am familiar with using <shift> and/or <control> with
  > > either <Page UP/Page Down> or <Up/Down arrow>, but I have
  > > not yet figured out the correct combination of these that
  > > will allow me to autofill without using the mouse.
  > >
  > > In case you're curious, I am working with *thousands* of
  > > entries, and it would be much, much easier to work with
  > > the keyboard shortcuts than with the mouse, in this case.
  > >
  > > Thanks very much in advance!
  > >
  > > -Russ
 >
 >
Back to top
Juho Aapro
External


Since: Oct 16, 2003
Posts: 1



PostPosted: Thu Oct 16, 2003 3:12 pm    Post subject: Keyboard shortcut for autofill [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I think that there is now shortcut for autofill, make
correct if I'm wrong!

Juho Aapro


 >-----Original Message-----
 >I believe this is kind of a newbie question ....
 >
 >I know how to use autofill. However, I also know that
 >there is a series of keyboard shortcuts by which you can
 >use autofill, too, but I cannot find info about this
 >anywhere.
 >
 >I am familiar with using <shift> and/or <control> with
 >either <Page UP/Page Down> or <Up/Down arrow>, but I have
 >not yet figured out the correct combination of these that
 >will allow me to autofill without using the mouse.
 >
 >In case you're curious, I am working with *thousands* of
 >entries, and it would be much, much easier to work with
 >the keyboard shortcuts than with the mouse, in this case.
 >
 >Thanks very much in advance!
 >
 >-Russ
 >.
 >
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum