tag:blogger.com,1999:blog-9312877.post2909923983881333028..comments2022-12-09T12:19:07.505-07:00Comments on Excel Tips: Quickly Fill Multiple Cells with a Value or FormulaJon Wittwerhttp://www.blogger.com/profile/04461947852006005549noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-9312877.post-80668445783481478272016-10-18T11:28:31.380-07:002016-10-18T11:28:31.380-07:00is there a way to just add a ; after each separate...is there a way to just add a ; after each separate cell and separate email without changing anything else? When I do what you suggest the ; is added but the last email is repeated within each cell. <br />Anonymoushttps://www.blogger.com/profile/09294191765840372097noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-87037391306601148852016-06-30T03:42:16.235-07:002016-06-30T03:42:16.235-07:00Absolute Hero. Someone get this man a medal.Absolute Hero. Someone get this man a medal.Kris Brownnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-25744339074852758182014-11-29T21:44:00.482-07:002014-11-29T21:44:00.482-07:00Thank you, it helped me alot todayThank you, it helped me alot todayAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-3468975582808984472014-11-06T12:22:13.268-07:002014-11-06T12:22:13.268-07:00Thank you! Amazing!Thank you! Amazing!Anonymoushttps://www.blogger.com/profile/01981325178277171544noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-89711692935641917572014-10-17T10:12:31.923-07:002014-10-17T10:12:31.923-07:00OMG i love you :D exactly what I neededOMG i love you :D exactly what I neededAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-85504254571663086652014-06-28T01:57:37.816-07:002014-06-28T01:57:37.816-07:00Thank you. My "excel copy contents of one cel...Thank you. My "excel copy contents of one cell to multiple cells" brought up this page and it was exactly what I needed. Saved a lot of time and effort copying a couple of basic items across three thousand rows. Life saver!<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-4607114715419214092014-03-03T01:54:26.875-07:002014-03-03T01:54:26.875-07:00To multiply all the various figures by 50% use cop...To multiply all the various figures by 50% use copy and paste special. First in your document type 50% in any cell. Then copy the 50%. Then highlight all the figures to be multiplied by 50%. Choose paste special, choose multiply and then OK.<br />Then delete the original 50%<br />Have a pleasant day <br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-45901162768052430522013-09-26T04:01:28.578-07:002013-09-26T04:01:28.578-07:00Hi I want to update excel rows as A1:A20 as 1, A21...Hi I want to update excel rows as A1:A20 as 1, A21:A40 as 2 .... what's the way out. Is there any formula for that<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-87425624234769422482013-03-04T06:27:18.051-07:002013-03-04T06:27:18.051-07:00helped a lot - MAXhelped a lot - MAXAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-28645213296624296182013-03-01T10:57:11.110-07:002013-03-01T10:57:11.110-07:00Thanks a lotThanks a lotKirti Raj Chaharnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-31434201490189417792013-01-20T04:06:27.780-07:002013-01-20T04:06:27.780-07:00Thank You. I was looking for this answer for a lon...Thank You. I was looking for this answer for a long time.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-41554074464363780572012-09-12T23:05:18.517-07:002012-09-12T23:05:18.517-07:00how about doing mathematical operations for values...how about doing mathematical operations for values with decimal number?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-63903790532705941792012-08-14T08:21:42.942-07:002012-08-14T08:21:42.942-07:00Thanks buddy! It's amazing!Thanks buddy! It's amazing!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-36792724800293171312012-08-10T21:15:56.747-07:002012-08-10T21:15:56.747-07:00how to copy texts of a all cells in col. A1 to a a...how to copy texts of a all cells in col. A1 to a another col.D. in different cells ?Anonymoushttps://www.blogger.com/profile/00187805739509048373noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-69022707590352697992012-08-08T22:43:27.738-07:002012-08-08T22:43:27.738-07:00great! thanksgreat! thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-5495211216222386592012-06-08T12:29:53.377-07:002012-06-08T12:29:53.377-07:00On my excel spreadsheet I have assorted dollar amo...On my excel spreadsheet I have assorted dollar amounts. I need to multiply each cell by 50%. How do I calcuate each cell at the same time?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-70550999494406002472011-11-09T16:42:28.049-07:002011-11-09T16:42:28.049-07:00thanks! very useful.thanks! very useful.dimitrios_87https://www.blogger.com/profile/12329977578154208174noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-46148531583324825922011-08-31T05:17:41.932-07:002011-08-31T05:17:41.932-07:00You just saved me 6.5 hours of hating my job and c...You just saved me 6.5 hours of hating my job and continually hitting F4, enter. Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-52752564630755777272011-08-25T05:40:56.869-07:002011-08-25T05:40:56.869-07:00Thank you so much. This is helping me a lot :)Thank you so much. This is helping me a lot :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-47313859635391028362011-07-19T16:26:51.349-07:002011-07-19T16:26:51.349-07:00thank you thank you thank you! i knew there was a...thank you thank you thank you! i knew there was a way to do this, but i couldn't remember it and was staring at my spreadsheet for ages...i don't think i would have figured this out on my own!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-52273905736718379632011-03-26T18:52:21.895-07:002011-03-26T18:52:21.895-07:00Thanks man - absolutely amazing - saved me a lot o...Thanks man - absolutely amazing - saved me a lot of time and energyUnknownhttps://www.blogger.com/profile/03302529262570682762noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-41850379746883567442011-03-26T18:51:28.730-07:002011-03-26T18:51:28.730-07:00Yo are amazing - thanks manYo are amazing - thanks manUnknownhttps://www.blogger.com/profile/03302529262570682762noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-6315006723311730372011-02-23T15:32:13.629-07:002011-02-23T15:32:13.629-07:00Very helpful, thanks so much!
I had over 110 valu...Very helpful, thanks so much!<br /><br />I had over 110 values in which I needed I find the natural log and inverse of to plot graphs of all three things. And I really didn't want to type in =LN(n) and 1/(n) for each of the over 110 cells!<br /><br />Thanks again, this saved me about an hour or so!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-35061933917630894832010-05-31T13:19:18.816-07:002010-05-31T13:19:18.816-07:00Really, really nice!Really, really nice!Unknownhttps://www.blogger.com/profile/11832007580288875515noreply@blogger.comtag:blogger.com,1999:blog-9312877.post-20968208864368762562010-05-02T14:38:49.933-07:002010-05-02T14:38:49.933-07:00Oh !!! so simple and so helpful !!! 10x !Oh !!! so simple and so helpful !!! 10x !LeAnoreply@blogger.com