How fill column quickly

[kevs]

Let say you have column with 2000 cells. The first 10 have your name, and
now you want full 2000 to have your name without having to do a manual drag.
Thanks!

Kevs


OS 10.4.7
Office 2004

 

[Ken Johnson]

Let say you have column with 2000 cells. The first 10 have your name, and
now you want full 2000 to have your name without having to do a manual drag.
Thanks!

Kevs


OS 10.4.7
Office 2004

Hi Kev,

Say your name is in A10...

1. Select A10
2. Press Ctrl + G to open the GoTo dialog
3. Type A2000 in the Reference: box
4. Press Shift + Return to select A10:A2000
5. Press Ctrl + D to copy your name into all of the selected cells.

Ken Johnson

 

[kevs]

When the Go To box comes up, there is OK, Cancel, and Special.
I Don't see a way to "shift return" to select where you are going to????????

Maybe someone can explain that a little better. Thanks. The part between 3
&4

Hi Kev,

Say your name is in A10...

1. Select A10
2. Press Ctrl + G to open the GoTo dialog
3. Type A2000 in the Reference: box
4. Press Shift + Return to select A10:A2000
5. Press Ctrl + D to copy your name into all of the selected cells.

Ken Johnson

OS 10.4.7
Office 2004

 

[kevs]

Retested -- does not work.

Shift return does not select anything from the go to box.

Hi Kev,

Say your name is in A10...

1. Select A10
2. Press Ctrl + G to open the GoTo dialog
3. Type A2000 in the Reference: box
4. Press Shift + Return to select A10:A2000
5. Press Ctrl + D to copy your name into all of the selected cells.

Ken Johnson

OS 10.4.7
Office 2004

 

[gimme_this_gimme_that]

Select the region you want to fill with data.
Make certain the top cell has the data value to be filed.
Make certain the bottom cell is where the fill stops.
Type Cntl-D.

 

[Paul Berkowitz]

You didn't experiment?

Say your name is in A10...

1. Select A10
2. Press Ctrl + G to open the GoTo dialog
3. Type A2000 in the Reference: box

4. Press Return (or click OK) to select A2000. Don't click anywhere.
5. Scroll up to the top.
6. Hold down Shift key, then click in A10. Now A10:A2000 is all selected.

5. Press Ctrl + D to copy your name into all of the selected cells.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[Ken Johnson]

Retested -- does not work.

Shift return does not select anything from the go to box.

That's the way it works on my iMac OS9...

After typing A2000 into the "Reference:" box on the GoTo dialog, I
don't use the mouse to click anything, I just hold down the Shift key
then press Return. The GoTo dialog disappears and Range A10:A2000 is
selected. Then I hold down the Ctrl key and press the D key to copy the
value in A10 into all of the selected cells.

Ken Johnson

 

[CyberTaz]

Another option -

Click the cell reference in the Name Box (left end of the Formula Bar)
Type A10:A2000 (or whatever the appropriate range ref is)
Press Return (to select the specified range)
Press Cmd+D (to Fill Down)

Alternatively you can copy the cell with the content, then select the range
as above & use Cmd+V to paste to the range.

BTW - Don't overlook the ShiftClick technique indicated by Paul B. - quite
useful in a number of ways.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs]

NO KEN IT DOES NOT WORK.

The go to box is up. I do shift return. All that happens is then the lower
cell is selected, not all the cells in-between which is needed.

Paul: your scroll tip is silly because that's what I'm trying avoid:
scrolling 2000 cells.

Cyber:
I think your is most efficient way.

Thanks all.



Kevs

That's the way it works on my iMac OS9...

After typing A2000 into the "Reference:" box on the GoTo dialog, I
don't use the mouse to click anything, I just hold down the Shift key
then press Return. The GoTo dialog disappears and Range A10:A2000 is
selected. Then I hold down the Ctrl key and press the D key to copy the
value in A10 into all of the selected cells.

Ken Johnson

OS 10.4.7
Office 2004

 

[Bernard Rey]

kevs :

NO KEN IT DOES NOT WORK.

The go to box is up. I do shift return. All that happens is then the lower
cell is selected, not all the cells in-between which is needed.

Paul: your scroll tip is silly because that's what I'm trying avoid:
scrolling 2000 cells.

I'd say Paul's method is right... provided you change it a little:

5. Hold the Ctrl key and the Shift, and press the "arrow up" Key, thus
selecting A10:A200

6. Press the return Key once, now you have range A10:A200 selected, and the
active cell is now A10


BtW: note that you don't NEED to use the "Ctrl-G" GoTo Box, you may as well
type in the A200 cell reference in the "Name field" and Press the Return key

 

[Ken Johnson]

NO KEN IT DOES NOT WORK.

The go to box is up. I do shift return. All that happens is then the lower
cell is selected, not all the cells in-between which is needed.

Paul: your scroll tip is silly because that's what I'm trying avoid:
scrolling 2000 cells.

Cyber:
I think your is most efficient way.

Thanks all.

Hi Kevs,

I guess they must have changed it in OSX.

I didn't go to OSX, most of my Office stuff doesn't work with it. PC
and OS9 Mac work fine for me. The Shift + Return (Enter) works on PC
too, so now I have another reason for steering clear of OSX.

