Friday, 28 March 2025

How to Free Up & Clear MacBook RAM Cache to Boost Performance

RAM plays most important role for your MacBook performance. Over time, your Ma
c stores temporary data in RAM to help apps run faster. But when too many apps are open, or background processes take up too much memory, things can slow down. That’s where clearing your Mac’s RAM cache comes in handy! Doing this can free up memory, speed things up, and keep your system running smoothly. In this guide, we’ll walk you through simple yet effective ways to free up and clear your MacBook’s RAM cache so you can get back to a faster, more efficient Mac.  (Watch video tutorial for better understand)


Here are some Ways to Free Up & Clear MacBook RAM Cache

1. Restart Your MacBook

This is the simplest trick in the book! Restarting your Mac clears the RAM cache and gives your system a fresh start. 

2. Use Activity Monitor to Find Memory Hogs

Open Activity Monitor (Press Command + Space, type Activity Monitor, and hit Enter). Click the Memory tab to see active processes. Find apps using excessive memory. Click the X button to quit them.

3. Free Up RAM Using Terminal

Open Terminal (Press Command + Space, type Terminal, and hit Enter). Type this command and press Enter:

sudo purge

Enter your admin password when prompted and wait a few seconds while your Mac clears unused memory.

4. Free up Caches 

Click on “Go” – “Go to Folder” now copy paste this prompt “~/Library/Caches” and hit “Enter” select all cached file and folder then delete it. 

5. Reduce Startup Apps

Open System Settings > Users & Groups. Click Login Items. Remove unneeded apps by selecting them and clicking the “-” button.


Tuesday, 25 March 2025

How to Create Shortcut Key to Insert Signature in MS Excel

Adding a signature in MS Excel can save you a lot of time, especially if you frequently sign documents or approve spreadsheets. While Excel doesn’t have a built-in shortcut key for inserting a signature, you can easily create one using the Quick Access Toolbar or a 
macro.

If you're using a digital signature manually then it will take time and effort; Prefer a macro? You can record one that inserts an image of your handwritten or digital signature. Then, assign it a shortcut key like (e.g) Ctrl + Shift + S. With these simple methods, you’ll be able to insert your signature in Excel effortlessly, saving time and making your workflow more efficient. Simply watch the below video.


VBA Macro code:

Sub InsertSignature()

    Dim ws As Worksheet

    Set ws = ActiveSheet

    ws.Pictures.Insert ("C:\Path\To\Your\Signature.png").Select

End Sub



Note: (Replace "C:\Path\To\Your\Signature.png" with your actual signature image path)

Monday, 17 March 2025

Automatic Shortcut Key to Convert Numbers to Text in MS Word

MS Word is a one of the best tool for word processing, but unlike excel MS Word doesn’t have any direct way to convert Numbers to words, however you can make it possible by using Macros. In this article I will show you how create Macros for number to text or words. And also shows you how to create shortcut key to convert number to text in Microsoft word. You can watch the below video for butter understand. 


Macros Code:

MyNumber = Val(Selection.Text)

   Dim Temp

         Dim Rupees, Paise

         Dim DecimalPlace, Count

          ReDim Place(9) As String

         Place(2) = " Thousand "

         Place(3) = " Lakh "

         Place(4) = " Crore "

          MyNumber = Trim(Str(MyNumber))

          DecimalPlace = InStr(MyNumber, ".")

          If DecimalPlace > 0 Then

              Temp = Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)

              Paise = ConvertTens(Temp)

             MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))

         End If

          Count = 1

        If MyNumber <> "" Then

             Temp = ConvertHundreds(Right(MyNumber, 3))

             If Temp <> "" Then Rupees = Temp & Place(Count) & Rupees

             If Len(MyNumber) > 3 Then

               MyNumber = Left(MyNumber, Len(MyNumber) - 3)

            Else

               MyNumber = ""

            End If

         End If

             Count = 2

            Do While MyNumber <> ""

            Temp = ConvertTens(Right("0" & MyNumber, 2))

             If Temp <> "" Then Rupees = Temp & Place(Count) & Rupees

            If Len(MyNumber) > 2 Then

            MyNumber = Left(MyNumber, Len(MyNumber) - 2)

             Else

               MyNumber = ""

            End If

            Count = Count + 1

             Loop

               Select Case Rupees

            Case ""

               Rupees = ""

            Case "One"

               Rupees = "One Rupee"

            Case Else

               Rupees = Rupees & " Rupees"

         End Select

          Select Case Paise

            Case ""

               Paise = ""

            Case "One"

               Paise = "One Paise"

            Case Else

               Paise = Paise & " Paise"

         End Select

          If Rupees = "" Then

         Result = Paise

         ElseIf Paise = "" Then

         Result = Rupees

         Else

         Result = Rupees & " and " & Paise

         End If

         Selection.Text = Result

 End Sub

Private Function ConvertDigit(ByVal MyDigit)

        Select Case Val(MyDigit)

            Case 1: ConvertDigit = "One"

            Case 2: ConvertDigit = "Two"

            Case 3: ConvertDigit = "Three"

            Case 4: ConvertDigit = "Four"

            Case 5: ConvertDigit = "Five"

            Case 6: ConvertDigit = "Six"

            Case 7: ConvertDigit = "Seven"

            Case 8: ConvertDigit = "Eight"

            Case 9: ConvertDigit = "Nine"

            Case Else: ConvertDigit = ""

         End Select

 End Function

Private Function ConvertHundreds(ByVal MyNumber)

 Dim Result As String

      If Val(MyNumber) = 0 Then Exit Function

                   MyNumber = Right("000" & MyNumber, 3)

                If Left(MyNumber, 1) <> "0" Then

            Result = ConvertDigit(Left(MyNumber, 1)) & " Hundred "

         End If

          If Mid(MyNumber, 2, 1) <> "0" Then

            Result = Result & ConvertTens(Mid(MyNumber, 2))

         Else

              Result = Result & ConvertDigit(Mid(MyNumber, 3))

         End If

          ConvertHundreds = Trim(Result)

