RE: Copy one cell to entire column

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Blush!!

Well, Tom, for one thing, it's not vast, at least not compared to the MVPs &
near-MVPs who post here and who frequently and gently correct my public
errors. For another thing, there's a staggering amount of knowledge, tips, &
tricks available here in these newsgroups, free but for the cost of the time
it takes to scroll through some messages each day.


"Tom" wrote:

> Thanks, Duke!
> I never would have figured this one out!
> Where do you get your vast knowledge of little tricks in Excel?
> Tom
>
> "Duke Carey" wrote:
>
> > Assuming that column F has now blanks in it:
> >
> > Copy cell G2
> > Select cell F2
> > Press the End key followed by the down arrow
> > Move one cell to the right
> > Hold down the Shift key and press the End key followed by the up arrow
> > Paste
> >
> >
> > "Tom" wrote:
> >
> > > This seemingly very simply question has me baffled. I have a column of data
> > > that I need to perform an operation, something similar to '=f2-36161'.
> > > Column F has the data in numeric format. I add a column, say Column G. Then
> > > I put into G2 the '=f2-36161' and then convert this new number to a date
> > > formatted 'mm/dd/ccyy'. I'd like to replicate (copy/paste) this G2
> > > calculation and operation down through the entire Column G. [Column G is
> > > about 15000 rows deep.]
> > > Is there an easy way to do the copy/paste or replicate without copying G2
> > > and then copy/paste MANUALLY down the column until I reach the end of the
> > > data?
> > > Seems like a simply question but I can't find the 'key'.
> > > Thanks,
> > > Tom
.

Relevant Pages

  • RE: Copy one cell to entire column
    ... Tom ... "Duke Carey" wrote: ... > Select cell F2 ... > Hold down the Shift key and press the End key followed by the up arrow ...
    (microsoft.public.excel.misc)
  • RE: Copy one cell to entire column
    ... Assuming that column F has now blanks in it: ... Select cell F2 ... Hold down the Shift key and press the End key followed by the up arrow ... "Tom" wrote: ...
    (microsoft.public.excel.misc)
  • Re: tiny java web framework
    ... Rumor has it, though, that a vast, echoless complex exists beneath ...
    (comp.lang.java.programmer)
  • Re: American English vs. British English
    ... Tom P: ... media, I found on my first ever visit to the USA that there is a vast ... difference in everyday speech that has to be experienced first hand. ...
    (alt.usage.english)
  • Re: Pop-up list?
    ... What about the GROSS SCORE? ... to that cell but it gives me ... a big red line with an arrow. ... Tom ...
    (microsoft.public.excel.misc)