Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Copy and lengthy paste

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DTTODGG - 11 Oct 2006 16:06 GMT
This must be a simple key stroke.

I work out a formula in H2 cell - it works! So I want to copy that to the
rest of that column. It's a long column, I don't even know how long unless I
do an "END".

Is there some key stroke that after you "copy" the first cell, you can
"paste" to the rest of the column? Not forever, just to the end of the column
of data?

Thanks.
gls858 - 11 Oct 2006 16:25 GMT
> This must be a simple key stroke.
>
[quoted text clipped - 7 lines]
>
> Thanks.

Highlight the cell with your formula. Double click the little black square
in the lower right hand corner. This will copy the formula down the entire
column.

gls858
DTTODGG - 11 Oct 2006 16:58 GMT
> > This must be a simple key stroke.
> >
[quoted text clipped - 13 lines]
>
> gls858

I knew, I knew it would be simple!
Thank-you, thank-you!
How much time I can now save!
gls858 - 11 Oct 2006 19:50 GMT
>>> This must be a simple key stroke.
>>>
[quoted text clipped - 16 lines]
> Thank-you, thank-you!
> How much time I can now save!

Glad to help. I use it all the time.
I gleaned that one from this group. I would give credit where
it's due but I can't remember who posted it. I'm sure it was
one of the "regulars".

gls858

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.