tag:blogger.com,1999:blog-9312877.post2909923983881333028..comments2014-04-15T23:18:07.459-07:00Comments on Excel Tips: Quickly Fill Multiple Cells with a Value or FormulaJon Wittwernoreply@blogger.comBlogger21125tag: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 ?prafulla patelhttp://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_87http://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 energyNicholashttp://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 manNicholashttp://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!Ricardohttp://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.comtag:blogger.com,1999:blog-9312877.post-68727562722570647202010-03-15T17:12:01.107-07:002010-03-15T17:12:01.107-07:00Legend Mate! I have been going crazy trying to wor...Legend Mate! I have been going crazy trying to work this out. Thank heaps!<br /><br />Nath<br />www.sikaudio.comsikaudiohttp://www.sikaudio.comnoreply@blogger.comtag:blogger.com,1999:blog-9312877.post-3269192992171444492009-07-11T06:09:55.560-07:002009-07-11T06:09:55.560-07:00Great!!
I was looking for that for a while.
Thank ...Great!!<br />I was looking for that for a while.<br />Thank you very much!<br />Raul.Raul Durandhttp://www.blogger.com/profile/03417426673915503070noreply@blogger.com