tag:blogger.com,1999:blog-56169828695707537212024-03-11T21:49:11.063+05:30Excel Mirror - We Push Your Boundaries<b><u>MS-Excel Expert</u></b><br>
For Excel Training and Automated Tools, Please contact Vishesh Golya on visheshgolya@gmail.com or +91-98289-88829Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.comBlogger179125tag:blogger.com,1999:blog-5616982869570753721.post-75230299735486067182023-10-08T18:00:00.001+05:302023-10-08T18:00:00.131+05:30Mastering ChatGPT: 15 Tips for Effective Usage and Better ResultsChatGPT is a powerful AI tool that can assist you in various tasks, from answering questions to generating content. However, to make the most of it and ensure you get the results you desire, it's essential to master its usage. In this post, we'll share 15 tips to help you effectively use ChatGPT and achieve better outcomes.<p><strong>15 Tips for Effective Usage:</strong></p><p><strong>1. Start with a Clear Prompt:</strong>
Begin your interaction with ChatGPT by providing a clear and specific prompt or question. This helps ChatGPT understand your intent and context, leading to more accurate responses.</p><p><strong>2. Experiment with Prompting:</strong>
If you're not getting the desired response, don't hesitate to experiment with different phrasings or structures in your prompt. Sometimes, a slight change in wording can yield significantly better results.</p><p><strong>3. Use System Messages:</strong>
Utilize system messages like "/system" to gently instruct ChatGPT on how you want it to behave. For instance, you can say, "/system Please provide a detailed explanation," to guide its response.</p><p><strong>4. Specify the Format:</strong>
If you need a response in a specific format, such as bullet points, a summary, or step-by-step instructions, be explicit in your request. This helps ChatGPT tailor its response accordingly.</p><p><strong>5. Ask Follow-Up Questions:</strong>
When ChatGPT provides an almost-perfect response, don't hesitate to ask follow-up questions to clarify or expand on the information provided. This helps you refine the information you receive.</p><p><strong>6. Provide Context:</strong>
If your question relies on specific background information or context, include that information in your prompt. This allows ChatGPT to generate more accurate and relevant responses.</p><p><strong>7. Be Patient:</strong>
Understand that ChatGPT may not always provide the perfect answer on the first try. Be patient, and consider having a back-and-forth conversation to improve the quality of information you receive.</p><p><strong>8. Fact-Check:</strong>
While ChatGPT is knowledgeable, it's not infallible. For critical information, consider fact-checking its responses from trusted sources to ensure accuracy.</p><p><strong>9. Avoid Bias and Controversy:</strong>
Exercise caution when asking about sensitive or controversial topics. ChatGPT may inadvertently provide biased or inappropriate responses, so it's essential to review its answers critically.</p><p><strong>10. Rate and Provide Feedback:</strong>
Help improve ChatGPT by providing feedback. Use the thumbs-up/thumbs-down icons to indicate whether you find a response helpful or not. Your feedback contributes to the model's ongoing development.</p><p><strong>11. Use Caution with Personal Information:</strong>
Avoid sharing personal or sensitive information with ChatGPT, as it's an AI model, and data security cannot be guaranteed. Protect your privacy.</p><p><strong>12. Consider the Source:</strong>
Keep in mind that ChatGPT's knowledge is based on information available up to its last training data in September 2021. For the most up-to-date information, consult trusted sources for recent events or developments.</p><p><strong>13. Use for Assistance, Not Decisions:</strong>
ChatGPT is a valuable tool for research and information gathering but should not replace critical thinking or professional advice when making important decisions. Use it as a supportive resource.</p><p><strong>14. Experiment and Learn:</strong>
The more you interact with ChatGPT, the better you'll understand its capabilities and limitations. Don't hesitate to experiment and learn from your interactions.</p><p><strong>15. Respect Guidelines and Policies:</strong>
If you're using ChatGPT on a platform or website, make sure to follow their guidelines and policies for usage. Respect the rules to ensure a positive and productive experience.</p><p><strong>Conclusion:</strong>
Mastering ChatGPT is a valuable skill that can enhance your productivity and problem-solving abilities. By following these 15 tips for effective usage, you can unlock the full potential of ChatGPT and achieve better results in your endeavors.</p><p>Remember, ChatGPT is a tool designed to assist you, but it's essential to use it thoughtfully and critically, especially for important tasks and decision-making.</p>Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-61062625545818186872023-10-07T05:00:00.001+05:302023-10-07T05:00:00.146+05:30How to Fix Google Map Location Problem<p>Take Care What To Do When Google Map Doesn't Show The Correct Location</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht-pmknD0Q3EhdFj4PzQ2CTTD5FwaJg3wIDJA1S4iv6G6BKePzd8LJSUAIpBKMZjCPD-UTGBaVN0YfuljLH4pYzaA1pqOn2z6YamStpgHYc8_SmdXl9e_Jhj9NfT0MpL2mTFDD8VX3XkWOz4ltEaEHX9ccfRtpGZIlEWi_CbCuSW3DiYQxthxm8gH5/s2000/Google%20Map.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1171" data-original-width="2000" height="187" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht-pmknD0Q3EhdFj4PzQ2CTTD5FwaJg3wIDJA1S4iv6G6BKePzd8LJSUAIpBKMZjCPD-UTGBaVN0YfuljLH4pYzaA1pqOn2z6YamStpgHYc8_SmdXl9e_Jhj9NfT0MpL2mTFDD8VX3XkWOz4ltEaEHX9ccfRtpGZIlEWi_CbCuSW3DiYQxthxm8gH5/s320/Google%20Map.png" width="320" /></a></div><br /><br /><br />On computers, Google Maps are used by users to reach a particular location or to tell their location. Sometimes Google Maps does not give accurate location information. Due to this, the people arriving at the location have to face problems. If this happens to you too, then know how you can get rid of this problem.<br /><br /><b>Know your location</b><br /><br />First open the Google Maps app. The blue circle on the map shows your location. If the blue circle is not visible on the map in your app, then to know your location, tap on the option My Location in the bottom right of the app, this gives the correct location.<br /><br /><b>Restart phone</b><br /><br />If the problem is not resolved even after using My Location, then restart the mobile or tablet. After reopening the app, try to check the location again. After doing this the problem gets solved.<br /><br /><b>Compass accuracy</b><br /><br />Sometimes the setting of the compass gets disturbed. To fix this, take the phone in hand and draw a figure of 8, this improves the location of the compass. If you do not get the correct location information, check your phone's internet connection once.<p></p><p> </p><p><b>टेक केयर क्या करें, जब गूगल मैप सही लोकेशन न बताए</b><br /><br />कम्प्यूटर, गूगल मैप का इस्तेमाल यूजर्स किसी खास लोकेशन पर पहुंचने के लिए या अपनी लोकेशन को बताने के लिए करते हैं। कई बार गूगल मैप सही लोकेशन की जानकारी नहीं देता। इससे लोकेशन पर पहुंचने वालों को दिक्कतों का सामना करना पड़ता है। अगर आपके साथ भी ऐसा होता है तो जानिए इस समस्या से कैसे निजात पा सकते हैं<br /><br /><b>अपनी लोकेशन जानें</b><br /><br />पहले गूगल मैप ऐप ओपन करें। मैप पर दिखने वाला ब्लू सर्कल आपकी लोकेशन को दिखाता है। अगर आपके ऐप में मैप पर ब्लू सर्कल नहीं दिखाई दे रहा है तो अपनी लोकेशन को जानने के लिए ऐप में नीचे दाई ओर दिखने वाले ऑप्शन माय लोकेशन पर टैप करें, इससे सही लोकेशन आ जाती है।<br /><br /><b>रीस्टार्ट करें फोन</b><br /><br />माय लोकेशन का प्रयोग करने के बाद भी समस्या का समाधान नहीं हो रहा है तो मोबाइल या टैबलेट को रीस्टार्ट करें। ऐप को दोबारा ओपन करने के बाद फिर से लोकेशन को चेक करने की कोशिश करें। ऐसा करने के बाद प्रॉब्लम सॉल्व हो जाती है।<br /><br /><b>कम्पास एक्यूरेसी</b><br /><br />कई बार कम्पास की सेटिंग बिगड़ जाती है। इसे ठीक करने के लिए फोन को हाथ में लेकर 8 का फिगर बनाएं, इससे कम्पास की लोकेशन सुधर जाती है। लोकेशन की सही जानकारी न मिलने पर एक बार अपने फोन के इंटरनेट कनेक्शन को चेक करें। <br /></p>Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-76363012457216243872023-10-06T17:04:00.000+05:302023-10-06T17:04:04.293+05:30Mastering Custom Instructions in ChatGPT: Your Guide to Precision Conversations<p><b>Introduction</b></p>
<p>
ChatGPT is a powerful AI tool, but sometimes, to get exactly what you need, a
little guidance goes a long way. That's where custom instructions come in. In
this blog post, we'll explore how to use custom instructions effectively in
ChatGPT, ensuring your conversations are tailored to your requirements and
<span class="flex items-center whitespace-pre-wrap px-2 py-1 text-center font-medium normal-case text-white text-sm">how they’re used to help ChatGPT provide better responses.
</span>
</p>
<p><b>Custom Instructions Unveiled</b></p>
<p>
Custom instructions are your way of telling ChatGPT exactly what you want.
They provide context, tone, and direction, making your interactions more
productive and focused. Let's dive into how to use them to your advantage.
</p>
<p><b>How to Fill Custom Instructions</b></p>
<p>Here's a step-by-step guide to adding custom instructions in ChatGPT:</p>
<p><b>1. Access/Open ChatGPT on your web browser. </b><br /></p>
<p style="text-align: left;">
<b>2. Click on the Profile Icon at the bottom left corner and then click on
the Custom Instructions Option as shown in the below screen:</b><br /><br />
</p>
<div style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7-5sQAX9NyBMZsAppi_BAUi7Vllc_WxiXlKTocgzyop9mSzeesaEUPaI2f-nXJPQZAJOVWe7jyyc47aaWVR8G3Ip3e4OgL4qPVjEAxpLiIpmO1H-MinjlziT1FSNrncnq4pOutG25sVRWlL8Rf59DehaKwQrv8EEoGW99WwfNRYwCX5IupPEHTZUA2Cw/s258/Profile%20Screen.png" style="margin-left: 1em; margin-right: 1em;"><img alt="Profile Screen" border="0" data-original-height="214" data-original-width="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7-5sQAX9NyBMZsAppi_BAUi7Vllc_WxiXlKTocgzyop9mSzeesaEUPaI2f-nXJPQZAJOVWe7jyyc47aaWVR8G3Ip3e4OgL4qPVjEAxpLiIpmO1H-MinjlziT1FSNrncnq4pOutG25sVRWlL8Rf59DehaKwQrv8EEoGW99WwfNRYwCX5IupPEHTZUA2Cw/s16000/Profile%20Screen.png" title="Profile Screen" /></a><br /></div><div><br />
<p>
<b>3. Following pop-up or window shall get opened where you will be able write
your instructions:<br /></b>
</p>
<p><b> </b></p><div class="separator" style="clear: both; text-align: center;"><b><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3vgLI60vSakkho4Hpz-P9WObdDxRt8jwMC0NHNh8MsQbBiUvIG2Z0GedHWhlEDD1mxG0Gr0fOcziO75yeJOrI2Hn-sW36lB90wRiPOpnC-T2qJrjSw-9gwaboi6zmesnlaaj0vTJKV8HXR_bx5tBp6PkUGfzdU07dtMAUg0sYAlgH9Ot1saMR9LcD_RQ/s717/Custom%20Instruction%20Window.png" style="margin-left: 1em; margin-right: 1em;"><img alt="Custom Instruction Window" border="0" data-original-height="717" data-original-width="584" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3vgLI60vSakkho4Hpz-P9WObdDxRt8jwMC0NHNh8MsQbBiUvIG2Z0GedHWhlEDD1mxG0Gr0fOcziO75yeJOrI2Hn-sW36lB90wRiPOpnC-T2qJrjSw-9gwaboi6zmesnlaaj0vTJKV8HXR_bx5tBp6PkUGfzdU07dtMAUg0sYAlgH9Ot1saMR9LcD_RQ/s16000/Custom%20Instruction%20Window.png" title="Custom Instruction Window" /></a></b></div><b><br /></b><p></p>
<p>
<b>4. In the First Box: "What would you like ChatGPT to know about you to
provide better responses?</b>"<br />
<br />You can mention or provide details like:<br />
</p>
<ul style="text-align: left;">
<li>Where are you based?</li>
<li>What do you do for work?</li>
<li>What are your hobbies and interests?</li>
<li>What subjects can you talk about for hours?</li>
<li>What are some goals you have?</li>
</ul>
<p>
<b>5. In the Second Box:</b> "<b>How would you like ChatGPT to respond?</b>"
</p>
<p></p>
<p>You can mention or provide details like:</p>
<ul style="text-align: left;">
<li>How formal or casual should ChatGPT be?</li>
<li>How long or short should responses generally be?</li>
<li>How do you want to be addressed?</li>
<li>Should ChatGPT have opinions on topics or remain neutral?</li>
</ul>
<p>
<b>6</b>. And at the last<b> enable the</b> <b>toggle </b>button to take the
effect of the entered custom instructions for the new chats and then click on
<b>Save </b>button available at the bottom of the same custom instruction
pop-up window as shown in the below screenshot.<br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6InNwXRDiisWinhZvEwAaSEzxSItkFoCP3PBaBvQl1MoRPPuL55gRPUUv8rhsU23B_BfQvSGGpmdzUE3pp-Zd7IYe57gSX_ZnqdZXFxzOwRnqQfMIGsoSPBLXsEN70VnpOMPFfltcQ5a2jDo0rL5Qh4cXCG8wcIkfQRNgfT1lpJ0rD9CFUVmYwEReyxE/s545/Toggle%20&%20Save%20Button.png" style="margin-left: 1em; margin-right: 1em;"><img alt="Toggle & Save Button" border="0" data-original-height="64" data-original-width="545" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6InNwXRDiisWinhZvEwAaSEzxSItkFoCP3PBaBvQl1MoRPPuL55gRPUUv8rhsU23B_BfQvSGGpmdzUE3pp-Zd7IYe57gSX_ZnqdZXFxzOwRnqQfMIGsoSPBLXsEN70VnpOMPFfltcQ5a2jDo0rL5Qh4cXCG8wcIkfQRNgfT1lpJ0rD9CFUVmYwEReyxE/s16000/Toggle%20&%20Save%20Button.png" title="Toggle & Save Button" /></a></div><br /></div><div style="text-align: left;">
<div style="text-align: center;"><iframe frameborder="0" marginheight="0" marginwidth="0" sandbox="allow-popups allow-scripts allow-modals allow-forms allow-same-origin" scrolling="no" src="//ws-in.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=IN&source=ss&ref=as_ss_li_til&ad_type=product_link&tracking_id=visheshgoly04-21&language=en_IN&marketplace=amazon&region=IN&placement=B006G84AA6&asins=B006G84AA6&linkId=b95016976c570dfc3685efc1c1b61dd2&show_border=true&link_opens_in_new_window=true" style="height: 240px; width: 120px;"></iframe><img alt="" border="0" height="1" src="https://ir-in.amazon-adsystem.com/e/ir?t=visheshgoly04-21&language=en_IN&l=li3&o=31&a=B006G84AA6" style="border: medium; margin: 0px;" width="1" /></div>
<p><b>OR</b></p>
<p>
<b>You can also Add Custom Instructions in your chat as well</b>: Place your
custom instructions within square brackets "[ ]" anywhere within your message.
For instance:
</p>
<ul>
<li><code>[In a formal tone] Explain the theory of relativity.</code></li>
<li>
<code>[Provide a concise summary] Tell me about the latest scientific
discoveries.</code>
</li>
</ul>
<p>
<b>Be Specific</b>: The clearer and more specific your instructions, the
better ChatGPT can assist you. You can specify the style, depth, or context of
the response.
</p>
<p>
<b>Continue the Conversation</b>: After inserting your custom instructions,
continue the conversation naturally. ChatGPT will consider your guidance when
generating responses.
</p>
<p>Custom instructions are a powerful tool that allows you to shape your interactions with ChatGPT according to your needs. By mastering them, you can improve the quality of responses and make your conversations more productive.</p><p>Remember to also leverage post labels and a short search description to organize and enhance the discoverability of your content. With these tools in your toolkit, you're well on your way to becoming a ChatGPT expert.</p><p>So, go ahead, customize your conversations, and unlock the full potential of ChatGPT. Happy chatting!</p>
</div>Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-10621248549250496042023-10-05T17:55:00.007+05:302023-10-05T20:42:30.249+05:30Exploring the Marvels of Quantum Entanglement<p>Today, we're diving into the fascinating world of quantum entanglement. Don't let the complex-sounding name intimidate you—our mission here is to break it down into simple, understandable terms.</p><p><strong>What is Quantum Entanglement?</strong></p><p>At its core, quantum entanglement is a phenomenon that occurs when two or more particles become connected in such a way that the state of one particle instantly influences the state of the other(s), regardless of the distance separating them. It's as if they share a mysterious, invisible bond that allows them to communicate faster than the speed of light.</p><p><strong>The Spooky Action at a Distance</strong></p><p>Albert Einstein famously referred to this phenomenon as "spooky action at a distance." It defies our classical understanding of physics, which is why it's so mind-boggling and intriguing.</p><p><strong>How Does It Work?</strong></p><p>Imagine two entangled particles, A and B. If we change the state of particle A, particle B's state changes simultaneously, no matter how far apart they are. This instantaneous connection puzzled scientists for decades.</p><p><strong>Applications of Quantum Entanglement</strong></p><p>Quantum entanglement has far-reaching implications in various fields:</p><p><strong>1. Quantum Computing:</strong> It's a key element in the development of quantum computers, which have the potential to revolutionize computing power.</p><p><strong>2. Cryptography:</strong> Quantum encryption promises ultra-secure communication by detecting any eavesdropping attempts.</p><p><strong>3. Teleportation:</strong> Yes, you read that right! Researchers are exploring the possibility of teleporting information using entangled particles.</p><p><strong>4. Quantum Mechanics:</strong> It challenges our understanding of reality at the smallest scales, leading to breakthroughs in physics.</p><p><strong>The EPR Paradox and Bell's Theorem</strong></p><p>To deepen our understanding, let's delve into the EPR paradox and Bell's theorem. They played pivotal roles in the development of quantum entanglement theory.</p><p><strong>EPR Paradox:</strong> In 1935, Einstein, Podolsky, and Rosen published a paper highlighting the paradoxes of quantum mechanics. They questioned whether quantum theory was complete.</p><p><strong>Bell's Theorem:</strong> In the 1960s, physicist John Bell proposed a theorem to test the predictions of quantum entanglement. Experiments based on Bell's theorem have consistently supported the strange behavior of entangled particles.</p><p><strong>Conclusion</strong></p><p>Quantum entanglement may seem like science fiction, but it's a real phenomenon with practical applications and profound implications for our understanding of the universe. It's a topic that continues to captivate the minds of scientists and researchers worldwide.</p><p>As we explore the mysteries of the quantum world, remember that understanding concepts like entanglement helps us glimpse the incredible complexity and beauty of the universe.</p><p>Stay curious, and keep exploring the marvels of science!</p>Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-87088985655103701052023-03-02T19:11:00.003+05:302023-03-02T20:39:01.651+05:30How to Select Filtered Values using VBA<p>
When working with large datasets in Excel, it can be helpful to filter the
data to isolate specific values or ranges of values. Once you have filtered
your data, you may need to perform further operations on the filtered subset
of cells. One common task is to select the filtered values so that you can
manipulate or analyze them further.
</p>
<div class="flex flex-grow flex-col gap-3">
<div class="min-h-[20px] flex flex-col items-start gap-4 whitespace-pre-wrap">
<div class="markdown prose w-full break-words dark:prose-invert dark">
<p>
VBA (Visual Basic for Applications) is a programming language that can
be used to automate tasks in Excel. With VBA, you can write code to
select the filtered values in a worksheet.
</p>
<p>
To select the filtered value in VBA, you can use the following code:
</p>
<button onclick="copyToClipboard()">Copy Code</button>
<script>
function copyToClipboard() {
/* Get the text of the code snippet */
var code = document.querySelector('pre code');
/* Create a temporary element to hold the text */
var tempElement = document.createElement('textarea');
tempElement.value = code.innerText;
/* Add the temporary element to the page */
document.body.appendChild(tempElement);
/* Select the text and copy it to the clipboard */
tempElement.select();
document.execCommand('copy');
/* Remove the temporary element */
document.body.removeChild(tempElement);
}
</script>
<pre style="background: rgb(240, 240, 240); border: 2px dashed rgb(204, 204, 204); color: black; font-family: "arial"; font-size: 14px; height: auto; line-height: 20px; overflow: auto; padding: 6px; text-align: left; width: 99%;"><code style="color: black; overflow-wrap: normal;">Sub SelectFilteredValue()
'Activate the worksheet that contains the filtered data
Sheets("Sheet1").Activate
'Apply the filter to the desired column
Range("A1").AutoFilter Field:=1, Criteria1:="filter value"
'Select the filtered cells
Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible).Select
End Sub
</code></pre>
<p>
To select the filtered value using VBA, you need to activate the
worksheet that contains the filtered data, apply the filter to the
desired column, and then select the filtered cells. The code will depend
on the specific criteria that you want to filter by and the range of
cells that you want to select. You can modify the code to fit your
specific needs by changing the sheet name, column number, and filter
criteria.
</p>
<p>
In the following example, we will walk you through the code that you can
use to select filtered values in Excel using VBA.
</p>
<p><b>Example</b>:</p>
<p>
Let's say you have a worksheet named "Data" that contains a table with
information on employee salaries. You want to filter the data to show
only employees with a salary greater than $50,000, and then select the
filtered values to copy them to another worksheet for further analysis.
</p>
<p>Here is the VBA code to accomplish this task:</p>
<button onclick="copyToClipboard()">Copy Code</button>
<script>
function copyToClipboard() {
/* Get the text of the code snippet */
var code = document.querySelector('pre code');
/* Create a temporary element to hold the text */
var tempElement = document.createElement('textarea');
tempElement.value = code.innerText;
/* Add the temporary element to the page */
document.body.appendChild(tempElement);
/* Select the text and copy it to the clipboard */
tempElement.select();
document.execCommand('copy');
/* Remove the temporary element */
document.body.removeChild(tempElement);
}
</script>
<pre style="background: rgb(240, 240, 240); border: 2px dashed rgb(204, 204, 204); color: black; font-family: "arial"; font-size: 14px; height: auto; line-height: 20px; overflow: auto; padding: 6px; text-align: left; width: 99%;"><code style="color: black; overflow-wrap: normal;">Sub SelectFilteredValues()
'Activate the worksheet that contains the filtered data
Sheets("Data").Activate
'Apply the filter to the "Salary" column
Range("B1").AutoFilter Field:=2, Criteria1:=">50000"
'Select the filtered cells (excluding the header row)
Range("A2:C" & Range("C" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible).Select
'Copy the selected cells to a new worksheet
Selection.Copy Sheets("Summary").Range("A1")
'Remove the filter
Range("B1").AutoFilter
End Sub
</code></pre>
<p>
This code first activates the "<b>Data</b>" worksheet and applies a
filter to the "<b>Salary</b>" column to show only values greater than
<b>$50,000</b>. It then selects the filtered cells (excluding the header
row) and copies them to a new worksheet named "<b>Summary</b>" starting
at cell <b>A1</b>. Finally, it removes the filter from the
"<b>Salary</b>" column.
</p>
<p>
<b>Note </b>that in this example, we assumed that the
<b>employee names</b> are in <b> column A</b>, the <b>salaries </b>are
in <b>column B</b>, and <b>other information</b> (such as department or
hire date) is in <b>column C</b>. You should modify the code to fit your
specific data layout and filter criteria.
</p>
<p>
Overall, using VBA to select filtered values in Excel can save you time
and make your data analysis tasks more efficient. With a bit of
programming knowledge, you can customize the code to fit your specific
needs and automate complex tasks.
</p>
<p></p>
</div>
</div>
</div>
Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-47932279280378816422023-02-28T20:06:00.004+05:302023-03-01T12:34:35.866+05:30What is Use Case and Why it is Important?<p></p><h2 style="text-align: left;">What is Use Case?</h2><p style="text-align: justify;">In software development, a use case is a technique used to identify and define the requirements of a system from the perspective of its end-users. It is a description of the specific ways in which a user interacts with a software application to achieve a particular goal or task.<br /><br />A use case typically consists of several components, including a title, a brief description of the user's goal or task, a list of preconditions or assumptions that must be met before the use case can be executed, a list of steps or actions the user must take to complete the task, and any alternate or exceptional paths that may be encountered during the process.<br /><br />Use cases are commonly used in software development as a way to define functional requirements and to ensure that the system meets the needs of its intended users. They are also used as a communication tool between developers, testers, and other stakeholders to ensure everyone has a shared understanding of the system's requirements and expected behavior. </p><h2 style="text-align: left;">Who should write the Use Case?</h2><p style="text-align: justify;"></p><p style="text-align: justify;">The use case for a new development of a software is usually written by a business analyst. The business analyst works closely with the software development team and stakeholders to understand the business requirements and translate them into technical requirements. The use case describes the various scenarios in which the software will be used and outlines the steps that the user will take to accomplish specific goals.</p><p></p><p style="text-align: justify;">The business analyst is responsible for gathering information from various stakeholders, including end-users, product owners, and subject matter experts, and documenting the use cases in a clear and concise manner. They work with the development team to ensure that the use cases are feasible and achievable within the project scope. </p><p style="text-align: justify;">The use case is an important document that helps the development team to understand the business requirements and develop the software accordingly. It serves as a reference for the development team and helps them to stay on track and meet the project objectives.</p><h2 style="text-align: justify;"><b>Importance of writing use cases in software development:</b></h2><div class="flex flex-grow flex-col gap-3" style="text-align: justify;"><div class="min-h-[20px] flex flex-col items-start gap-4 whitespace-pre-wrap"><div class="markdown prose w-full break-words dark:prose-invert dark"><p>The importance of writing use cases in software development can be summarized as follows:</p><ol><li><p>Clear understanding of user requirements: Use cases help to define and clarify the user requirements for a software system. They provide a clear and concise description of how the software should function and what it needs to achieve.</p></li><li><p>Focus on user needs: Use cases help to ensure that the software development process is focused on meeting the needs of the users. By defining user scenarios and interactions, use cases help to ensure that the software is designed with the user in mind.</p></li><li><p>Improved communication: Use cases serve as a communication tool between the development team, stakeholders, and end-users. They help to ensure that everyone involved in the development process has a shared understanding of the software requirements and how the software should work.</p></li><li><p>Guide for testing and validation: Use cases provide a guide for testing and validation of the software. They help to identify potential issues and areas of improvement and can be used as a reference during the testing process.</p></li><li><p>Basis for system design: Use cases provide the basis for designing the software system. They help to define the functionality of the system and its components, and guide the development team in the creation of the software architecture.</p></li></ol><p>In summary, use cases play an important role in software development by defining user requirements, focusing on user needs, improving communication, guiding testing and validation, and providing the basis for system design.</p></div></div></div><p style="text-align: justify;"> </p><transover-popup content-height="75.8333" content-width="672.4" content="<div class="pos_translation ">एक सॉफ्टवेयर के नए विकास के लिए उपयोग का उदाहरण आमतौर पर एक व्यापार विश्लेषक द्वारा लिखा जाता है। व्यवसाय विश्लेषक व्यावसायिक आवश्यकताओं को समझने और उन्हें तकनीकी आवश्यकताओं में बदलने के लिए सॉफ़्टवेयर डेवलपमेंट टीम और हितधारकों के साथ मिलकर काम करता है।</div>
<div class="from_lang ">
<strong>translated from:</strong>
<span> English</span>
</div>
" left="5" options="{"except_urls":[],"only_urls":[],"target_lang":"hi","from_lang":"auto","reverse_lang":"","word_key_only":1,"selection_key_only":1,"tts":0,"tts_key":"ctrl","translate_by":"click","delay":700,"do_not_show_oops":0,"popup_show_trigger":"ctrl","show_from_lang":true,"fontSize":14}" outer-height="82" outer-width="700" top="65"></transover-popup>Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-66066753331033253572022-08-10T14:38:00.000+05:302022-08-10T14:38:24.801+05:30Amazon Alexa Traffic Rank Chrome Extension<p style="text-align: justify;">
<b>Amazon Alexa Traffic Rank extension (Add-on)</b> is used for the Website SEO Ranking. Using this extension you can see the ranking of any website across the globe. It is absolutely free extension.
</p>
<p style="text-align: justify;">Many people use this plugin to keep track of their competitors' website rankings and other SEO related information. This is amongst the most popular and well-known website traffic rank browser extensions for Chrome. You may easily learn about your competitor's site ranking and some statistics with this tool without having to open a new tab in your browser. </p>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://chrome.google.com/webstore/detail/alexa-traffic-rank/cknebhggccemgcnbidipinkifmmegdel?hl=en" style="margin-left: 1em; margin-right: 1em;" target="_blank">
<img border="0" data-original-height="499" data-original-width="2400" height="42" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1QOXoqk8DfvyZmhTkv5zVjEyp3uSBAgs_2YH-R7CVQdFMG4UR3-wVITRaVMjMwajM-AG7vxMPTeVylEgc1yhbiCbHVzPYac7CA2_VLNjHfqF0zxNK91fSZVmqzP-avPkXASHnf_XfjiUc5BbX7fUKXicYxY7dfEcKKUvnvyDt0rbvqFT7WuO2ESkd/w200-h42/Download%20Button.png" width="200" />
</a>
</div>
<br />
<script async="" crossorigin="anonymous" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-8542016316920624"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout-key="-fb+5w+4e-db+86" data-ad-slot="2746508642" style="display: block;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
<p style="text-align: justify;">The following is a comparison of the extension's <b>Old </b>vs <b>New </b>user interfaces: </p>
<p style="text-align: justify;">You could see this details about any website under the old UI of this addon: <br />
</p>
<ol style="text-align: left;">
<li>Alexa Traffic Rank</li>
<li>Country-wise Traffic Rank</li>
<li>Reviews</li>
<li>Sites Linking In</li>
<li>Search Analytics (Top Queries driving traffic to the searched website)</li>
<li>Related Links (Alternative Sites or Similar Sites)</li>
<li>Average Load Speed & Time etc.. </li>
</ol>
<p></p>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<img alt="alexa_traffic_rank_old_ui" border="0" data-original-height="430" data-original-width="500" height="344" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7bs0P2M9mGFYX7B_z_FCAMyfN5PUpsBV73hveOehm9CH-UAv-g_ffC1nSgIWXiFhIFyMyvSEaYr17z_LtD2QYAsNXDPndXp0rsY02qkgnwmy7Xl1e_i9d4KQG0xp7t3WBPWGEToWavRFvHeO8XrB9YVSoNnez9Fr5Y0qFQg94Nn24LWjp-fHuDpCZ/w400-h344/alexa_traffic_rank_old_ui.jpg" style="margin-left: auto; margin-right: auto;" title="alexa_traffic_rank_old_ui" width="400" />
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Alexa Traffic Rank - Old UI</b>
<br />
</td>
</tr>
</tbody>
</table>
<div style="text-align: center;"></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7bs0P2M9mGFYX7B_z_FCAMyfN5PUpsBV73hveOehm9CH-UAv-g_ffC1nSgIWXiFhIFyMyvSEaYr17z_LtD2QYAsNXDPndXp0rsY02qkgnwmy7Xl1e_i9d4KQG0xp7t3WBPWGEToWavRFvHeO8XrB9YVSoNnez9Fr5Y0qFQg94Nn24LWjp-fHuDpCZ/s500/alexa_traffic_rank_old_ui.jpg" style="margin-left: 1em; margin-right: 1em;"></a>
</div>
<p>
<br />
<script async="" crossorigin="anonymous" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-8542016316920624"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout-key="-fb+5w+4e-db+86" data-ad-slot="2746508642" style="display: block;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
</p>
<p>However, with the help of this tool and the new UI of this extension, you can see these data about any website:</p>
<ol style="text-align: left;">
<li>Alexa Traffic Rank - Globally</li>
<li>Alexa Traffic Rank - In Country</li>
<li>Alternative (Similar) Sites</li>
<li>Related Keywords</li>
<li>Sites Linking In</li>
</ol>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<img border="0" data-original-height="439" data-original-width="500" height="351" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpsQy7T7uvm7DABI16sKJlUtKn0xCpFYq9aNbruKgeJ1aXz7QzxwYVX-cSxyqiA6y8bVtx4q-u4Pxiq-W1dcQkPdHvrckJL8LD51winkE1GpY27e5hjU1cNRu6GSX-58qI8Vot66AEyA-VCo7olpHHDtkdqGZ-rFWYG3rSlLZRXcR-aFTXecd63QB5/w400-h351/Alexa_new_UI.jpg" style="margin-left: auto; margin-right: auto;" width="400" />
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Alexa Traffic Rank - New UI</b>
</td>
</tr>
</tbody>
</table>
<div class="separator" style="clear: both; text-align: left;"> </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://chrome.google.com/webstore/detail/alexa-traffic-rank/cknebhggccemgcnbidipinkifmmegdel?hl=en" style="margin-left: 1em; margin-right: 1em;" target="_blank">
<img border="0" data-original-height="499" data-original-width="2400" height="42" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1QOXoqk8DfvyZmhTkv5zVjEyp3uSBAgs_2YH-R7CVQdFMG4UR3-wVITRaVMjMwajM-AG7vxMPTeVylEgc1yhbiCbHVzPYac7CA2_VLNjHfqF0zxNK91fSZVmqzP-avPkXASHnf_XfjiUc5BbX7fUKXicYxY7dfEcKKUvnvyDt0rbvqFT7WuO2ESkd/w200-h42/Download%20Button.png" width="200" />
</a>
<br />
</div>
<div class="separator" style="clear: both; text-align: justify;">
<br />
<br />
<script async="" crossorigin="anonymous" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-8542016316920624"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout-key="-fb+5w+4e-db+86" data-ad-slot="2746508642" style="display: block;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
</div>
<div class="separator" style="clear: both; text-align: justify;">After the last major UI update, you will no longer be able to see the average load speed & time of any website in this tool; however, if you want to learn more about website performance and speed, use <b>GTmatrix</b>, the <b>Pingdom </b>or the <b>PageSpeed Insights </b>tool. </div>
<div class="separator" style="clear: both; text-align: justify;"> </div>
<div class="separator" style="clear: both; text-align: justify;">You can now see a few top ranking keywords of any competitor website in the updated UI of the Alexa traffic ranking extension, which you couldn't see in the old UI of this extension. </div>
<br />Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-54293186695133393332022-06-09T23:09:00.014+05:302022-06-15T18:46:23.867+05:30Aadhaar Card Update! बच्चों के आधार कार्ड में दो बार अपडेट जरूरी!<div><h2 style="text-align: center;">
<b>आपके लिए <span style="color: red;">जानना जरूरी</span> है </b>
</h2><p style="text-align: left;">
</p><p style="text-align: center;"><b> आधार कार्ड (Aadhaar Card) में एड्रेस, नाम, नंबर में करा सकते हैं बदलाव <br /></b></p><p style="text-align: center;"><b></b></p><p style="text-align: center;"><b></b></p><p style="text-align: center;"></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge5bwnD3Lon6PbymD7zOLIuwp2ec8pmEHhvpAI97GZfTCo14uMJBvXVgjb-0F-ByiAR38_ahOTzb42pcjT9h3ALP6Wr9xokDwInp7teTHmF3O1NZxF2KUDhZZhgwAZmDuJ6-C5cS5rlfV1eDzTAsge19NM4EFdWZ4JDM23jehOU9eEwg8pf5YYabN-/s925/Aadhaar_Card.png.jpg" style="margin-left: 1em; margin-right: 1em;"><img alt="आधार कार्ड (Aadhaar Card)" border="0" data-original-height="532" data-original-width="925" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge5bwnD3Lon6PbymD7zOLIuwp2ec8pmEHhvpAI97GZfTCo14uMJBvXVgjb-0F-ByiAR38_ahOTzb42pcjT9h3ALP6Wr9xokDwInp7teTHmF3O1NZxF2KUDhZZhgwAZmDuJ6-C5cS5rlfV1eDzTAsge19NM4EFdWZ4JDM23jehOU9eEwg8pf5YYabN-/w320-h184/Aadhaar_Card.png.jpg" title="आधार कार्ड (Aadhaar Card)" width="320" /></a></div><br />
<p></p>
<p>
<b>बच्चे का 5 और 15 साल में </b><b>आधार कार्ड (Aadhaar Card) अपडेशन जरूरी, वर्ना इनएक्टिव हो सकता है!</b>
</p>
<p></p>
<p>आधार कार्ड (Aadhaar Card) आज सरकारी योजनाओं, डीबीटी से लेकर बैंक खाता खुलवाने, पैन कार्ड और प्रॉपर्टी रजिस्ट्रेशन तक उपयोगी दस्तावेज बन चुका है। अक्सर लोग आधार अपडेशन में दिक्कतों का सामना करते हैं। आइए हम आपको बताते हैं कि आधार को कब और कैसे अपडेट कराएं:</p>
<p>
<br />
</p>
<p>
<b><b>आधार कार्ड (Aadhaar Card) </b>अपडेट कैसे कराएं?</b>
</p>
<br /><br /></div>
<div style="text-align: center;"><a href="https://www.amazon.in/Bluetooth-Wireless-Supports-Cancellation-Resistant/dp/B09G6LTQ8Q?_encoding=UTF8&pd_rd_w=tjUfS&content-id=amzn1.sym.ee853eb9-cee5-4961-910b-2f169311a086&pf_rd_p=ee853eb9-cee5-4961-910b-2f169311a086&pf_rd_r=P2MESHS2NTC31Y90GRQF&pd_rd_wg=p6yAJ&pd_rd_r=b31e21ee-bcaa-4715-bb3a-22eb18a8af31&th=1&linkCode=li3&tag=visheshgolya-21&linkId=d2c5f3def13365c215404e29707c5a19&language=en_IN&ref_=as_li_ss_il" target="_blank"><img border="0" src="//ws-in.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B09G6LTQ8Q&Format=_SL250_&ID=AsinImage&MarketPlace=IN&ServiceVersion=20070822&WS=1&tag=visheshgolya-21&language=en_IN" ></a><img src="https://ir-in.amazon-adsystem.com/e/ir?t=visheshgolya-21&language=en_IN&l=li3&o=31&a=B09G6LTQ8Q" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /></div>
<p style="text-align: center;"><span style="font-size: medium;"><span style="color: red;"><b>HURRY!! 60% Off</b></span></span> on Amazon<span class="a-size-large product-title-word-break" id="productTitle"> on OPPO Enco Buds Bluetooth True Wireless in Ear Earbuds(TWS) with Mic<br /><a href="https://amzn.to/3tF5Dse">https://amzn.to/3tF5Dse</a><br /></span></p><p> </p><p>आधार कार्ड (Aadhaar Card) ऑनलाइन और ऑफलाइन दोनों तरह से अपडेट किया जा सकता है। अपडेट के लिए नामांकन 25 रुपए का शुल्क है। ऑनलाइन अपडेशन के लिए <b>https://uidai.gov.in/ </b>पर सेल्फ सर्विस अपडेट में जाएं। अगर वैध प्रमाण है, तो <b>Proceed to Update Address</b> पर क्लिक करें। निर्देशों का पालन कर वैरिफिकेशन पूरा करें। ऐसे आधार अपडेट हो जाएगा। </p>
<p></p>
<p>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
<br />
</p>
<p>
<b>बच्चे का </b><b><b>आधार कार्ड (Aadhaar Card) </b>कब अपडेट कराएं? </b>
</p>
<p>बच्चे का आधार कार्ड <b>5 </b>साल और <b>15 </b>साल की उम्र में अपडेट कराना जरूरी है। यह बदलाव बॉयोमीट्रिक अपडेशन कहलाता है। ये अनिवार्य है। ऐसा न हो तो बच्चे का आधार कार्ड इनएक्टिव हो सकता है। <br />
<br />
</p>
<p>
<b>बच्चे का </b><b><b>आधार कार्ड (Aadhaar Card) </b>अपडेट कैसे कराएं? </b>
</p>
<p>5 साल में फिंगरप्रिंट अपडेट कराना होगा। इसके लिए कोई चार्ज नहीं देना होगा। नजदीकी आधार सेंटर जाना होगा। भीड़ से बचने के लिए <b>appointments.uidai. gov.in/easearch.aspx</b> पर अपॉइंटमेंट लें। फिर जरूरी डॉक्यूमेंट्स के साथ सेंटर पर अपडेट कराएं। बच्चा जब 15 साल का हो तो फिर अपडेट कराएं। <br />
<br />
</p>
<p>
<b>नाम, जेंडर, जन्मतिथि कितनी बार अपडेट कर सकेंगे?</b>
</p>
<p></p>
<p>आधार कार्ड (Aadhaar Card) में नाम सिर्फ दो बार, जेंडर और जन्मतिथि सिर्फ एक बार ही बदली जा सकती है। जन्मतिथि तभी अपडेट हो सकेगी, जब अंतिम जन्मतिथि UIDAI के साथ वेरिफाई न हो। </p>
<p></p>
<p>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
<br />
</p>
<p>
<b>मोबाइल नंबर ऑनलाइन कैसे अपडेट करें?</b>
</p>
<p></p>
<p>मोबाइल नंबर ऑनलाइन अपडेट नहीं होगा। इसके लिए आधार केंद्र जाना होगा।</p>
<p>
<br />
</p>
<p>
<b>क्या और तरह से मोबाइल अपडेट होगा?</b>
</p>
<p>आधार कार्ड (Aadhaar Card) जारी करने वाले UIDAI ने डाक विभाग के माध्यम से भी मोबाइल नंबर अपडेट कराने की व्यवस्था की है। यह सुविधा देश के 650 इंडिया पोस्ट बैंक और 1.46 लाख पोस्टमैन के जरिए आपको घर बैठे मिलेगी। इसके लिए 50 रुपए फीस देनी होगी।</p>
<p> </p>
<p>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
</p>Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-42560264800725438162020-09-29T16:00:00.000+05:302020-09-29T16:00:58.953+05:30Create or Insert a New Module in VBE<p>In this tutorial, we are going to explain you how to <b>Insert or Create a New Module </b>in the Visual Basic Editor (VBE).</p>
<p>
To <b>Insert or Create a New Module</b>, please follow the beneath steps:
<br />
<br />
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
</p>
<ol style="text-align: left;">
<li>Open the workbook in which you want to insert the Module. <br /></li><li>Press <b>Alt+F11</b> key from your keyboard to open the
<b>Visual Basic Editor (VBE)</b> window.
</li>
<li>
Click on the <b class="ocpUI">Insert</b> tab in the VBE, and click
<span class="ocpUI">on the </span><b class="ocpUI">Module</b> option<br /><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_-GFmaN5Pwzugi64AdVOfeuA4niiwNHksc6VutsHUKKyZBR6hf4CGuoLFblZJHc-eDf_wEMem_HrO_baa_VUgCjw0QusSnjP24GkNXcbaG8C6jRVhSxbAnZ0y0DDY2seb90YchyphenhyphenGgB1I/s775/Insert+Module.gif" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="362" data-original-width="775" height="275" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_-GFmaN5Pwzugi64AdVOfeuA4niiwNHksc6VutsHUKKyZBR6hf4CGuoLFblZJHc-eDf_wEMem_HrO_baa_VUgCjw0QusSnjP24GkNXcbaG8C6jRVhSxbAnZ0y0DDY2seb90YchyphenhyphenGgB1I/w592-h275/Insert+Module.gif" width="592" /></a></div><br /></li>
<li>
At the Right Side of the Project Explorer Window, A code window will be opened. You can Enter your new code or Copy-Paste any of your existing code there.</li></ol>
<br />
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-15117191845951455342020-09-23T20:46:00.000+05:302020-09-23T20:46:04.525+05:30Rank Function in MS Excel<h3 style="text-align: left;">What it Does?</h3>
<p>
This function calculates the position of a value in a list, relative to the
other values in the list. A typical usage would be to rank the Marks of
students in a exam to find the topper. The ranking can be done on an ascending
(low to high) or descending (high to low) basis.<br /><br />If there are
duplicate values in the list, they will be assigned the same rank. Subsequent
ranks would not follow on sequentially, but would take into account the fact
that there were duplicates. If the numbers 30, 20, 20 and 10 were ranked, 30
is ranked as 1, both 20's are ranked as 2, and the 10 would be ranked as 4
</p>
<h3 style="text-align: left;">
<b
>Syntax:
<br
/></b>
</h3>
<p style="text-align: left;">
<b>=RANK(NumberToRank,ListOfNumbers,RankOrder)</b><br />
<br />
<script
async
src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"
></script>
<ins
class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"
></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
</p>
<p style="text-align: left;">
The RankOrder can be 0 zero or 1. Using 0 will rank larger numbers at the top.
(This is optional, leaving it out has the same effect). Using 1 will rank
small numbers at the top.
<br />
</p>
<h3 style="text-align: left;">
Example:
<br />
</h3>
<p style="text-align: left;">
The following table was used to record the times for athletes competing in a
race.
<br />The
<b>=RANK()</b> function was then used to find their race positions based upon
the finishing times.
</p>
<p style="text-align: left;">
In this example, the athlete who completes the race in lesser time will be
shown in the 1st position and so on.<br />
</p>
<table
align="center"
cellpadding="0"
cellspacing="0"
class="tr-caption-container"
style="margin-left: auto; margin-right: auto;"
>
<tbody>
<tr>
<td style="text-align: center;">
<a
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4Preri-vhZHw-hp-9KB2HLoR_W4_2QS2QNepRtayNXGnS80Tv7fqa1VJ99Fbkzm4mAnFMVhNBJKjG_BSeE3Sf-M83NBmyrSsOVa-huf_x6X2J0XGbwSoMGKU3QkFNHWmKQCbxFnG1Lgc/s539/Rank+Function.gif"
style="margin-left: auto; margin-right: auto;"
><img
alt="Rank Function Example GIF Image"
border="0"
data-original-height="271"
data-original-width="539"
height="322"
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4Preri-vhZHw-hp-9KB2HLoR_W4_2QS2QNepRtayNXGnS80Tv7fqa1VJ99Fbkzm4mAnFMVhNBJKjG_BSeE3Sf-M83NBmyrSsOVa-huf_x6X2J0XGbwSoMGKU3QkFNHWmKQCbxFnG1Lgc/w640-h322/Rank+Function.gif"
title="Rank Function Example"
width="640"
/></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Rank Function Example</b><br />
</td>
</tr>
</tbody>
</table>
<div class="separator" style="clear: both; text-align: center;">
<span></span>
</div>
<span><br /></span><br />
<br />
<script
async
src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"
></script>
<ins
class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"
></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
<p></p>
Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-27127022399987964382020-09-23T20:30:00.009+05:302020-09-23T21:11:29.031+05:30Spell INR Amount into Words<p>
In the Microsoft Excel there is no default function that displays the numbers
into words in a worksheet, but you can add this capability by creating your
own function by pasting the following <b>SpellNumber </b>function code into a
VBA (Visual Basic for Applications) module.
</p>
<p>
This function lets you convert the Rupees and Paise into words with a formula,
so<b> ₹786.99</b> would read as
<b>Rupees Seven Hundred Eighty Six and Paise Ninety Nine Only</b> . This can
be very useful if you're using Excel as a template to print Cheques/Checks.
</p>
<p>
To add this function into your workbook, please follow the beneath steps:
<br />
</p>
<ol style="text-align: left;">
<li>Open the workbook where you want to spell the numbers.</li>
<li>
Press <b>Alt+F11</b> key from your keyboard to open the
<b>Visual Basic Editor (VBE)</b> window.
</li>
<li>
Click the <b class="ocpUI">Insert</b> tab in the VBE, and click
<span class="ocpUI">on the </span
><b class="ocpUI">Module</b> option<br /><br />
<table
align="center"
cellpadding="0"
cellspacing="0"
class="tr-caption-container"
style="margin-left: auto; margin-right: auto;"
>
<tbody>
<tr>
<td style="text-align: center;">
<a
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOi0jSxqQqJtcEwVQXjpklTntYYSCqrsotqyZvWukXVTAhg5eLJ52Ol49WAKIVuaw3XGHl71xPs2Z82-0cDVGjj0WaqaZBVsJEt52t1XDWWJOftyMirXJo-FaXDn4UD66_lOMohLCwVEU/s736/vba-editor-insert-module.png"
style="margin-left: auto; margin-right: auto;"
><img
alt="VBE - Insert Module Image"
border="0"
data-original-height="325"
data-original-width="736"
height="220"
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOi0jSxqQqJtcEwVQXjpklTntYYSCqrsotqyZvWukXVTAhg5eLJ52Ol49WAKIVuaw3XGHl71xPs2Z82-0cDVGjj0WaqaZBVsJEt52t1XDWWJOftyMirXJo-FaXDn4UD66_lOMohLCwVEU/w500-h220/vba-editor-insert-module.png"
title="VBE - Insert Module"
width="500"
/></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>VBE - Insert Module</b><br />
</td>
</tr>
</tbody>
</table>
<br />
<script
async=""
src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"
></script>
<ins
class="adsbygoogle"
data-ad-client="ca-pub-8542016316920624"
data-ad-format="fluid"
data-ad-layout="in-article"
data-ad-slot="6403984725"
style="display: block; text-align: center;"
></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
</li>
<li>
You will see a window named <b>YourWorkBook Name - Module1</b> as shown in
the below screenshot:<br /><br />
<table
align="center"
cellpadding="0"
cellspacing="0"
class="tr-caption-container"
style="margin-left: auto; margin-right: auto;"
>
<tbody>
<tr>
<td style="text-align: center;">
<a
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNULdG5SSWrSemvQy7CjOKNSgvboi7V0A7jLfjvQVnESwiKz3jM91rY67jJhnrx0ycj1SV-G2t_HVOBu9rRNwJM8mUGaulohalyQIQROOD0jwCKFyIXF0lGlFYREofqqUUJHMaNRaZH7w/s1000/spell-number-excel-vba-module.png"
style="margin-left: auto; margin-right: auto;"
><img
alt="Code window in Module Image"
border="0"
data-original-height="672"
data-original-width="1000"
height="336"
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNULdG5SSWrSemvQy7CjOKNSgvboi7V0A7jLfjvQVnESwiKz3jM91rY67jJhnrx0ycj1SV-G2t_HVOBu9rRNwJM8mUGaulohalyQIQROOD0jwCKFyIXF0lGlFYREofqqUUJHMaNRaZH7w/w500-h336/spell-number-excel-vba-module.png"
title="Code window in Module"
width="500"
/></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Code window in Module</b><br />
</td>
</tr>
</tbody>
</table>
<br />
</li>
<li>Copy and Paste the following lines of codes in this module: <br /></li>
<pre
style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 2px dashed rgb(204, 204, 204); color: black; font-family: arial; font-size: 14px; height: auto; line-height: 20px; overflow: auto; padding: 6px; text-align: left; width: 99%;"
><code style="color: black; overflow-wrap: normal;">Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True)<br /> Dim Crores, Lakhs, Rupees, Paise, Temp<br /> Dim DecimalPlace As Long, Count As Long<br /> Dim myLakhs, myCrores<br /> ReDim Place(9) As String<br /> Place(2) = " Thousand ": Place(3) = " Million "<br /> Place(4) = " Billion ": Place(5) = " Trillion "<br /> ' String representation of amount.<br /> MyNumber = Trim(Str(MyNumber))<br /> ' Position of decimal place 0 if none.<br /> DecimalPlace = InStr(MyNumber, ".")<br /> ' Convert Paise and set MyNumber to Rupees amount.<br /> If DecimalPlace > 0 Then<br /> Paise = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2))<br /> MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))<br /> End If<br /> myCrores = MyNumber \ 10000000<br /> myLakhs = (MyNumber - myCrores * 10000000) \ 100000<br /> MyNumber = MyNumber - myCrores * 10000000 - myLakhs * 100000<br /> Count = 1<br /> Do While myCrores <> ""<br /> Temp = GetHundreds(Right(myCrores, 3))<br /> If Temp <> "" Then Crores = Temp & Place(Count) & Crores<br /> If Len(myCrores) > 3 Then<br /> myCrores = Left(myCrores, Len(myCrores) - 3)<br /> Else<br /> myCrores = ""<br /> End If<br /> Count = Count + 1<br /> Loop<br /> Count = 1<br /> Do While myLakhs <> ""<br /> Temp = GetHundreds(Right(myLakhs, 3))<br /> If Temp <> "" Then Lakhs = Temp & Place(Count) & Lakhs<br /> If Len(myLakhs) > 3 Then<br /> myLakhs = Left(myLakhs, Len(myLakhs) - 3)<br /> Else<br /> myLakhs = ""<br /> End If<br /> Count = Count + 1<br /> Loop<br /> Count = 1<br /> Do While MyNumber <> ""<br /> Temp = GetHundreds(Right(MyNumber, 3))<br /> If Temp <> "" Then Rupees = Temp & Place(Count) & Rupees<br /> If Len(MyNumber) > 3 Then<br /> MyNumber = Left(MyNumber, Len(MyNumber) - 3)<br /> Else<br /> MyNumber = ""<br /> End If<br /> Count = Count + 1<br /> Loop<br /> Select Case Crores<br /> Case "": Crores = ""<br /> Case "One": Crores = " One Crore "<br /> Case Else: Crores = Crores & " Crores "<br /> End Select<br /> Select Case Lakhs<br /> Case "": Lakhs = ""<br /> Case "One": Lakhs = " One Lakh "<br /> Case Else: Lakhs = Lakhs & " Lakhs "<br /> End Select<br /> Select Case Rupees<br /> Case "": Rupees = "Zero "<br /> Case "One": Rupees = "One "<br /> Case Else:<br /> <br /> Rupees = Rupees<br /> End Select<br /> Select Case Paise<br /> Case "": Paise = " And Paise Zero Only "<br /> Case "One": Paise = " And Paise One Only "<br /> Case Else: Paise = " And Paise " & Paise & " Only "<br /> End Select<br /> SpellNumber = IIf(incRupees, "Rupees ", "") & Crores & _<br /> Lakhs & Rupees & Paise<br />End Function<br />' Converts a number from 100-999 into text<br />Private Function GetHundreds(ByVal MyNumber)<br /> Dim Result As String<br /> If Val(MyNumber) = 0 Then Exit Function<br /> MyNumber = Right("000" & MyNumber, 3)<br /> ' Convert the hundreds place.<br /> If Mid(MyNumber, 1, 1) <> "0" Then<br /> Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "<br /> End If<br /> ' Convert the tens and ones place.<br /> If Mid(MyNumber, 2, 1) <> "0" Then<br /> Result = Result & GetTens(Mid(MyNumber, 2))<br /> Else<br /> Result = Result & GetDigit(Mid(MyNumber, 3))<br /> End If<br /> GetHundreds = Result<br />End Function<br />' Converts a number from 10 to 99 into text.<br />Private Function GetTens(TensText)<br /> Dim Result As String<br /> Result = "" ' Null out the temporary function value.<br /> If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19...<br /> Select Case Val(TensText)<br /> Case 10: Result = "Ten"<br /> Case 11: Result = "Eleven"<br /> Case 12: Result = "Twelve"<br /> Case 13: Result = "Thirteen"<br /> Case 14: Result = "Fourteen"<br /> Case 15: Result = "Fifteen"<br /> Case 16: Result = "Sixteen"<br /> Case 17: Result = "Seventeen"<br /> Case 18: Result = "Eighteen"<br /> Case 19: Result = "Nineteen"<br /> Case Else<br /> End Select<br />Else ' If value between 20-99...<br /> Select Case Val(Left(TensText, 1))<br /> Case 2: Result = "Twenty "<br /> Case 3: Result = "Thirty "<br /> Case 4: Result = "Forty "<br /> Case 5: Result = "Fifty "<br /> Case 6: Result = "Sixty "<br /> Case 7: Result = "Seventy "<br /> Case 8: Result = "Eighty "<br /> Case 9: Result = "Ninety "<br /> Case Else<br /> End Select<br /> Result = Result & GetDigit _<br /> (Right(TensText, 1)) ' Retrieve ones place.<br />End If<br />GetTens = Result<br />End Function<br />' Converts a number from 1 to 9 into text.<br />Function GetDigit(Digit)<br /> Select Case Val(Digit)<br /> Case 1: GetDigit = "One"<br /> Case 2: GetDigit = "Two"<br /> Case 3: GetDigit = "Three"<br /> Case 4: GetDigit = "Four"<br /> Case 5: GetDigit = "Five"<br /> Case 6: GetDigit = "Six"<br /> Case 7: GetDigit = "Seven"<br /> Case 8: GetDigit = "Eight"<br /> Case 9: GetDigit = "Nine"<br /> Case Else: GetDigit = ""<br /> End Select<br />End Function<br /></code><code style="color: black; overflow-wrap: normal;"></code></pre>
<br />
<script
async=""
src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"
></script>
<ins
class="adsbygoogle"
data-ad-client="ca-pub-8542016316920624"
data-ad-format="fluid"
data-ad-layout="in-article"
data-ad-slot="6403984725"
style="display: block; text-align: center;"
></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<li>
Press <b><span class="hkey-hlight">Ctrl+S</span></b> to save the updated
workbook. <br /><br /><b>Note</b>: When you try to save the workbook with a
macro you'll get the message "<b
>The following features cannot be saved in macro-free workbook</b
>"<br /><br />
<table
align="center"
cellpadding="0"
cellspacing="0"
class="tr-caption-container"
style="margin-left: auto; margin-right: auto;"
>
<tbody>
<tr>
<td style="text-align: center;">
<a
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5_bmb43mmDZaSW7Gdwhff4oQG4aT7Hi3epZNfne0jxxCK0vKIl-2sWWK3gWKgiVGJvGMMrrE4ht5X-cbuEbRawaB40sV5vvwoSAKadfNDeo5oKg42aFwfz4oj8TB2l5e1WbTSr-0HQ-Q/s991/cannot-save-vbproject.png"
style="margin-left: auto; margin-right: auto;"
><img
alt="Cannot Save VBproject Image"
border="0"
data-original-height="279"
data-original-width="991"
height="176"
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5_bmb43mmDZaSW7Gdwhff4oQG4aT7Hi3epZNfne0jxxCK0vKIl-2sWWK3gWKgiVGJvGMMrrE4ht5X-cbuEbRawaB40sV5vvwoSAKadfNDeo5oKg42aFwfz4oj8TB2l5e1WbTSr-0HQ-Q/w625-h176/cannot-save-vbproject.png"
title="Cannot Save VBproject Image"
width="625"
/></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
Cannot Save VB Project
</td>
</tr>
</tbody>
</table>
<div class="separator" style="clear: both; text-align: center;"></div>
<br />Click <b>No</b>. When you see a new dialog, chose the
<b>Save As</b> option. In the field "<b>Save as type</b>" pick the option
"<b>Excel macro-enabled workbook</b>".<br /><br />
<table
align="center"
cellpadding="0"
cellspacing="0"
class="tr-caption-container"
style="margin-left: auto; margin-right: auto;"
>
<tbody>
<tr>
<td style="text-align: center;">
<a
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG5heSdxUMfF5PuTHuTgq87m5gpa7KAW8snogD9OSz_5jTN49XlYaxR5g4oMzsFzBmEW_yz9nNobytjUMr6w3eGlGD2Jiefgk9dykIRNh-GUxfRcP4xa7Fdj7ZSg_Fil33kkU-o-vKTx4/s1000/saveas-macro-enabled-excel-workbook.png"
style="margin-left: auto; margin-right: auto;"
><img
alt="SaveAs Macro Enabled Excel Workbook Image"
border="0"
data-original-height="771"
data-original-width="1000"
height="386"
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG5heSdxUMfF5PuTHuTgq87m5gpa7KAW8snogD9OSz_5jTN49XlYaxR5g4oMzsFzBmEW_yz9nNobytjUMr6w3eGlGD2Jiefgk9dykIRNh-GUxfRcP4xa7Fdj7ZSg_Fil33kkU-o-vKTx4/w500-h386/saveas-macro-enabled-excel-workbook.png"
title="SaveAs Macro Enabled Excel Workbook"
width="500"
/></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>SaveAs Macro Enabled Excel Workbook</b><br />
</td>
</tr>
</tbody>
</table>
<br />Congratulations! Now, you have added the <b>SpellNumber </b>UDF
Function to your workbook successfully.<br /><br />
<br />
<script
async=""
src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"
></script>
<ins
class="adsbygoogle"
data-ad-client="ca-pub-8542016316920624"
data-ad-format="fluid"
data-ad-layout="in-article"
data-ad-slot="6403984725"
style="display: block; text-align: center;"
></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
</li>
</ol>
<h3 style="text-align: left;">
Use SpellNumber function in your worksheets <br />
</h3>
<div style="text-align: left;">
<span style="font-weight: normal;"
>Now you can use the function <b>SpellNumber </b>in your Excel Workbook.
Enter <b>=SpellNumber(A12) </b>into the cell where you need to get the
number written in words. Here <b>A12 </b>is the address of the cell with the
number or amount. </span
>
</div>
<div style="text-align: left;">
<span style="font-weight: normal;"> </span>
</div>
<div style="text-align: left;">
<table
align="center"
cellpadding="0"
cellspacing="0"
class="tr-caption-container"
style="margin-left: auto; margin-right: auto;"
>
<tbody>
<tr>
<td style="text-align: center;">
<a
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhrJ0oO2Wgy3ZH7dG7wIxlgA8iMdX3VcN6gq82bpFojuP_YBdtLMyEyKWwtnHkYLgpH3onkZpG1248rY5kFDbmjIKfsgukCX8fYiL2j0vpACwTwSyvu70iAUxbLqHFwj2PjH_DA_2LPT4/s708/Spell+Number.gif"
style="margin-left: auto; margin-right: auto;"
><img
alt="Spell Number Function Example GIF Image"
border="0"
data-original-height="215"
data-original-width="708"
height="194"
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhrJ0oO2Wgy3ZH7dG7wIxlgA8iMdX3VcN6gq82bpFojuP_YBdtLMyEyKWwtnHkYLgpH3onkZpG1248rY5kFDbmjIKfsgukCX8fYiL2j0vpACwTwSyvu70iAUxbLqHFwj2PjH_DA_2LPT4/w640-h194/Spell+Number.gif"
title="Spell Number Function Example"
width="640"
/></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Spell Number Function Example</b>
</td>
</tr>
</tbody>
</table>
<h3 style="text-align: left;">Other Related UDF Functions:</h3>
<br />
<div style="text-align: left;">
<a href="http://bit.ly/UDF-To-Spell-USD-Amount-into-Words" target="_blank"
>UDF to Spell USD Amount into Words</a
>
</div>
<div style="text-align: left;">
<a href="http://bit.ly/UDF-To-Spell-Numbers-into-Words" target="_blank"
>UDF to Spell Numbers into Words</a
>
</div>
<br />
<script
async=""
src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"
></script>
<ins
class="adsbygoogle"
data-ad-client="ca-pub-8542016316920624"
data-ad-format="fluid"
data-ad-layout="in-article"
data-ad-slot="6403984725"
style="display: block; text-align: center;"
></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</span>
</div>Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com2tag:blogger.com,1999:blog-5616982869570753721.post-88646626332293568372020-09-23T20:26:00.007+05:302020-10-03T19:03:45.589+05:30Spell USD Amount into Words<p>
In the Microsoft Excel there is no default function that displays the numbers
into English words in a worksheet, but you can add this capability by creating
your own function by pasting the following
<b>SpellNumberToEnglish </b>function code into a VBA (Visual Basic for
Applications) module.
</p>
<p>
This function lets you convert the dollar and cent amounts to words with a
formula, so <b>$549.99</b> would read as
<b>Five Hundred Forty Nine Dollars and Ninety Nine Cents</b>. This can be very
useful if you're using Excel as a template to print Cheques/Checks.
</p>
<p>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
</p>
<p>
To add this function into your workbook, please follow the beneath steps:
<br />
</p>
<ol style="text-align: left;">
<li>Open the workbook where you want to spell the numbers.</li>
<li>
Press <b>Alt+F11</b> key from your keyboard to open the
<b>Visual Basic Editor (VBE)</b> window.
</li>
<li>
Click the <b class="ocpUI">Insert</b> tab in the VBE, and click
<span class="ocpUI">on the </span><b class="ocpUI">Module</b> option<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOi0jSxqQqJtcEwVQXjpklTntYYSCqrsotqyZvWukXVTAhg5eLJ52Ol49WAKIVuaw3XGHl71xPs2Z82-0cDVGjj0WaqaZBVsJEt52t1XDWWJOftyMirXJo-FaXDn4UD66_lOMohLCwVEU/s736/vba-editor-insert-module.png" style="margin-left: auto; margin-right: auto;"><img alt="VBE - Insert Module Image" border="0" data-original-height="325" data-original-width="736" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOi0jSxqQqJtcEwVQXjpklTntYYSCqrsotqyZvWukXVTAhg5eLJ52Ol49WAKIVuaw3XGHl71xPs2Z82-0cDVGjj0WaqaZBVsJEt52t1XDWWJOftyMirXJo-FaXDn4UD66_lOMohLCwVEU/w500-h220/vba-editor-insert-module.png" title="VBE - Insert Module" width="500" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>VBE - Insert Module</b><br />
</td>
</tr>
</tbody>
</table>
<br />
</li>
<li>
You will see a window named <b>YourWorkBook Name - Module1</b> as shown in
the below screenshot:<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNULdG5SSWrSemvQy7CjOKNSgvboi7V0A7jLfjvQVnESwiKz3jM91rY67jJhnrx0ycj1SV-G2t_HVOBu9rRNwJM8mUGaulohalyQIQROOD0jwCKFyIXF0lGlFYREofqqUUJHMaNRaZH7w/s1000/spell-number-excel-vba-module.png" style="margin-left: auto; margin-right: auto;"><img alt="Code window in Module Image" border="0" data-original-height="672" data-original-width="1000" height="336" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNULdG5SSWrSemvQy7CjOKNSgvboi7V0A7jLfjvQVnESwiKz3jM91rY67jJhnrx0ycj1SV-G2t_HVOBu9rRNwJM8mUGaulohalyQIQROOD0jwCKFyIXF0lGlFYREofqqUUJHMaNRaZH7w/w500-h336/spell-number-excel-vba-module.png" title="Code window in Module" width="500" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Code window in Module</b><br />
</td>
</tr>
</tbody>
</table>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
</li>
<li>Copy and Paste the following lines of codes in this module: <br /></li>
<pre style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 2px dashed rgb(204, 204, 204); color: black; font-family: "arial"; font-size: 14px; height: auto; line-height: 20px; overflow: auto; padding: 6px; text-align: left; width: 99%;"><code style="color: black; overflow-wrap: normal;">Function SpellNumberToEnglish </code><code style="color: black; overflow-wrap: normal;">(ByVal pNumber)<br /> Dim arr, xDecimal, xIndex, xHundred, xValue As Variant<br /> Dim Dollars, Cents<br /> arr = Array("", "", " Thousand ", " Million ", " Billion ", " Trillion ")<br /> pNumber = Trim(Str(pNumber))<br /> xDecimal = InStr(pNumber, ".")<br /> If xDecimal > 0 Then<br /> Cents = GetTens(Left(Mid(pNumber, xDecimal + 1) & "00", 2))<br /> pNumber = Trim(Left(pNumber, xDecimal - 1))<br /> End If<br /> xIndex = 1<br /> Do While pNumber <> ""<br /> xHundred = ""<br /> xValue = Right(pNumber, 3)<br /> If Val(xValue) <> 0 Then<br /> xValue = Right("000" & xValue, 3)<br /> If Mid(xValue, 1, 1) <> "0" Then<br /> xHundred = GetDigit(Mid(xValue, 1, 1)) & " Hundred "<br /> End If<br /> If Mid(xValue, 2, 1) <> "0" Then<br /> xHundred = xHundred & GetTens(Mid(xValue, 2))<br /> Else<br /> xHundred = xHundred & GetDigit(Mid(xValue, 3))<br /> End If<br /> End If<br /> If xHundred <> "" Then<br /> Dollars = xHundred & arr(xIndex) & Dollars<br /> End If<br /> If Len(pNumber) > 3 Then<br /> pNumber = Left(pNumber, Len(pNumber) - 3)<br /> Else<br /> pNumber = ""<br /> End If<br /> xIndex = xIndex + 1<br /> Loop<br /> Select Case Dollars<br /> Case ""<br /> Dollars = "No Dollars"<br /> Case "One"<br /> Dollars = "One Dollar"<br /> Case Else<br /> Dollars = Dollars & " Dollars"<br /> End Select<br /> Select Case Cents<br /> Case ""<br /> Cents = " And No Cents"<br /> Case "One"<br /> Cents = " And One Cent"<br /> Case Else<br /> Cents = " And " & Cents & " Cents"<br /> End Select<br /> SpellNumberToEnglish = Dollars & Cents<br />End Function<br />Private Function GetTens(pTens)<br /> Dim Result As String<br /> Result = ""<br /> If Val(Left(pTens, 1)) = 1 Then<br /> Select Case Val(pTens)<br /> Case 10: Result = "Ten"<br /> Case 11: Result = "Eleven"<br /> Case 12: Result = "Twelve"<br /> Case 13: Result = "Thirteen"<br /> Case 14: Result = "Fourteen"<br /> Case 15: Result = "Fifteen"<br /> Case 16: Result = "Sixteen"<br /> Case 17: Result = "Seventeen"<br /> Case 18: Result = "Eighteen"<br /> Case 19: Result = "Nineteen"<br /> Case Else<br /> End Select<br /> Else<br /> Select Case Val(Left(pTens, 1))<br /> Case 2: Result = "Twenty "<br /> Case 3: Result = "Thirty "<br /> Case 4: Result = "Forty "<br /> Case 5: Result = "Fifty "<br /> Case 6: Result = "Sixty "<br /> Case 7: Result = "Seventy "<br /> Case 8: Result = "Eighty "<br /> Case 9: Result = "Ninety "<br /> Case Else<br /> End Select<br /> Result = Result & GetDigit(Right(pTens, 1))<br /> End If<br /> GetTens = Result<br />End Function<br />Private Function GetDigit(pDigit)<br /> Select Case Val(pDigit)<br /> Case 1: GetDigit = "One"<br /> Case 2: GetDigit = "Two"<br /> Case 3: GetDigit = "Three"<br /> Case 4: GetDigit = "Four"<br /> Case 5: GetDigit = "Five"<br /> Case 6: GetDigit = "Six"<br /> Case 7: GetDigit = "Seven"<br /> Case 8: GetDigit = "Eight"<br /> Case 9: GetDigit = "Nine"<br /> Case Else: GetDigit = ""<br /> End Select<br />End Function</code></pre>
<li>
Press <b><span class="hkey-hlight">Ctrl+S</span></b> to save the updated
workbook. <br /><br /><b>Note</b>: When you try to save the workbook with a
macro you'll get the message "<b>The following features cannot be saved in macro-free workbook</b>"<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5_bmb43mmDZaSW7Gdwhff4oQG4aT7Hi3epZNfne0jxxCK0vKIl-2sWWK3gWKgiVGJvGMMrrE4ht5X-cbuEbRawaB40sV5vvwoSAKadfNDeo5oKg42aFwfz4oj8TB2l5e1WbTSr-0HQ-Q/s991/cannot-save-vbproject.png" style="margin-left: auto; margin-right: auto;"><img alt="Cannot Save VBproject Image" border="0" data-original-height="279" data-original-width="991" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5_bmb43mmDZaSW7Gdwhff4oQG4aT7Hi3epZNfne0jxxCK0vKIl-2sWWK3gWKgiVGJvGMMrrE4ht5X-cbuEbRawaB40sV5vvwoSAKadfNDeo5oKg42aFwfz4oj8TB2l5e1WbTSr-0HQ-Q/w625-h176/cannot-save-vbproject.png" title="Cannot Save VBproject Image" width="625" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
Cannot Save VB Project
</td>
</tr>
</tbody>
</table>
<div class="separator" style="clear: both; text-align: center;"></div>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />Click <b>No</b>. When you see a new dialog, chose the
<b>Save As</b> option. In the field "<b>Save as type</b>" pick the option
"<b>Excel macro-enabled workbook</b>".<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG5heSdxUMfF5PuTHuTgq87m5gpa7KAW8snogD9OSz_5jTN49XlYaxR5g4oMzsFzBmEW_yz9nNobytjUMr6w3eGlGD2Jiefgk9dykIRNh-GUxfRcP4xa7Fdj7ZSg_Fil33kkU-o-vKTx4/s1000/saveas-macro-enabled-excel-workbook.png" style="margin-left: auto; margin-right: auto;"><img alt="SaveAs Macro Enabled Excel Workbook Image" border="0" data-original-height="771" data-original-width="1000" height="386" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG5heSdxUMfF5PuTHuTgq87m5gpa7KAW8snogD9OSz_5jTN49XlYaxR5g4oMzsFzBmEW_yz9nNobytjUMr6w3eGlGD2Jiefgk9dykIRNh-GUxfRcP4xa7Fdj7ZSg_Fil33kkU-o-vKTx4/w500-h386/saveas-macro-enabled-excel-workbook.png" title="SaveAs Macro Enabled Excel Workbook" width="500" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>SaveAs Macro Enabled Excel Workbook</b><br />
</td>
</tr>
</tbody>
</table>
<br />Congratulations! Now, you have added the
<b>SpellNumberToEnglish </b>UDF Function to your workbook successfully.<br />
</li>
</ol>
<h3 style="text-align: left;">
Use SpellNumberToEnglish function in your worksheets
</h3><br />
<div style="text-align: left;">
<span style="font-weight: normal;">Now you can use the function <b>SpellNumberToEnglish </b>in your Excel
Workbook. Enter <b>=SpellNumberToEnglish(A2)</b> into the cell where you
need to get the number written in words. Here <b>A2</b> is the address of
the cell with the number or amount. </span>
</div>
<div style="text-align: left;">
<span style="font-weight: normal;"> </span>
</div>
<div style="text-align: left;">
<span style="font-weight: normal;"><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJhQjzhbmPOZ2wqsKv2LthV30miLY4akSQ8udCtUB4IXgiC5ElMuNsBHEXbqkpC4BvI_piEcEQP8Ln9m6ZHIA7mq5q1fEfu1TXhxsFG6kjCkOf58fvMFKKW2v0iW-P6Ej7JMNkuRXYL3A/s708/Spell+Number+to+English.gif" style="margin-left: auto; margin-right: auto;"><img alt="Spell Number To English Function Example GIF Image" border="0" data-original-height="215" data-original-width="708" height="194" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJhQjzhbmPOZ2wqsKv2LthV30miLY4akSQ8udCtUB4IXgiC5ElMuNsBHEXbqkpC4BvI_piEcEQP8Ln9m6ZHIA7mq5q1fEfu1TXhxsFG6kjCkOf58fvMFKKW2v0iW-P6Ej7JMNkuRXYL3A/w640-h194/Spell+Number+to+English.gif" title="Spell Number To English Function Example" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Spell Number To English Function Example</b><br />
</td>
</tr>
</tbody>
</table>
<h3 style="text-align: left;">Other Related UDF Functions:</h3><br />
<a href="http://bit.ly/UDF-To-Spell-INR-Amount-into-Words" target="_blank">UDF to Spell INR Amount into Words</a>
<div style="text-align: left;">
<a href="http://bit.ly/UDF-To-Spell-Numbers-into-Words" target="_blank">UDF to Spell Numbers into Words</a>
</div>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
</span>
</div>Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com6tag:blogger.com,1999:blog-5616982869570753721.post-69399255981521187202020-09-23T20:22:00.008+05:302020-10-05T16:40:28.472+05:30Spell Numbers into Words<p>
In the Microsoft Excel there is no default function that displays the numbers
into words in a worksheet, but you can add this capability by creating your
own function by pasting the following <b>WordNum </b>function code into a VBA
(Visual Basic for Applications) module.
</p>
<p>
This function lets you convert or spell any number into words with a formula,
so<b> 4,563.76</b> would read as
<b>Four thousand Five hundred and Sixty Three point Seven Six</b>.
</p>
<p>
To add this function into your workbook, please follow the beneath steps:
<br />
</p>
<ol style="text-align: left;">
<li>Open the workbook where you want to spell the numbers.</li>
<li>
Press <b>Alt+F11</b> key from your keyboard to open the
<b>Visual Basic Editor (VBE)</b> window.
</li>
<li>
Click the <b class="ocpUI">Insert</b> tab in the VBE, and click
<span class="ocpUI">on the </span><b class="ocpUI">Module</b> option<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOi0jSxqQqJtcEwVQXjpklTntYYSCqrsotqyZvWukXVTAhg5eLJ52Ol49WAKIVuaw3XGHl71xPs2Z82-0cDVGjj0WaqaZBVsJEt52t1XDWWJOftyMirXJo-FaXDn4UD66_lOMohLCwVEU/s736/vba-editor-insert-module.png" style="margin-left: auto; margin-right: auto;"><img alt="VBE - Insert Module Image" border="0" data-original-height="325" data-original-width="736" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOi0jSxqQqJtcEwVQXjpklTntYYSCqrsotqyZvWukXVTAhg5eLJ52Ol49WAKIVuaw3XGHl71xPs2Z82-0cDVGjj0WaqaZBVsJEt52t1XDWWJOftyMirXJo-FaXDn4UD66_lOMohLCwVEU/w500-h220/vba-editor-insert-module.png" title="VBE - Insert Module" width="500" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>VBE - Insert Module</b><br />
</td>
</tr>
</tbody>
</table>
<br />
</li>
<li>
You will see a window named <b>YourWorkBook Name - Module1</b> as shown in
the below screenshot:<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNULdG5SSWrSemvQy7CjOKNSgvboi7V0A7jLfjvQVnESwiKz3jM91rY67jJhnrx0ycj1SV-G2t_HVOBu9rRNwJM8mUGaulohalyQIQROOD0jwCKFyIXF0lGlFYREofqqUUJHMaNRaZH7w/s1000/spell-number-excel-vba-module.png" style="margin-left: auto; margin-right: auto;"><img alt="Code window in Module Image" border="0" data-original-height="672" data-original-width="1000" height="336" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNULdG5SSWrSemvQy7CjOKNSgvboi7V0A7jLfjvQVnESwiKz3jM91rY67jJhnrx0ycj1SV-G2t_HVOBu9rRNwJM8mUGaulohalyQIQROOD0jwCKFyIXF0lGlFYREofqqUUJHMaNRaZH7w/w500-h336/spell-number-excel-vba-module.png" title="Code window in Module" width="500" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Code window in Module</b><br />
</td>
</tr>
</tbody>
</table>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
</li>
<li>Copy and Paste the following lines of codes in this module: <br /></li>
<pre style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 2px dashed rgb(204, 204, 204); color: black; font-family: arial; font-size: 14px; height: auto; line-height: 20px; overflow: auto; padding: 6px; text-align: left; width: 99%;"><code style="color: black; overflow-wrap: normal;">Option Explicit<br /><br />'Use function "WordNum"<br /><br />Public Numbers As Variant, Tens As Variant<br /><br />Private Sub SetNums()<br /> Numbers = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen")<br /> Tens = Array("", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")<br />End Sub<br /><br />Function WordNum(MyNumber As Double) As String<br /> Dim DecimalPosition As Integer, ValNo As Variant, StrNo As String<br /> Dim NumStr As String, n As Integer, Temp1 As String, Temp2 As String<br /> ' This macro was written by Chris Mead - www.MeadInKent.co.uk<br /> If Abs(MyNumber) > 999999999 Then<br /> WordNum = "Value too large"<br /> Exit Function<br /> End If<br /> SetNums<br /> ' String representation of amount (excl decimals)<br /> NumStr = Right("000000000" & Trim(Str(Int(Abs(MyNumber)))), 9)<br /> ValNo = Array(0, Val(Mid(NumStr, 1, 3)), Val(Mid(NumStr, 4, 3)), Val(Mid(NumStr, 7, 3)))<br /> For n = 3 To 1 Step -1 'analyse the absolute number as 3 sets of 3 digits<br /> StrNo = Format(ValNo(n), "000")<br /> If ValNo(n) > 0 Then<br /> Temp1 = GetTens(Val(Right(StrNo, 2)))<br /> If Left(StrNo, 1) <> "0" Then<br /> Temp2 = Numbers(Val(Left(StrNo, 1))) & " hundred"<br /> If Temp1 <> "" Then Temp2 = Temp2 & " and "<br /> Else<br /> Temp2 = ""<br /> End If<br /> If n = 3 Then<br /> If Temp2 = "" And ValNo(1) + ValNo(2) > 0 Then Temp2 = "and "<br /> WordNum = Trim(Temp2 & Temp1)<br /> End If<br /> If n = 2 Then WordNum = Trim(Temp2 & Temp1 & " thousand " & WordNum)<br /> If n = 1 Then WordNum = Trim(Temp2 & Temp1 & " million " & WordNum)<br /> End If<br /> Next n<br /> NumStr = Trim(Str(Abs(MyNumber)))<br /> ' Values after the decimal place<br /> DecimalPosition = InStr(NumStr, ".")<br /> Numbers(0) = "Zero"<br /> If DecimalPosition > 0 And DecimalPosition < Len(NumStr) Then<br /> Temp1 = " point"<br /> For n = DecimalPosition + 1 To Len(NumStr)<br /> Temp1 = Temp1 & " " & Numbers(Val(Mid(NumStr, n, 1)))<br /> Next n<br /> WordNum = WordNum & Temp1<br /> End If<br /> If Len(WordNum) = 0 Or Left(WordNum, 2) = " p" Then<br /> WordNum = "Zero" & WordNum<br /> End If<br />End Function<br /><br />Function GetTens(TensNum As Integer) As String<br />' Converts a number from 0 to 99 into text.<br /> If TensNum <= 19 Then<br /> GetTens = Numbers(TensNum)<br /> Else<br /> Dim MyNo As String<br /> MyNo = Format(TensNum, "00")<br /> GetTens = Tens(Val(Left(MyNo, 1))) & " " & Numbers(Val(Right(MyNo, 1)))<br /> End If<br />End Function</code><code style="color: black; overflow-wrap: normal;"></code></pre>
<li>
Press <b><span class="hkey-hlight">Ctrl+S</span></b> to save the updated
workbook. <br /><br /><b>Note</b>: When you try to save the workbook with a
macro you'll get the message "<b>The following features cannot be saved in macro-free workbook</b>"<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5_bmb43mmDZaSW7Gdwhff4oQG4aT7Hi3epZNfne0jxxCK0vKIl-2sWWK3gWKgiVGJvGMMrrE4ht5X-cbuEbRawaB40sV5vvwoSAKadfNDeo5oKg42aFwfz4oj8TB2l5e1WbTSr-0HQ-Q/s991/cannot-save-vbproject.png" style="margin-left: auto; margin-right: auto;"><img alt="Cannot Save VBproject Image" border="0" data-original-height="279" data-original-width="991" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5_bmb43mmDZaSW7Gdwhff4oQG4aT7Hi3epZNfne0jxxCK0vKIl-2sWWK3gWKgiVGJvGMMrrE4ht5X-cbuEbRawaB40sV5vvwoSAKadfNDeo5oKg42aFwfz4oj8TB2l5e1WbTSr-0HQ-Q/w625-h176/cannot-save-vbproject.png" title="Cannot Save VBproject Image" width="625" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Cannot Save VB Project</b>
</td>
</tr>
</tbody>
</table>
<div class="separator" style="clear: both; text-align: center;"></div>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />Click <b>No</b>. When you see a new dialog, chose the
<b>Save As</b> option. In the field "<b>Save as type</b>" pick the option
"<b>Excel macro-enabled workbook</b>".<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG5heSdxUMfF5PuTHuTgq87m5gpa7KAW8snogD9OSz_5jTN49XlYaxR5g4oMzsFzBmEW_yz9nNobytjUMr6w3eGlGD2Jiefgk9dykIRNh-GUxfRcP4xa7Fdj7ZSg_Fil33kkU-o-vKTx4/s1000/saveas-macro-enabled-excel-workbook.png" style="margin-left: auto; margin-right: auto;"><img alt="SaveAs Macro Enabled Excel Workbook Image" border="0" data-original-height="771" data-original-width="1000" height="386" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhG5heSdxUMfF5PuTHuTgq87m5gpa7KAW8snogD9OSz_5jTN49XlYaxR5g4oMzsFzBmEW_yz9nNobytjUMr6w3eGlGD2Jiefgk9dykIRNh-GUxfRcP4xa7Fdj7ZSg_Fil33kkU-o-vKTx4/w500-h386/saveas-macro-enabled-excel-workbook.png" title="SaveAs Macro Enabled Excel Workbook" width="500" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>SaveAs Macro Enabled Excel Workbook</b><br />
</td>
</tr>
</tbody>
</table>
<br />Congratulations! Now, you have added the <b>WordNum</b><b> </b>UDF
Function to your workbook successfully.<br />
</li>
</ol>
<h3 style="text-align: left;">
Use <b>WordNum </b>function in your worksheets
</h3><br />
<div style="text-align: left;">
<span style="font-weight: normal;">Now you can use the function </span><span style="font-weight: normal;"><b>WordNum </b>in your Excel Workbook. Enter <b>=</b></span><span style="font-weight: normal;"><b><b>WordNum</b>(A22) </b>into the cell where you need to get the number
written in words. Here <b>A22 </b>is the address of the cell with the
number. </span>
</div>
<div style="text-align: left;">
<span style="font-weight: normal;"> </span>
</div>
<div style="text-align: left;">
<span style="font-weight: normal;"><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP-RIDmv3it8Woplkz1RkWkfxXdy4XHs1DiwPDAbpkYQqTDoqQpY3vxd54aFMO2YnGv7pETHo9OPu8zHlLcR-1qyrjtv4AD9KdE7YN3ttuBpz62z81nG8lfb943tNHkjQj6RBDHd0NiLo/s708/Word+Number.gif" style="margin-left: auto; margin-right: auto;"><img alt="WordNum Function Example GIF Image" border="0" data-original-height="215" data-original-width="708" height="194" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP-RIDmv3it8Woplkz1RkWkfxXdy4XHs1DiwPDAbpkYQqTDoqQpY3vxd54aFMO2YnGv7pETHo9OPu8zHlLcR-1qyrjtv4AD9KdE7YN3ttuBpz62z81nG8lfb943tNHkjQj6RBDHd0NiLo/w640-h194/Word+Number.gif" title="WordNum Function Example" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>WordNum Function Example<br /></b>
</td>
</tr>
</tbody>
</table>
</span>
</div>
<div style="text-align: left;">
<h3 style="text-align: left;">Other Related UDF Functions:</h3><br />
<a href="http://bit.ly/UDF-To-Spell-INR-Amount-into-Words" target="_blank">UDF to Spell INR Amount into Words</a>
</div>
<div style="text-align: left;">
<a href="http://bit.ly/UDF-To-Spell-USD-Amount-into-Words" target="_blank">UDF to Spell USD Amount into Words</a>
</div>
<span style="font-weight: normal;"><br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br /></span>Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-77405494315258477352020-08-31T09:00:00.000+05:302020-08-31T09:00:07.256+05:30How to Assign a Macro<!--Assign a Macro Start-->
<div>
In this tutorial we are going to explain how you can <b>Assign a Macro</b> to
the Command Button in the Microsoft Excel.<br /><br />To assign a macro (one
or more code lines) to the command button, execute the following steps:<br />
<ol style="text-align: left;">
<li>
Right click <b>CommandButton1 </b>(make sure Design Mode is selected).
</li>
<li>
Click <b>View Code</b>.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUEFgL0QGUR_IRbgs8M4NsNXyL5-WB2v-zL7UB7bIVoxTAjZ6sH8fgVc_IyGI58lvUZhywbkvHQMjcr1qv5phZ5Shk5df_aXaI4GEjBaoRGTiO__AiZm9q-F2aCV-29hK8W1NLqGeTQ90/s970/View+Code.png" style="margin-left: auto; margin-right: auto;"><img alt="View Code Image" border="0" data-original-height="790" data-original-width="970" height="521" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUEFgL0QGUR_IRbgs8M4NsNXyL5-WB2v-zL7UB7bIVoxTAjZ6sH8fgVc_IyGI58lvUZhywbkvHQMjcr1qv5phZ5Shk5df_aXaI4GEjBaoRGTiO__AiZm9q-F2aCV-29hK8W1NLqGeTQ90/w640-h521/View+Code.png" title="View Code" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>View Code</b>
</td>
</tr>
</tbody>
</table>
The Visual Basic Editor appears.<br /><br />
</li>
<li>
Place your cursor between <b>Private Sub CommandButton1_Click()</b> and <b>End Sub</b>.
</li>
<li> Add the code line shown below:
<pre style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 2px dashed rgb(204, 204, 204); color: black; font-family: "arial"; font-size: 14px; height: auto; line-height: 20px; overflow: auto; padding: 6px; text-align: left; width: 99%;"> <code style="color: black; overflow-wrap: normal;">Range("A1").Value = "Hello"</code>
</pre>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinwJPxDP9-IcFC7YtAf90BpadsPvk6pZnSfja3lwgv9UBQQ1618Hl8ZIxETcZa_VhLWIfAUKr8gLw1SEJADIAU54o-b6E0yCVtHMLlxxc4-xwi3ljWZGUVGnKAu4X2groPjqvB5S232YM/s1239/Add+Code+Lines.png" style="margin-left: auto; margin-right: auto;"><img alt="Add Code Line Image" border="0" data-original-height="590" data-original-width="1239" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinwJPxDP9-IcFC7YtAf90BpadsPvk6pZnSfja3lwgv9UBQQ1618Hl8ZIxETcZa_VhLWIfAUKr8gLw1SEJADIAU54o-b6E0yCVtHMLlxxc4-xwi3ljWZGUVGnKAu4X2groPjqvB5S232YM/w640-h305/Add+Code+Lines.png" title="Add Code Line" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Add Code Line</b><br />
</td>
</tr>
</tbody>
</table>
<b>Note: </b>The window on the left with the name <b>Sheet1 (Sheet1)</b>
and <b>ThisWorkbook </b>is called the <b>Project Explorer</b>. If the Project Explorer
is not visible, click on <b>View</b> menu and then click on <b>Project Explorer</b>. If the Code window for
Sheet1 is not visible, click Sheet1 (Sheet1). You can ignore the
<a href="https://bit.ly/3eHJC2a" target="_blank">Option Explicit</a>
statement for now.<br /><br />
</li>
<li><b>Close </b>the <b>Visual Basic Editor</b>.</li>
<li>
<b>Click </b>the <b>command button</b> on the sheet (<b>make sure Design Mode is
deselected</b>).
</li>
</ol>
<h4 style="text-align: left;">Result:</h4>
</div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN540FHIl9Hz64ksX-0pE5n1qhtj64ed14n4tKmtnLxertIzQDKSbbL2uRbebYzTWpsQ2Qqicu0xtA-m5leH7zSIYuys-f9iFU_WCU530to8jxD2qL9TJGAUjjMG2EgA3Hyh2F2qH91jA/s1485/Macro+Result.png" style="margin-left: auto; margin-right: auto;"><img alt="Macro Result Image" border="0" data-original-height="284" data-original-width="1485" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN540FHIl9Hz64ksX-0pE5n1qhtj64ed14n4tKmtnLxertIzQDKSbbL2uRbebYzTWpsQ2Qqicu0xtA-m5leH7zSIYuys-f9iFU_WCU530to8jxD2qL9TJGAUjjMG2EgA3Hyh2F2qH91jA/w640-h122/Macro+Result.png" title="Macro Result" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Macro Result</b><br />
</td>
</tr>
</tbody>
</table>
Congratulations. You've just created a macro in Excel!<br /><br />
<!--Assign a Macro END-->
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0India20.593684 78.96288-25.846843327558805 8.6503799999999984 67.034211327558808 149.27537999999998tag:blogger.com,1999:blog-5616982869570753721.post-85824214970026114782020-08-29T09:00:00.001+05:302020-08-29T09:00:00.491+05:30How to Insert a Command Button<div>
In this tutorial we are going to explain how you can <b>Insert the Command Button</b>
in the Microsoft Excel.
<br /><br /></div>
<div>
To place a <b>command button</b> into your worksheet, execute the following
steps:
<ol style="text-align: left;">
<li>In the <a href="https://bit.ly/32qwwBM" target="_blank">Developer tab</a>, click on <b>Insert </b>option.</li>
<li>
In the <b>ActiveX Controls</b> group, click on <b>Command </b>Button. <br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6L_vGHXgeDbqUbYtiWYlQJvZEV42SmcsM1wG_ddvbHIt5LQs0-THEMlSdcpiFyAizx-iYXhyphenhyphen74nH_c-Jvf_TyL1a0v5rA4z-ZY44VLfUXWCTjfAJEGOUtcUXWNI23zI5CFDUMsOACgs4/s1354/Insert+Command+Button+Control.png" style="margin-left: auto; margin-right: auto;"><img alt="Insert Command Button Control Image" border="0" data-original-height="628" data-original-width="1354" height="297" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6L_vGHXgeDbqUbYtiWYlQJvZEV42SmcsM1wG_ddvbHIt5LQs0-THEMlSdcpiFyAizx-iYXhyphenhyphen74nH_c-Jvf_TyL1a0v5rA4z-ZY44VLfUXWCTjfAJEGOUtcUXWNI23zI5CFDUMsOACgs4/w640-h297/Insert+Command+Button+Control.png" title="Insert Command Button Control" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Insert Command Button Control</b><br />
</td>
</tr>
</tbody>
</table>
<br />
</li>
<li>Drag a command button on your worksheet.</li>
</ol>
</div>
<!--Command Button END-->
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-35701278053280219962020-08-28T09:00:00.001+05:302020-08-28T09:00:00.245+05:30How to Show Developer Tab<!--Developer Tab Start-->In this tutorial we are going to explain how you can turn on the Developer Tab
in the Microsoft Excel.<br /><div style="text-align: left;"><br />To turn on the <b>Developer tab</b>,
execute the following steps.<br />
<ol>
<li>
Right click anywhere on the ribbon, and then click Customize the Ribbon
(as shown in the below screenshot). <br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWBYyhP994jJFQMcumb_XrnCghwZ8OfJQLR-hrjoAaBTAQBtrxS7_mIRShI0RxZxDeLp4EGwVQfJ1FBThOgZYV23AKU_GxZXJlkPdGDyU31Xb7nQ0gmqBBor30Fgx5fGxszi795GTCy1U/s1440/Customize+Ribbon.png" style="margin-left: auto; margin-right: auto;"><img alt="Customize Ribbon Image" border="0" data-original-height="537" data-original-width="1440" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWBYyhP994jJFQMcumb_XrnCghwZ8OfJQLR-hrjoAaBTAQBtrxS7_mIRShI0RxZxDeLp4EGwVQfJ1FBThOgZYV23AKU_GxZXJlkPdGDyU31Xb7nQ0gmqBBor30Fgx5fGxszi795GTCy1U/w640-h239/Customize+Ribbon.png" title="Customize Ribbon" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Customize Ribbon</b><br />
</td>
</tr>
</tbody>
</table>
Alternatively, you can go to <b>File </b>Menu then Click on <b>Options </b>and then
click on <b>Customize the Ribbon</b> option shown in the left pane of the <b>Excel
Options</b> window, the same window will open as shown you in the below image.<br /><br />
</li>
<li>
Under <b>Customize the Ribbon</b>, on the right side of the dialog box,
select Main tabs (if necessary).
</li>
<li>
Check the <b>Developer </b>check box.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqIpBqAkMGO6Iz5hY6p1eo5Aw_OqkDCN48Zj_1yYxNJa1dyyL3QOWb2UI69jgMT81zf4tw1uUGebVq5dkSEDgyEVB3l3YVPP4___lFVVBVCOGWg89bXUKLfF5gopNK6vgCOzFfu_Sn0rI/s1029/Turn+On+Developer+Tab.png" style="margin-left: auto; margin-right: auto;"><img alt="Turn On Developer Tab Image" border="0" data-original-height="888" data-original-width="1029" height="552" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqIpBqAkMGO6Iz5hY6p1eo5Aw_OqkDCN48Zj_1yYxNJa1dyyL3QOWb2UI69jgMT81zf4tw1uUGebVq5dkSEDgyEVB3l3YVPP4___lFVVBVCOGWg89bXUKLfF5gopNK6vgCOzFfu_Sn0rI/w640-h552/Turn+On+Developer+Tab.png" title="Turn On Developer Tab" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Turn On Developer Tab</b><br />
</td>
</tr>
</tbody>
</table>
</li>
<li>Click <b>OK</b>.</li>
<li>
You can find the <b>Developer tab</b> next to the <b>View </b>tab.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhed0OaBFqLVOff3s5HDge5Yt0LMq8G7uRlPBft7i2X4OkJes4WiiNqw51A-VXHm2jq-3FUSytclqP62ehOVyeChC8-ChJ-x2FkimtfOB1zxVw_HLa_C8rjoQ386xNJ0bGkS6kNHgUubJ8/s1320/Developer+Tab.png" style="margin-left: auto; margin-right: auto;"><img alt="Developer Tab Image" border="0" data-original-height="260" data-original-width="1320" height="126" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhed0OaBFqLVOff3s5HDge5Yt0LMq8G7uRlPBft7i2X4OkJes4WiiNqw51A-VXHm2jq-3FUSytclqP62ehOVyeChC8-ChJ-x2FkimtfOB1zxVw_HLa_C8rjoQ386xNJ0bGkS6kNHgUubJ8/w640-h126/Developer+Tab.png" title="Developer Tab" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Developer Tab</b><br />
</td>
</tr>
</tbody>
</table>
</li>
</ol>
</div>
<!--Developer Tab END-->
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-63528683997939853342020-08-27T09:00:00.003+05:302020-08-27T09:00:02.163+05:30How to Open Visual Basic Editor <!--Visual Basic Editor Start-->
<div>
<h3 style="text-align: left;">
</h3>
In this tutorial we are going to explain how you can open the <b>Visual Basic
Editor</b> in the <b>Microsoft Excel</b>.</div><div></div><div><br />To open the <b>Visual Basic Editor</b>, Go to the <a href="https://bit.ly/32qwwBM" target="_blank">Developer tab</a> and then click on <b>Visual Basic</b>. OR Press <b>Alt+F11 </b>key from your keyboard.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvrBgSGnMZPhJM1cisQ9Vq0Zu9U2Ud6yvK_1nhSEx_KTzQ23VDsqaDr4g2KvXsQ0O7LlLGq-Rj8Rpzut9aO9e2zoUo15h7mw0MhxSYOs_xOELVCamq1rURLr7stlkUOCN0FwvTufkQPw4/s1528/Open+Visual+Basic+Editor.png" style="margin-left: auto; margin-right: auto;"><img alt="Open Visual Basic Editor Image" border="0" data-original-height="733" data-original-width="1528" height="307" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvrBgSGnMZPhJM1cisQ9Vq0Zu9U2Ud6yvK_1nhSEx_KTzQ23VDsqaDr4g2KvXsQ0O7LlLGq-Rj8Rpzut9aO9e2zoUo15h7mw0MhxSYOs_xOELVCamq1rURLr7stlkUOCN0FwvTufkQPw4/w640-h307/Open+Visual+Basic+Editor.png" title="Open Visual Basic Editor" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Open Visual Basic Editor</b><br />
</td>
</tr>
</tbody>
</table>
The Visual Basic Editor appears.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibIgMD_DQUN2OMQLeSdV1CxoJ9clzjIir6tTbVdyII53mvKxUqLQdgVv3EfEc_KlexB-PgMZ7wzv4QlNJRoHFf-WaxuhG9cnOjyiJuHPbfANcBmwL89as3k2uFgkLOM-HDlFZK5xttlaY/s1452/Visual+Basic+Editor.png" style="margin-left: auto; margin-right: auto;"><img alt="Visual Basic Editor Image" border="0" data-original-height="666" data-original-width="1452" height="294" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibIgMD_DQUN2OMQLeSdV1CxoJ9clzjIir6tTbVdyII53mvKxUqLQdgVv3EfEc_KlexB-PgMZ7wzv4QlNJRoHFf-WaxuhG9cnOjyiJuHPbfANcBmwL89as3k2uFgkLOM-HDlFZK5xttlaY/w640-h294/Visual+Basic+Editor.png" title="Visual Basic Editor" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Visual Basic Editor</b><br />
</td>
</tr>
</tbody>
</table>
</div>
<!--Visual Basic Editor END-->
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-82735836084166233132020-08-26T17:22:00.004+05:302020-08-26T18:38:31.423+05:30Create Your First VBA Macro<p>
In this tutorial, we are going to explain you the
<b>Basics of a VBA Macro</b> in the <b>Microsoft Excel</b> and step-by-step guide to create your first VBA Macro.
</p>
<h3 style="text-align: left;">What is a Macro?</h3>
<p>
A series of commands or instructions that are combined to form a single
command are known as Macros. Macros are getting created by writing the VBA
code with the set of instruction in the Visual Basic Editor of Microsoft
Excel.
</p>
<h3 style="text-align: left;">Benefits of a Macro</h3>
<p>
Macros can save your time by letting you automate relatively simple tasks that
you need to perform often, as well as complex procedures that consist of many
steps.
</p>
<p>
In this tutorial, you will learn how to create a simple macro which will be
executed after clicking on a command button. To do so, First, turn on the
Developer tab.<br /><br />Click on the below respective link to know, how to <b>Turn On the Developer Tab</b> or <b>Insert Command Button </b>or <b>Assign a Macro</b> to the command button or how to <b>open Visual Basic Editor
</b> in the Microsoft Excel.
</p>
<p>
<a href="#developer-tab">Developer Tab</a> |
<a href="#command-button">Command Button</a> |
<a href="#assign-macro">Assign a Macro</a> |
<a href="#visual-basic-editor">Visual Basic Editor</a>
</p>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<!--Developer Tab Start-->
<h3 style="text-align: left;">
<a id="developer-tab" name="developer-tab"></a>Developer Tab:<br />
</h3>
<div style="text-align: left;">
In this tutorial we are going to explain how you can turn on the Developer Tab
in the Microsoft Excel.<br /><br />To turn on the <b>Developer tab</b>,
execute the following steps.<br />
<ol>
<li>
Right click anywhere on the ribbon, and then click Customize the Ribbon
(as shown in the below screenshot). <br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWBYyhP994jJFQMcumb_XrnCghwZ8OfJQLR-hrjoAaBTAQBtrxS7_mIRShI0RxZxDeLp4EGwVQfJ1FBThOgZYV23AKU_GxZXJlkPdGDyU31Xb7nQ0gmqBBor30Fgx5fGxszi795GTCy1U/s1440/Customize+Ribbon.png" style="margin-left: auto; margin-right: auto;"><img alt="Customize Ribbon Image" border="0" data-original-height="537" data-original-width="1440" height="239" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWBYyhP994jJFQMcumb_XrnCghwZ8OfJQLR-hrjoAaBTAQBtrxS7_mIRShI0RxZxDeLp4EGwVQfJ1FBThOgZYV23AKU_GxZXJlkPdGDyU31Xb7nQ0gmqBBor30Fgx5fGxszi795GTCy1U/w640-h239/Customize+Ribbon.png" title="Customize Ribbon" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Customize Ribbon</b><br />
</td>
</tr>
</tbody>
</table>
Alternatively, you can go to <b>File </b>Menu then Click on <b>Options </b>and then
click on <b>Customize the Ribbon</b> option shown in the left pane of the <b>Excel
Options</b> window, the same window will open as shown you in the below image.<br /><br />
</li>
<li>
Under <b>Customize the Ribbon</b>, on the right side of the dialog box,
select Main tabs (if necessary).
</li>
<li>
Check the <b>Developer </b>check box.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqIpBqAkMGO6Iz5hY6p1eo5Aw_OqkDCN48Zj_1yYxNJa1dyyL3QOWb2UI69jgMT81zf4tw1uUGebVq5dkSEDgyEVB3l3YVPP4___lFVVBVCOGWg89bXUKLfF5gopNK6vgCOzFfu_Sn0rI/s1029/Turn+On+Developer+Tab.png" style="margin-left: auto; margin-right: auto;"><img alt="Turn On Developer Tab Image" border="0" data-original-height="888" data-original-width="1029" height="552" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqIpBqAkMGO6Iz5hY6p1eo5Aw_OqkDCN48Zj_1yYxNJa1dyyL3QOWb2UI69jgMT81zf4tw1uUGebVq5dkSEDgyEVB3l3YVPP4___lFVVBVCOGWg89bXUKLfF5gopNK6vgCOzFfu_Sn0rI/w640-h552/Turn+On+Developer+Tab.png" title="Turn On Developer Tab" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Turn On Developer Tab</b><br />
</td>
</tr>
</tbody>
</table>
</li>
<li>Click <b>OK</b>.</li>
<li>
You can find the <b>Developer tab</b> next to the <b>View </b>tab.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhed0OaBFqLVOff3s5HDge5Yt0LMq8G7uRlPBft7i2X4OkJes4WiiNqw51A-VXHm2jq-3FUSytclqP62ehOVyeChC8-ChJ-x2FkimtfOB1zxVw_HLa_C8rjoQ386xNJ0bGkS6kNHgUubJ8/s1320/Developer+Tab.png" style="margin-left: auto; margin-right: auto;"><img alt="Developer Tab Image" border="0" data-original-height="260" data-original-width="1320" height="126" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhed0OaBFqLVOff3s5HDge5Yt0LMq8G7uRlPBft7i2X4OkJes4WiiNqw51A-VXHm2jq-3FUSytclqP62ehOVyeChC8-ChJ-x2FkimtfOB1zxVw_HLa_C8rjoQ386xNJ0bGkS6kNHgUubJ8/w640-h126/Developer+Tab.png" title="Developer Tab" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Developer Tab</b><br />
</td>
</tr>
</tbody>
</table>
</li>
</ol>
</div>
<!--Developer Tab END-->
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<!--Command Button Start-->
<div>
<h3 style="text-align: left;"> <a id="command-button" name="command-button"></a> Command Button:</h3>
In this tutorial we are going to explain how you can <b>Insert the Command Button</b>
in the Microsoft Excel.
</div>
<div> </div>
<div>
To place a <b>command button</b> into your worksheet, execute the following
steps:
<ol style="text-align: left;">
<li>In the <a href="#developer-tab">Developer tab</a>, click on <b>Insert </b>option.</li>
<li>
In the <b>ActiveX Controls</b> group, click on <b>Command </b>Button. <br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6L_vGHXgeDbqUbYtiWYlQJvZEV42SmcsM1wG_ddvbHIt5LQs0-THEMlSdcpiFyAizx-iYXhyphenhyphen74nH_c-Jvf_TyL1a0v5rA4z-ZY44VLfUXWCTjfAJEGOUtcUXWNI23zI5CFDUMsOACgs4/s1354/Insert+Command+Button+Control.png" style="margin-left: auto; margin-right: auto;"><img alt="Insert Command Button Control Image" border="0" data-original-height="628" data-original-width="1354" height="297" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6L_vGHXgeDbqUbYtiWYlQJvZEV42SmcsM1wG_ddvbHIt5LQs0-THEMlSdcpiFyAizx-iYXhyphenhyphen74nH_c-Jvf_TyL1a0v5rA4z-ZY44VLfUXWCTjfAJEGOUtcUXWNI23zI5CFDUMsOACgs4/w640-h297/Insert+Command+Button+Control.png" title="Insert Command Button Control" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Insert Command Button Control</b><br />
</td>
</tr>
</tbody>
</table>
<br />
</li>
<li>Drag a command button on your worksheet.</li>
</ol>
</div>
<!--Command Button END-->
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<!--Assign a Macro Start-->
<div>
<h3 style="text-align: left;"><a id="assign-macro" name="assign-macro"></a>Assign a Macro:</h3>
In this tutorial we are going to explain how you can <b>Assign a Macro</b> to
the Command Button in the Microsoft Excel.<br /><br />To assign a macro (one
or more code lines) to the command button, execute the following steps:<br />
<ol style="text-align: left;">
<li>
Right click <b>CommandButton1 </b>(make sure Design Mode is selected).
</li>
<li>
Click <b>View Code</b>.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUEFgL0QGUR_IRbgs8M4NsNXyL5-WB2v-zL7UB7bIVoxTAjZ6sH8fgVc_IyGI58lvUZhywbkvHQMjcr1qv5phZ5Shk5df_aXaI4GEjBaoRGTiO__AiZm9q-F2aCV-29hK8W1NLqGeTQ90/s970/View+Code.png" style="margin-left: auto; margin-right: auto;"><img alt="View Code Image" border="0" data-original-height="790" data-original-width="970" height="521" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUEFgL0QGUR_IRbgs8M4NsNXyL5-WB2v-zL7UB7bIVoxTAjZ6sH8fgVc_IyGI58lvUZhywbkvHQMjcr1qv5phZ5Shk5df_aXaI4GEjBaoRGTiO__AiZm9q-F2aCV-29hK8W1NLqGeTQ90/w640-h521/View+Code.png" title="View Code" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>View Code</b>
</td>
</tr>
</tbody>
</table>
The Visual Basic Editor appears.<br /><br />
</li>
<li>
Place your cursor between <b>Private Sub CommandButton1_Click()</b> and <b>End Sub</b>.
</li>
<li> Add the code line shown below:
<pre style="background: rgb(240, 240, 240) none repeat scroll 0% 0%; border: 2px dashed rgb(204, 204, 204); color: black; font-family: "arial"; font-size: 14px; height: auto; line-height: 20px; overflow: auto; padding: 6px; text-align: left; width: 99%;"> <code style="color: black; overflow-wrap: normal;">Range("A1").Value = "Hello"</code>
</pre>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinwJPxDP9-IcFC7YtAf90BpadsPvk6pZnSfja3lwgv9UBQQ1618Hl8ZIxETcZa_VhLWIfAUKr8gLw1SEJADIAU54o-b6E0yCVtHMLlxxc4-xwi3ljWZGUVGnKAu4X2groPjqvB5S232YM/s1239/Add+Code+Lines.png" style="margin-left: auto; margin-right: auto;"><img alt="Add Code Line Image" border="0" data-original-height="590" data-original-width="1239" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinwJPxDP9-IcFC7YtAf90BpadsPvk6pZnSfja3lwgv9UBQQ1618Hl8ZIxETcZa_VhLWIfAUKr8gLw1SEJADIAU54o-b6E0yCVtHMLlxxc4-xwi3ljWZGUVGnKAu4X2groPjqvB5S232YM/w640-h305/Add+Code+Lines.png" title="Add Code Line" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Add Code Line</b><br />
</td>
</tr>
</tbody>
</table>
<b>Note: </b>The window on the left with the name <b>Sheet1 (Sheet1)</b>
and <b>ThisWorkbook </b>is called the <b>Project Explorer</b>. If the Project Explorer
is not visible, click on <b>View</b> menu and then click on <b>Project Explorer</b>. If the Code window for
Sheet1 is not visible, click Sheet1 (Sheet1). You can ignore the
<a href="https://bit.ly/3eHJC2a" target="_blank">Option Explicit</a>
statement for now.<br /><br />
</li>
<li><b>Close </b>the <b>Visual Basic Editor</b>.</li>
<li>
<b>Click </b>the <b>command button</b> on the sheet (<b>make sure Design Mode is
deselected</b>).
</li>
</ol>
<h4 style="text-align: left;">Result:</h4>
</div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN540FHIl9Hz64ksX-0pE5n1qhtj64ed14n4tKmtnLxertIzQDKSbbL2uRbebYzTWpsQ2Qqicu0xtA-m5leH7zSIYuys-f9iFU_WCU530to8jxD2qL9TJGAUjjMG2EgA3Hyh2F2qH91jA/s1485/Macro+Result.png" style="margin-left: auto; margin-right: auto;"><img alt="Macro Result Image" border="0" data-original-height="284" data-original-width="1485" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN540FHIl9Hz64ksX-0pE5n1qhtj64ed14n4tKmtnLxertIzQDKSbbL2uRbebYzTWpsQ2Qqicu0xtA-m5leH7zSIYuys-f9iFU_WCU530to8jxD2qL9TJGAUjjMG2EgA3Hyh2F2qH91jA/w640-h122/Macro+Result.png" title="Macro Result" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Macro Result</b><br />
</td>
</tr>
</tbody>
</table>
Congratulations. You've just created a macro in Excel!<br /><br />
<!--Assign a Macro END-->
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<!--Visual Basic Editor Start-->
<div>
<h3 style="text-align: left;">
<a id="visual-basic-editor" name="visual-basic-editor"></a>Visual Basic
Editor
</h3>
In this tutorial we are going to explain how you can open the <b>Visual Basic
Editor</b> in the Microsoft Excel.</div><div></div><div><br />To open the <b>Visual Basic Editor</b>, Go to the <a href="#developer-tab">Developer tab</a> and then click on <b>Visual Basic</b>.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvrBgSGnMZPhJM1cisQ9Vq0Zu9U2Ud6yvK_1nhSEx_KTzQ23VDsqaDr4g2KvXsQ0O7LlLGq-Rj8Rpzut9aO9e2zoUo15h7mw0MhxSYOs_xOELVCamq1rURLr7stlkUOCN0FwvTufkQPw4/s1528/Open+Visual+Basic+Editor.png" style="margin-left: auto; margin-right: auto;"><img alt="Open Visual Basic Editor Image" border="0" data-original-height="733" data-original-width="1528" height="307" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvrBgSGnMZPhJM1cisQ9Vq0Zu9U2Ud6yvK_1nhSEx_KTzQ23VDsqaDr4g2KvXsQ0O7LlLGq-Rj8Rpzut9aO9e2zoUo15h7mw0MhxSYOs_xOELVCamq1rURLr7stlkUOCN0FwvTufkQPw4/w640-h307/Open+Visual+Basic+Editor.png" title="Open Visual Basic Editor" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Open Visual Basic Editor</b><br />
</td>
</tr>
</tbody>
</table>
The Visual Basic Editor appears.<br /><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto;">
<tbody>
<tr>
<td style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibIgMD_DQUN2OMQLeSdV1CxoJ9clzjIir6tTbVdyII53mvKxUqLQdgVv3EfEc_KlexB-PgMZ7wzv4QlNJRoHFf-WaxuhG9cnOjyiJuHPbfANcBmwL89as3k2uFgkLOM-HDlFZK5xttlaY/s1452/Visual+Basic+Editor.png" style="margin-left: auto; margin-right: auto;"><img alt="Visual Basic Editor Image" border="0" data-original-height="666" data-original-width="1452" height="294" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibIgMD_DQUN2OMQLeSdV1CxoJ9clzjIir6tTbVdyII53mvKxUqLQdgVv3EfEc_KlexB-PgMZ7wzv4QlNJRoHFf-WaxuhG9cnOjyiJuHPbfANcBmwL89as3k2uFgkLOM-HDlFZK5xttlaY/w640-h294/Visual+Basic+Editor.png" title="Visual Basic Editor" width="640" /></a>
</td>
</tr>
<tr>
<td class="tr-caption" style="text-align: center;">
<b>Visual Basic Editor</b><br />
</td>
</tr>
</tbody>
</table>
</div>
<!--Visual Basic Editor END-->
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-64090838565910281122020-08-14T15:08:00.000+05:302020-08-14T15:08:10.952+05:30Email a Single Excel Worksheet from a Workbook <p>
Sometimes, you may need to send a part of the worksheet or a single excel worksheet from the workbook to your colleague or boss. If you want to e-mail a single worksheet from a workbook. Then, instead of
saving a copy of that workbook and deleting the unwanted content. Here is a
quicker way to do it:<br /><br /><b>Note</b>: This will only work when
<b>Outlook is set up</b> on your computer. <br />
</p>
<ol style="text-align: left;">
<li>
<b>Select </b>the worksheet/tab you want to e-mail or If you want to send
more than one worksheet, then hold down the <b>Ctrl </b>key & click on
the each worksheet which you want to send in e-mail. Then,
</li>
<li>
<b>Right-click</b> on the selected worksheet/tab and Click on the
<b>Move or Copy</b> option (as shown in below screenshot). Then,<br /><br />
<div style="text-align: center;"><img alt="Move Or Copy Option Image" border="0" data-original-height="461" data-original-width="338" height="295" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH5sPWdViZjek_i71w_kEsSJwvILUaEt6CPuG5v3X_diWLHdQNYGt7EefIsFFdVTKVbAa8QcyCg8RKKYrm-t8N6eG_Pqt8j6bLQ67pTxVSF6OMhokW48rOknqrlnyT9zP6jDYvMCOUxdM/w216-h295/Move+or+Copy+Option.png" title="Move Or Copy Option" width="216" /></div><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH5sPWdViZjek_i71w_kEsSJwvILUaEt6CPuG5v3X_diWLHdQNYGt7EefIsFFdVTKVbAa8QcyCg8RKKYrm-t8N6eG_Pqt8j6bLQ67pTxVSF6OMhokW48rOknqrlnyT9zP6jDYvMCOUxdM/s461/Move+or+Copy+Option.png" style="margin-left: 1em; margin-right: 1em;"> </a>
</div>
<div class="separator" style="clear: both; text-align: center;"> </div>
</li>
<li>
In the <b>To book:</b> field select<b> (new book)</b> and
<b>check mark</b> the <b>Create a copy</b> option and Click on
<b>OK </b>button (as shown in below screenshot)<br /><br />
<div class="separator" style="clear: both; text-align: center;"></div>
<div class="separator" style="clear: both; text-align: center;"></div>
<div class="separator" style="clear: both; text-align: center;"></div>
<div class="separator" style="clear: both; text-align: center;"></div>
<div class="separator" style="clear: both; text-align: center;"></div>
<div class="separator" style="clear: both; text-align: center;"></div>
<div class="separator" style="clear: both; text-align: center;"></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrLle0i0gr426xD_u_jzdJsCw1mj08gIbDDsOkaixMEWlCu9EcnVT9VdFofhFjC1PURQ1INxN_VtRlb-IAc9RktEXQTUhK2vTDR40HPITsc40f5gOOv1w0hf1x4d7-yRI9ebuI4wmkRVE/s479/Move+or+Copy+Option+Dialog+Box.png" style="margin-left: 1em; margin-right: 1em;"><img alt="Move Or Copy Option Dialog Box Image" border="0" data-original-height="452" data-original-width="479" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrLle0i0gr426xD_u_jzdJsCw1mj08gIbDDsOkaixMEWlCu9EcnVT9VdFofhFjC1PURQ1INxN_VtRlb-IAc9RktEXQTUhK2vTDR40HPITsc40f5gOOv1w0hf1x4d7-yRI9ebuI4wmkRVE/w306-h290/Move+or+Copy+Option+Dialog+Box.png" title="Move Or Copy Option Dialog Box" width="306" /></a>
</div>
</li><br />
<li>
The worksheet/s will now be opened in a separate workbook with a default
name, i.e. <b>Book1</b>.
</li>
<li>
In this workbook, Go to <b>File </b>> <b>Share </b>> <b>Email </b>>
click on <b>Send as Attachment</b> option (as shown in below screenshot).</li><li>Six<br /><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqv0udr2JHKDOJCDcc002u9zd8peu3sk7fFGsPnA7Nbkl1Lu2_0i4u85qOsXK36-0MszTNKfR4Pqu0l0zSkJYt22N8LeQf-JzdHx2PReRAgz_eBFs_9cXxWbKwFmu_7MqXdgTMvrx9ZhY/s981/Share+-+Send+As+Attachment.png" style="margin-left: 1em; margin-right: 1em;"><img alt="Share - Email As Attachment Image" border="0" data-original-height="579" data-original-width="981" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqv0udr2JHKDOJCDcc002u9zd8peu3sk7fFGsPnA7Nbkl1Lu2_0i4u85qOsXK36-0MszTNKfR4Pqu0l0zSkJYt22N8LeQf-JzdHx2PReRAgz_eBFs_9cXxWbKwFmu_7MqXdgTMvrx9ZhY/w410-h242/Share+-+Send+As+Attachment.png" title="Share - Email As Attachment" width="410" /></a>
</div>
</li>
</ol>
Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-2073849892366819072020-08-13T20:10:00.000+05:302020-08-13T20:11:07.438+05:30All Excel Keyboard Shortcuts at One Place<h2 style="text-align: left;"></h2>
<p>
<span style="font-size: 18px;">
We have gathered all the <b>Keyboard Shortcuts</b> of
<b>Microsoft Excel</b> at one place. To easy access of yours, we have
categorized all the shortcuts. Now, you can find the required category and
can easily access the list of shortcuts by clicking on the links listed
below and increase your productivity. <br /></span>
</p>
<p>
<span style="font-size: 18px;"><b>Note: </b>Here, You can find the shortcut keys for <b>Mac </b>&
<b>Windows </b>both the platforms.<br /></span>
</p>
<p>
<span style="font-size: 18px;"><a href="https://bit.ly/31N7Kvo" target="_blank">Excel <b>Ribbon Tab</b> Shortcuts for Windows
</a>
<br />
<br />
<a href="https://bit.ly/30Dk167" target="_blank">Shortcuts to <b>Make Selections</b> in Excel
<br />
</a>
<br />
<a href="https://bit.ly/2XGvO1L" target="_blank">
<b>Formatting Cell</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/3gGsjjg" target="_blank">
<b>Inside the Ribbon</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/2DpQ6pn" target="_blank">
<b>Frequently Used Keyboard Shortcuts</b> For Mac & Windows in Excel
<br />
</a>
<br />
<a href="https://bit.ly/30DYYjN" target="_blank">Excel <b>Cell Navigation</b> Shortcuts For Mac & Windows</a><br /><br />
<a href="https://bit.ly/33V3D2P" target="_blank"><b>Formula</b> Shortcuts For Mac & Windows</a>
<br /><br />
<a href="https://bit.ly/3alqSnX" target="_blank"><b>Increase Productivity</b> using these Top Excel Keyboard Shortcuts</a><br /><br />
</span>
</p>
<br />
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com2tag:blogger.com,1999:blog-5616982869570753721.post-86712110716360388992020-08-11T09:00:00.006+05:302021-02-08T19:17:51.366+05:30Excel Ribbon Tab Shortcuts for Windows<style>
th {
background-color: #0009;
color: white;
text-align: left;
}
td {
font-size:1em;
}
</style>
<br />
<table border="1" cellpadding="9">
<tbody>
<tr>
<th><b>To do this action</b></th>
<th><b>Press in Windows</b></th>
</tr>
<tr>
<td>Go To <b>Search </b>Field</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>Q</swt-black-kbk></td>
</tr>
<tr>
<td>Open <b>Data </b>Tab</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>A</swt-black-kbk></td>
</tr>
<tr>
<td>Open <b>File </b>Page</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>F</swt-black-kbk></td>
</tr>
<tr>
<td>Open <b>Formula </b>Tab</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>M</swt-black-kbk></td>
</tr>
<tr>
<td>Open <b>Home </b>Tab</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>H</swt-black-kbk></td>
</tr>
<tr>
<td>Open <b>Insert </b>Tab</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>N</swt-black-kbk></td>
</tr>
<tr>
<td>Open <b>Page Layout</b> Tab</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>P</swt-black-kbk></td>
</tr>
<tr>
<td>Open <b>Review </b>Tab</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>R</swt-black-kbk></td>
</tr>
<tr>
<td>Open <b>View </b>Tab</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>W</swt-black-kbk></td>
</tr>
</tbody>
</table>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<h2 style="text-align: left;">
For More Shortcuts (Click on the links below): <br />
</h2>
<p>
<span style="font-size: 18px;">
<a href="https://bit.ly/30Dk167" target="_blank">Shortcuts to <b>Make Selections</b> in Excel
<br />
</a>
<br />
<a href="https://bit.ly/2XGvO1L" target="_blank">
<b>Formatting Cell</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/3gGsjjg" target="_blank">
<b>Inside the Ribbon</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/2DpQ6pn" target="_blank">
<b>Frequently Used Keyboard Shortcuts</b> For Mac & Windows in Excel
<br />
</a>
<br />
<a href="https://bit.ly/30DYYjN" target="_blank">Excel <b>Cell Navigation</b> Shortcuts For Mac & Windows</a><br /><br />
<a href="https://bit.ly/33V3D2P" target="_blank"><b>Formula</b> Shortcuts For Mac & Windows</a>
</span>
</p>
<br />
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-91770912071056434172020-08-10T09:00:00.016+05:302021-02-08T19:12:17.012+05:30Formula Shortcuts in Excel<style>
th {
background-color: #0009;
color: white;
text-align: left;
}
td {
font-size:0.9em;
}
</style>
<br />
<table border="1" cellpadding="9">
<tbody>
<tr>
<th><b>To do this action</b></th>
<th><b>Press in Windows</b></th>
<th><b>Press in Mac</b></th>
</tr>
<tr>
<td><b>Autosum </b>Selection Of Cells</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>=</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>T</swt-white-kbk></td>
</tr>
<tr>
<td>Calculate Active Worksheet</td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>F9</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>F9</swt-white-kbk></td>
</tr>
<tr>
<td>Calculate All Worksheets</td>
<td><swt-black-kbk>F9</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>F9</swt-white-kbk></td>
</tr>
<tr>
<td><b>Cancel Entry </b>In Formula Bar</td>
<td><swt-black-kbk>Esc</swt-black-kbk></td>
<td><swt-white-kbk>Esc</swt-white-kbk></td>
</tr>
<tr>
<td><b>Complete Entry</b> In Formula Bar</td>
<td><swt-black-kbk>Enter</swt-black-kbk></td>
<td><swt-white-kbk>Return</swt-white-kbk></td>
</tr>
<tr>
<td>Copy The Value From The Cell Above</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>"</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>"</swt-white-kbk></td>
</tr>
<tr>
<td><b>Create Chart</b> In A New Sheet</td>
<td><swt-black-kbk>F11</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>F11</swt-white-kbk></td>
</tr>
<tr>
<td>Create Embedded Chart</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>F1</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⌥ </swt-white-kbk>+<swt-white-kbk>F1</swt-white-kbk></td>
</tr>
<tr>
<td><b>Define Name</b> For References</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>F3</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>F3</swt-white-kbk></td>
</tr>
<tr>
<td>Display <b>Function Arguments</b> Dialog</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>A</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>A</swt-white-kbk></td>
</tr>
<tr>
<td>Display <b>Message For Error Checking </b>Button</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>F10</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Edit Active Cell</td>
<td><swt-black-kbk>F2</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>U</swt-white-kbk></td>
</tr>
<tr>
<td>Expand Or Collapse <b>Formula Bar</b></td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>U</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>U</swt-white-kbk></td>
</tr>
<tr>
<td>Force Calculate All Worksheets</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>F9</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Input <b>Array Formula</b></td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>Enter</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>Return</swt-white-kbk></td>
</tr>
<tr>
<td><b>Insert </b>a <b>Function </b>(Opens a <b>Dialog Box</b>)<br /></td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>F3</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>F3</swt-white-kbk></td>
</tr>
<tr>
<td>Insert Function Arguments</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>A</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>A</swt-white-kbk></td>
</tr>
<tr>
<td>Invoke <b>Flash Fill</b></td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>E</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Move To End Of Text When In The Formula Bar</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>End</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>→ </swt-white-kbk></td>
</tr>
<tr>
<td>Move To Next Record Of Data Form</td>
<td><swt-black-kbk>Enter</swt-black-kbk></td>
<td><swt-white-kbk>Return</swt-white-kbk></td>
</tr>
<tr>
<td>Open <b>Macro </b>Dialog</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>F8</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⌥ </swt-white-kbk>+<swt-white-kbk>F8</swt-white-kbk></td>
</tr>
<tr>
<td>Open <b>Visual Basic</b> For Applications (VBA) <b>Editor</b></td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>F11</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⌥ </swt-white-kbk>+<swt-white-kbk>F11</swt-white-kbk></td>
</tr>
<tr>
<td>Paste a Name</td>
<td><swt-black-kbk>F3</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Select Text In Formula Bar To End</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>End</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>→ </swt-white-kbk></td>
</tr>
<tr>
<td><b>Toggle </b>Absolute or Relative <b>References</b></td>
<td><swt-black-kbk>F4</swt-black-kbk></td>
<td><br /></td>
</tr>
</tbody>
</table>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
<h2 style="text-align: left;">
For More Shortcuts (Click on the links below): <br />
</h2>
<p>
<span style="font-size: 18px;">
<a href="https://bit.ly/31N7Kvo" target="_blank">Excel <b>Ribbon Tab</b> Shortcuts for Windows
</a>
<br />
<br />
<a href="https://bit.ly/30Dk167" target="_blank">Shortcuts to <b>Make Selections</b> in Excel
<br />
</a>
<br />
<a href="https://bit.ly/2XGvO1L" target="_blank">
<b>Formatting Cell</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/3gGsjjg" target="_blank">
<b>Inside the Ribbon</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/2DpQ6pn" target="_blank">
<b>Frequently Used Keyboard Shortcuts</b> For Mac & Windows in Excel
<br />
</a>
<br />
<a href="https://bit.ly/30DYYjN" target="_blank">Excel <b>Cell Navigation</b> Shortcuts For Mac & Windows</a>
</span>
</p>
<br />
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-29163155039626822992020-08-09T09:00:00.005+05:302021-02-08T19:18:36.567+05:30Shortcuts to Make Selections in Excel<style>
th {
background-color: #0009;
color: white;
text-align: left;
}
td {
font-size:0.9em;
}
</style>
<br />
<table border="1" cellpadding="9">
<tbody>
<tr>
<th><b>To do this action</b></th>
<th><b>Press in Windows</b></th>
<th><b>Press in Mac</b></th>
</tr>
<tr>
<td>Complete Cell Entry and Select Above Cell</td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>Enter</swt-black-kbk></td>
<td><swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>Return</swt-white-kbk></td>
</tr>
<tr>
<td>Extend Cell Selection Downward</td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>↓ </swt-black-kbk></td>
<td><swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>↓ </swt-white-kbk></td>
</tr>
<tr>
<td>Extend Cell Selection to the Left</td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>← </swt-black-kbk></td>
<td><swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>← </swt-white-kbk></td>
</tr>
<tr>
<td>Extend Cell Selection to the Right</td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>→ </swt-black-kbk></td>
<td><swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>→ </swt-white-kbk></td>
</tr>
<tr>
<td>Extend Cell Selection to the Top</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>Home</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>← </swt-white-kbk></td>
</tr>
<tr>
<td>Extend Cell Selection Upwards</td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>↑ </swt-black-kbk></td>
<td><swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>↑ </swt-white-kbk></td>
</tr>
<tr>
<td>Extend Selection to Last Bottom Cell</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>↓ </swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>↓ </swt-white-kbk></td>
</tr>
<tr>
<td>Extend Selection to Last Left Cell</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>← </swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>← </swt-white-kbk></td>
</tr>
<tr>
<td>Extend Selection to Last Right Cell</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>→ </swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>→ </swt-white-kbk></td>
</tr>
<tr>
<td>Extend Selection to Last Top Cell</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>↑ </swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>↑ </swt-white-kbk></td>
</tr>
<tr>
<td>Fill Selected Cell Range with the Current Entry</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Enter</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>Return</swt-white-kbk></td>
</tr>
<tr>
<td>Redo Last Action</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Y</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>Y</swt-white-kbk></td>
</tr>
<tr>
<td>Undo Typing</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Z</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>Z</swt-white-kbk></td>
</tr>
<tr>
<td>Select All Objects when an Object is Selected</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>Space</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Select Current and Next Worksheet</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>Pg Dn</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Select Current and Previous Worksheet</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>Pg Up</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Select Current Array</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>/</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>/</swt-white-kbk></td>
</tr>
<tr>
<td>Select Current Region around the Cell</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>*</swt-black-kbk></td>
<td><swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>Space</swt-white-kbk></td>
</tr>
<tr>
<td>Select Differences in Columns</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>|</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>|</swt-white-kbk></td>
</tr>
<tr>
<td>Select Differences in Rows</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>\</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>\</swt-white-kbk></td>
</tr>
<tr>
<td>Select Entire Column</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Space</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>Space</swt-white-kbk></td>
</tr>
<tr>
<td>Select Entire Row</td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>Space</swt-black-kbk></td>
<td><swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>Space</swt-white-kbk></td>
</tr>
<tr>
<td>Select Entire Worksheet</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>A</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>A</swt-white-kbk></td>
</tr>
<tr>
<td>Select First Command on Menu</td>
<td><swt-black-kbk>Home</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>← </swt-white-kbk></td>
</tr>
<tr>
<td>Select Only Visible Cells</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>;</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>Z</swt-white-kbk></td>
</tr>
<tr>
<td>Start a New Line in a Cell</td>
<td><swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>Enter</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⌥ </swt-white-kbk>+<swt-white-kbk>Return</swt-white-kbk></td>
</tr>
<tr>
<td>Toggle Add to Selection Mode</td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>F8</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>F8</swt-white-kbk></td>
</tr>
<tr>
<td>Toggle Extend Mode</td>
<td><swt-black-kbk>F8</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>F8</swt-white-kbk></td>
</tr>
</tbody>
</table>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
<h2 style="text-align: left;">
For More Shortcuts (Click on the links below): <br />
</h2>
<p>
<span style="font-size: 18px;">
<a href="https://bit.ly/31N7Kvo" target="_blank">Excel <b>Ribbon Tab</b> Shortcuts for Windows
</a>
<a href="https://bit.ly/30Dk167" target="_blank"><br />
</a>
<br />
<a href="https://bit.ly/2XGvO1L" target="_blank">
<b>Formatting Cell</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/3gGsjjg" target="_blank">
<b>Inside the Ribbon</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/2DpQ6pn" target="_blank">
<b>Frequently Used Keyboard Shortcuts</b> For Mac & Windows in Excel
<br />
</a>
<br />
<a href="https://bit.ly/30DYYjN" target="_blank">Excel <b>Cell Navigation</b> Shortcuts For Mac & Windows</a><br /><br />
<a href="https://bit.ly/33V3D2P" target="_blank"><b>Formula</b> Shortcuts For Mac & Windows</a>
</span>
</p>
<br />
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-62387917894236124612020-08-08T11:26:00.006+05:302021-02-08T19:18:55.460+05:30Formatting Cell Shortcuts in Excel<style>
th {
background-color: #0009;
color: white;
text-align: left;
}
td {
font-size:1em;
}
</style>
<br />
<table border="1" cellpadding="9">
<tbody>
<tr>
<th><b>To do this action</b></th>
<th><b>Press in Windows</b></th>
<th><b>Press in Mac</b></th>
</tr>
<tr>
<td>Apply <b>Date </b>Format</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>#</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>#</swt-white-kbk></td>
</tr>
<tr>
<td>Apply <b>General </b>Format</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>~</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>~</swt-white-kbk></td>
</tr>
<tr>
<td>Apply <b>Number </b>Format</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>!</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>!</swt-white-kbk></td>
</tr>
<tr>
<td>Apply <b>Percentage </b>Format</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>%</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>%</swt-white-kbk></td>
</tr>
<tr>
<td>Apply <b>Scientific </b>Format</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>^</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>^</swt-white-kbk></td>
</tr>
<tr>
<td>Apply <b>Time </b>Format</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>@</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>@</swt-white-kbk></td>
</tr>
<tr>
<td>Apply or Remove <b>Bold </b>Formatting</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>B</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>B</swt-white-kbk></td>
</tr>
<tr>
<td>Apply or Remove <b>Italic </b>Formatting</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>I</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>I</swt-white-kbk></td>
</tr>
<tr>
<td>Apply or Remove <b>Strikethrough </b>Formatting</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>5</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>X</swt-white-kbk></td>
</tr>
<tr>
<td>Apply or Remove <b>Underline</b></td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>U</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>U</swt-white-kbk></td>
</tr>
<tr>
<td>Check <b>Spelling</b></td>
<td><swt-black-kbk>F7</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>F7</swt-white-kbk></td>
</tr>
<tr>
<td><b>Copy Formula</b> from above Cell</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>'</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>'</swt-white-kbk></td>
</tr>
<tr>
<td>Display the <b>Quick Analysis </b>Options</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Q</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Edit <b>Active Cell</b></td>
<td><swt-black-kbk>F2</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>U</swt-white-kbk></td>
</tr>
<tr>
<td>Enter <b>Current Date</b></td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>;</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>;</swt-white-kbk></td>
</tr>
<tr>
<td>Enter <b>Current Time</b></td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>;</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>;</swt-white-kbk></td>
</tr>
<tr>
<td><b>Fill Down</b> from Cell Above</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>D</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>D</swt-white-kbk></td>
</tr>
<tr>
<td><b>Fill Right</b> from Cell Left</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>R</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>R</swt-white-kbk></td>
</tr>
<tr>
<td><b>Format Fonts</b> in Format Cells Dialog</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>F</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>F</swt-white-kbk></td>
</tr>
<tr>
<td>Insert a Note</td>
<td><swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>F2</swt-black-kbk></td>
<td><swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>F2</swt-white-kbk></td>
</tr>
<tr>
<td>Insert Table</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>T</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>T</swt-white-kbk></td>
</tr>
<tr>
<td>Insert <b>Threaded </b>Comment</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>F2</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Open <b>Delete Dialog</b> to Delete Cells</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>-</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>-</swt-white-kbk></td>
</tr>
<tr>
<td>Open <b>Format Cells</b> Dialog</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>1</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>1</swt-white-kbk></td>
</tr>
<tr>
<td>Open <b>Insert Dialog</b> to Insert Cells</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>+</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>+</swt-white-kbk></td>
</tr>
<tr>
<td>Open <b>Paste Special</b> Dialog</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>V</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>V</swt-white-kbk></td>
</tr>
<tr>
<td>Open the <b>Insert Hyperlink </b>Dialog</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>K</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>K</swt-white-kbk></td>
</tr>
<tr>
<td><b>Apply Outline Borders </b>to Cells</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>&</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>⌥ </swt-white-kbk>+<swt-white-kbk>0</swt-white-kbk></td>
</tr>
<tr>
<td><b>Remove Outline Border </b>to Selected Cell(s)</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>_</swt-black-kbk></td>
<td><swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>⌥ </swt-white-kbk>+<swt-white-kbk>_</swt-white-kbk></td>
</tr>
<tr>
<td><b>Show </b>or <b>Hide Objects</b></td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>6</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>6</swt-white-kbk></td>
</tr>
<tr>
<td><b>Show </b>or <b>Hide Outline</b> Symbols</td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>8</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>8</swt-white-kbk></td>
</tr>
<tr>
<td><b>Toggle Formulas</b> <i>On </i>and <i>Off</i></td>
<td><swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>`</swt-black-kbk></td>
<td><swt-white-kbk>⌃ </swt-white-kbk>+<swt-white-kbk>`</swt-white-kbk></td>
</tr>
</tbody>
</table>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
<h2 style="text-align: left;">
For More Shortcuts (Click on the links below): <br />
</h2>
<p>
<span style="font-size: 18px;">
<a href="https://bit.ly/31N7Kvo" target="_blank">Excel <b>Ribbon Tab</b> Shortcuts for Windows
</a>
<br />
<br />
<a href="https://bit.ly/30Dk167" target="_blank">Shortcuts to <b>Make Selections</b> in Excel
</a><a href="https://bit.ly/2XGvO1L" target="_blank"><br />
</a>
<br />
<a href="https://bit.ly/3gGsjjg" target="_blank">
<b>Inside the Ribbon</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/2DpQ6pn" target="_blank">
<b>Frequently Used Keyboard Shortcuts</b> For Mac & Windows in Excel
<br />
</a>
<br />
<a href="https://bit.ly/30DYYjN" target="_blank">Excel <b>Cell Navigation</b> Shortcuts For Mac & Windows</a><br /><br />
<a href="https://bit.ly/33V3D2P" target="_blank"><b>Formula</b> Shortcuts For Mac & Windows</a>
</span>
</p>
<br />
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0tag:blogger.com,1999:blog-5616982869570753721.post-40396113268472807242020-08-07T11:09:00.016+05:302021-02-08T19:19:14.012+05:30Inside the Ribbon Shortcuts in Excel<style>
th {
background-color: #0009;
color: white;
}
td {
font-size:1em;
}
</style>
<br />
<table border="1" cellpadding="9">
<tbody>
<tr>
<th style="text-align: left;"><b>To do this action</b></th>
<th style="text-align: left;"><b>Press in Windows</b></th>
<th style="text-align: left;"><b>Press in Mac</b></th>
</tr>
<tr>
<td>Activate Selected Buttons</td>
<td><swt-black-kbk>Space</swt-black-kbk></td>
<td><swt-white-kbk>Space</swt-white-kbk></td>
</tr>
<tr>
<td>Expand / Collapse the Ribbon</td>
<td>
<swt-black-kbk>Ctrl</swt-black-kbk>+<swt-black-kbk>F1</swt-black-kbk>
</td>
<td>
<swt-white-kbk>⌘ </swt-white-kbk>+<swt-white-kbk>⌥ </swt-white-kbk>+<swt-white-kbk>R</swt-white-kbk>
</td>
</tr>
<tr>
<td>Move to Left Command</td>
<td>
<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>Tab</swt-black-kbk>
</td>
<td>
<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>Tab</swt-white-kbk>
</td>
</tr>
<tr>
<td>Move to Right Command</td>
<td><swt-black-kbk>Tab</swt-black-kbk></td>
<td><swt-white-kbk>Tab</swt-white-kbk></td>
</tr>
<tr>
<td>Move to Sub-menu, when a Main-menu is Open</td>
<td><swt-black-kbk>← </swt-black-kbk></td>
<td><swt-white-kbk>← </swt-white-kbk></td>
</tr>
<tr>
<td>Move to the Next Command in Open Menu</td>
<td><swt-black-kbk>↓ </swt-black-kbk></td>
<td><swt-white-kbk>↓ </swt-white-kbk></td>
</tr>
<tr>
<td>Open a Context Menu</td>
<td>
<swt-black-kbk>Shift</swt-black-kbk>+<swt-black-kbk>F10</swt-black-kbk>
</td>
<td>
<swt-white-kbk>Fn</swt-white-kbk>+<swt-white-kbk>⇧ </swt-white-kbk>+<swt-white-kbk>F10</swt-white-kbk>
</td>
</tr>
<tr>
<td>Open the List for Selected Command</td>
<td><swt-black-kbk>↓ </swt-black-kbk></td>
<td><swt-white-kbk>↓ </swt-white-kbk></td>
</tr>
<tr>
<td>Open the Menu for Selected Button</td>
<td>
<swt-black-kbk>Alt</swt-black-kbk>+<swt-black-kbk>↓ </swt-black-kbk>
</td>
<td>
<swt-white-kbk>⌥ </swt-white-kbk>+<swt-white-kbk>↓ </swt-white-kbk>
</td>
</tr>
<tr>
<td>Select Active Tab and Activate Access Keys</td>
<td><swt-black-kbk>Alt</swt-black-kbk></td>
<td><br /></td>
</tr>
<tr>
<td>Select Active Tab and Activate Access Keys</td>
<td><swt-black-kbk>F10</swt-black-kbk></td>
<td><br /></td>
</tr>
</tbody>
</table>
<br />
<script async="" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle" data-ad-client="ca-pub-8542016316920624" data-ad-format="fluid" data-ad-layout="in-article" data-ad-slot="6403984725" style="display: block; text-align: center;"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
<h2 style="text-align: left;">
For More Shortcuts (Click on the links below): <br />
</h2>
<p>
<span style="font-size: 18px;">
<a href="https://bit.ly/31N7Kvo" target="_blank">Excel <b>Ribbon Tab</b> Shortcuts for Windows
</a>
<br />
<br />
<a href="https://bit.ly/30Dk167" target="_blank">Shortcuts to <b>Make Selections</b> in Excel
<br />
</a>
<br />
<a href="https://bit.ly/2XGvO1L" target="_blank">
<b>Formatting Cell</b> Shortcuts in Excel
<br />
</a>
<br />
<a href="https://bit.ly/3gGsjjg" target="_blank">
</a><a href="https://bit.ly/2DpQ6pn" target="_blank"><b>Frequently Used Keyboard Shortcuts</b> For Mac & Windows in Excel
<br />
</a>
<br />
<a href="https://bit.ly/30DYYjN" target="_blank">Excel <b>Cell Navigation</b> Shortcuts For Mac & Windows</a><br /><br />
<a href="https://bit.ly/33V3D2P" target="_blank"><b>Formula</b> Shortcuts For Mac & Windows</a>
</span>
</p>
<br />
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-8542016316920624"
data-ad-slot="6403984725"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
Excel Mirrorhttp://www.blogger.com/profile/01239390418382688645noreply@blogger.com0