End Function

 Private Function ConvertTens(ByVal MyTens)

          Dim Result As String

          If Val(Left(MyTens, 1)) = 1 Then

         Select Case Val(MyTens)

              Case 10: Result = "Ten"

               Case 11: Result = "Eleven"

               Case 12: Result = "Twelve"

               Case 13: Result = "Thirteen"

               Case 14: Result = "Fourteen"

               Case 15: Result = "Fifteen"

               Case 16: Result = "Sixteen"

               Case 17: Result = "Seventeen"

               Case 18: Result = "Eighteen"

               Case 19: Result = "Nineteen"

               Case Else

               End Select

               Else

                        Select Case Val(Left(MyTens, 1))

               Case 2: Result = "Twenty "

               Case 3: Result = "Thirty "

               Case 4: Result = "Forty "

               Case 5: Result = "Fifty "

               Case 6: Result = "Sixty "

               Case 7: Result = "Seventy "

               Case 8: Result = "Eighty "

               Case 9: Result = "Ninety "

               Case Else

            End Select

              ' Convert ones place digit.

            Result = Result & ConvertDigit(Right(MyTens, 1))

         End If

          ConvertTens = Result


Monday, 26 August 2024

How to Copy Multiple Texts & Objects and Paste Them at Once

 How to Copy Multiple Texts & Objects and Paste Them at Once

Copying and pasting is a common task, but the traditional clipboard can hold only one item at a time. This limitation can be frustrating when you need to transfer multiple texts or objects. Fortunately, there are ways to overcome this using advanced clipboard tools and built-in features. Copying multiple items at once is useful for tasks like drafting documents, designing, coding, or data entry, where you need to transfer several pieces of information quickly and efficiently. Watch the video for better understanding..


Windows Clipboard History: To turn on this press Win + V and then click on “Turn On”. This tool saves multiple items in clipboard history. 

Now you can copy multiple items from different locations by pressing “Ctrl+C” keep doing copy for every item and it will store in clipboard history.

For Paste these copied items press “Win+V” and select the item which you want to paste and click on that,

By using these tools and techniques, you can easily copy and paste multiple items at once, saving time and improving your workflow.

How to Use Microsoft Office 365 in Samsung Smart TV (Word, Excel, PowerPoint)

 Unlock the potential of your Samsung Smart TV by seamlessly integrating Microsoft Office 365 applications Word, Excel, and PowerPoint onto your large screen. This guide will walk you through the steps to view, edit, and present documents with ease, allows you to work on Word, Excel, and PowerPoint documents directly from your TV screen. Watch the video for better understanding…


Connect to the Internet: Ensure your Samsung Smart TV is connected to the internet. You can do this via Wi-Fi or an Ethernet cable.

 

Set Up Remote Access: Press the Home button on your TV remote. Navigate to Workspace or Remote Access. Select Office 365.

Log In: Enter your Microsoft account credentials to log in to Office 365.

 

Use a Keyboard and Mouse: For a better experience, connect a USB or Bluetooth keyboard and mouse to your TV.

 

Access Office Applications: Once logged in, you can open Word, Excel, or PowerPoint. Create, edit, and save documents directly to OneDrive.

 

Work Efficiently: Use the TV’s large screen to view and edit documents comfortably. Save your work to OneDrive for easy access from other devices.

Friday, 23 August 2024

How to Get Missing Power Plan Option in Windows 11/10 (Fix No Power Option Available)

Missing power plan options in Windows 11 or 10, it can be frustrating, especially when you need to manage your system’s performance and energy consumption. Here’s I have showed some fixes…watch the video for better understanding..

1. Check Power Options in Control Panel:

Press Win + R, type control, and press Enter.

Navigate to Hardware and Sound > Power Options.

Ensure that the Balanced power plan is selected. If not, select it and restart your PC.

2.  Run the Power Troubleshooter:

Go to Settings > System > Troubleshoot > Other troubleshooters.

Find and run the Power troubleshooter to detect and fix any issues automatically.

3.  Restore Default Power Plans Using Command Prompt:

Open Command Prompt as an administrator. You can do this by typing cmd in the Start menu, right-clicking on Command Prompt, and selecting Run as administrator. 

Enter the following command to restore the default power plans:

powercfg -restoredefaultschemes

Press Enter and restart your computer.

Tuesday, 20 August 2024

How to Fix WiFi Keeps Disconnecting Frequently in Windows (Internet Works only after Restart)

Experiencing frequent WiFi disconnections on your Windows PC can be incredibly frustrating, especially when the internet only works after a restart. This issue can stem from various causes, ranging from software glitches to hardware problems. Here’s a comprehensive guide to help you troubleshoot and resolve this issue. (Please watch the below video)

1. Troubleshoot Wif & Internet

2. Use Command prompt to reset catalog: (watch the video)  

3.  Restart WLAN AutoConfig Service: Press Windows + R, type services.msc, and press Enter. Find WLAN AutoConfig in the list. Right-click and select Restart.

4.  Change DNS Settings: Open Control Panel and go to Network and Sharing Center. Click on Change adapter settings. Right-click your WiFi connection and select Properties. Select Internet Protocol Version 4 (TCP/IPv4) and click Properties. Choose Use the following DNS server addresses and enter a preferred DNS server, such as Google’s (8.8.8.8 and 8.8.4.4).

How to Free Up & Clear MacBook RAM Cache to Boost Performance

RAM plays most important role for your MacBook performance. Over time, your Ma c stores temporary data in RAM to help apps run faster. But w...