Ken Johnson

 

[Paul Berkowitz]

am I right about the change from OS9 to OSX?

Shift + Return definitely works on my OS9 iMac and PC.

Yes, that must be it. (Or, really, Excel X and 2004 vs. Excel 2001 that you
must be using.) "kevs" has never said which version of Excel he's using,
which doesn't help too much.

Hardly a reason for staying stuck in the previous millennium. You'll be left
way behind, in all sorts of areas. For now, though, it sounds like you're
managing OK in OS 7 - excuse me, OS 9.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[Ken Johnson]

Hi Bernard,

am I right about the change from OS9 to OSX?

Shift + Return definitely works on my OS9 iMac and PC.

Ken Johnson

 

[Bernard Rey]

Ken Johnson :

Hi Bernard,

Hi Ken,

am I right about the change from OS9 to OSX?

Shift + Return definitely works on my OS9 iMac and PC.

Yes, Shift-Return with the "GoTo" dialog does work in Excel:2001 and doesn't
work in Excel or 2004.

There are many good reasons why one should make the move towards Mac OS X
But Excel can still be used in it's 2001 version, even if some new features
have been added and may be interesting (the "page layout" is the one I'd
certainly miss the most if I had to jump back to 2001).

My personal choice wouldn't be to stick with OS 9 for many reasons (and some
among them are good ones), but that depends upon one's habits and needs, so
it's up to you.

 

[Ken Johnson]

Hi Bernard and Paul,

Thanks for your comments.

My main gripe with Excel via OSX is I often move shapes around the
screen to demonstrate some simple scientific principles (high school
level). PC's and OS9 display smooth movement of the shapes, while OSX
requires that I continually wiggle the mouse. If the mouse is not
wiggled, all that OSX can show is initial shape positions, followed by
the hourglass cursor while the code executes, followed by the final
shape positions.

My son (high school age) insists I switch to Flash, which I hope to try
out next holiday.

Ken Johnson

 

[Paul Berkowitz]

My main gripe with Excel via OSX is I often move shapes around the
screen to demonstrate some simple scientific principles (high school
level). PC's and OS9 display smooth movement of the shapes, while OSX
requires that I continually wiggle the mouse. If the mouse is not
wiggled, all that OSX can show is initial shape positions, followed by
the hourglass cursor while the code executes, followed by the final
shape positions.

That's not OS X, or Office X/2004 per se, Ken. That indicates that you're
trying to run OS X on an older computer with insufficient power and RAM.
Greatly insufficient. Hopefully you can check it out soon on a newer
computer with lots of RAM. If anything, OS X, and the office apps, are
smoother than anything in OS 9.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[Ken Johnson]

That's not OS X, or Office X/2004 per se, Ken. That indicates that you're
trying to run OS X on an older computer with insufficient power and RAM.
Greatly insufficient. Hopefully you can check it out soon on a newer
computer with lots of RAM. If anything, OS X, and the office apps, are
smoother than anything in OS 9.

Hi Paul,

I'll do that and let you know, but I'm pretty sure it's due a change
that microsoft made to the way the Office apps work on Macs.

Ken Johnson

 

[kevs]

That was good Bernard. That definitely filled in what Ken J. left out.

Paul if you see my original post my signature does say OFFICE 2004.

Thanks, great info. All


Kevs

kevs :


I'd say Paul's method is right... provided you change it a little:


5. Hold the Ctrl key and the Shift, and press the "arrow up" Key, thus
selecting A10:A200

6. Press the return Key once, now you have range A10:A200 selected, and the
active cell is now A10



BtW: note that you don't NEED to use the "Ctrl-G" GoTo Box, you may as well
type in the A200 cell reference in the "Name field" and Press the Return key

OS 10.4.7
Office 2004

 

[CyberTaz]

Hi Ken -

FWIW - If this behavior was seen on an Intel Mac, that explains it - Office
isn't universal binary so it runs through Rosetta, which slows things down
considerably. OS X on a PPC (mine is a G5 dual 2 gig w/ 1.5 GB RAM) allows
Office '04 to run like a charm with none of the graphic gloom you describe.

<begin rant>

That's why I haven't 'bitten the bullet' for a Macbook Pro or whatever... I
love my Macs, but I'm sick of Apple's repeated bombardment of the market
with 'technology of the future' which they promptly abandon. I've spent too
much in the past for a "pig (promise) in a poke" such as:

SCSI - which promptly got scuttled in favor of Firewire/USB in the G5s after
I had dumped a bunch of bucks into outfitting my previous G4 w/interface,
expensive cables & SCSI devices which are now paperweights, and

My current G5 Dual Processor - one of which sits idle 95% of the time
because the promised software never materialized and *won't* now because the
adoption of Intel processors has cut me off at the knees once again.

<end of rant>

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Ken Johnson]

Hi Bob,

I'm not familiar with the processor details, all I know is the
behaviour I described occurs on eMacs that my school started using late
2003 and the iMacs that came out some time in 2004, the ones with the
skinny monitor and processor together supported by a bent metal foot.

Ken Johnson