 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Copy and lengthy paste
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. > 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 > > 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! >>> 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
|
Reply to this Message |
 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.