Quickly update formulas, you mentioned moving the formula and related data to its own sheet prior to FIND REPLACE. If you only select a single cell where the formula is located, C2, and do a FIND, you are correct, the entire worksheet will be updated when you only want a single formula updated in C2. I believe that if you select more than a single cell, as an example, A2:C2, only the selected cells will be manipulated by the FIND REPLACE and only C2 has a formula so no danger of updating the entire worksheet multitude of formulas. Thanks so much for all your great videos.
You just help me so simply! I'm learning Excel for work and someone asked me how to do this and I was lost. Messed up my productivity tracker really badly. Now I can at least empty cells without removing the formatting. Thank you for saving my sanity!
Excel sheet start malfunctioning when we enter data in more than 50 lakh rows aprox. Means per excel sheet don't have capacity to contain more than 50 lakhs rows aprox. data. Now the question is how to remove duplicates in excel if data is in different excel workbooks and the total rows in all excel workbooks are more than 20 crore. Can any body provide solution?
Quickly update formulas, you mentioned moving the formula and related data to its own sheet prior to FIND REPLACE. If you only select a single cell where the formula is located, C2, and do a FIND, you are correct, the entire worksheet will be updated when you only want a single formula updated in C2. I believe that if you select more than a single cell, as an example, A2:C2, only the selected cells will be manipulated by the FIND REPLACE and only C2 has a formula so no danger of updating the entire worksheet multitude of formulas. Thanks so much for all your great videos.
You just help me so simply! I'm learning Excel for work and someone asked me how to do this and I was lost. Messed up my productivity tracker really badly. Now I can at least empty cells without removing the formatting. Thank you for saving my sanity!
Great learning. Please continue what you're doing. I have started loving to work on excel after watching your videos. Thanks.
all action, no fluff = great video. Thanks
Thank u for imparting knowledge that i don't had about excel.
You're welcome :)
Short & sweetly explained
Thanks :)
Sir will CTRL+Shift+Key select till end of data including blanks which might bf in-between
Excel sheet start malfunctioning when we enter data in more than 50 lakh rows aprox. Means per excel sheet don't have capacity to contain more than 50 lakhs rows aprox. data. Now the question is how to remove duplicates in excel if data is in different excel workbooks and the total rows in all excel workbooks are more than 20 crore. Can any body provide solution?
I enjoyed watching it and learning!! Thanks!!
You're welcome! Glad to help :)
Great video, Thanks.
:)
Hi u r doing a great job 👍 keep it up buddy
Thanks! I appreciate the support :)
Dynamic MIS Report in excel
Alt+E S M interesting ✨👏
I really love all of the Alt+E+S... shortcuts. Learn them, love them, and save half a day lol.