Friday, October 14, 2016

Full form of most used Acronyms

GOOGLE: Global Organization Of Oriented Group Language of Earth (ग्लोबल आर्गेनाइजेशन ऑफ़ ओरिएंटेड ग्रुप लैंग्वेज ऑफ़ अर्थ) 

YAHOO: Yet Another Hierarchical Officious Oracle (यट अनेदर हिरार्चीकैल ओफ्फिसियस ओरेकल)

GPRS: General Packet Radio Service (जनरल पैकेट रेडियो सर्विस)

ZIP Code: "Zone Improvement Plan" Code (ज़ोन इम्प्रूवमेंट प्लान कोड)

GPS: Global Positioning System (ग्लोबल पोजिशनिंग सिस्टम)

AM: Anti Meridiem (एंटी मेरिडियम)

PM: Post Meridiem (पोस्ट मेरिडियम) 

ATM: Automated Teller Machine (ऑटोमेटेड टेलर मशीन) 

CTC: Cost To Company (कॉस्ट टू कंपनी) 

USB: Universal Serial Bus (यूनिवर्सल सीरियल बस) 

VIRUS: Vital Information Resources Under Seize (वाइटल इंफॉर्मेशन रिसोर्सस अंडर सेज) 

SIM : Subscriber Identity Module (सब्सक्राइबर आइडेंटिटी मॉड्यूल)

MMS: Multimedia Messaging Service (मल्टीमीडिया मैसेजिंग सर्विस)

SMS: Short Message Service (शॉर्ट मैसेज सर्विस)

WI-FI: Wireless Fidelity (वायरलेस फिडेलिटी)

GSM: Global System for Mobile Communication (ग्लोबल सिस्टम फॉर मोबाइल कम्यूनिकेशन)

CDMA: Code Division Multiple Access. (कोड डिविज़न मल्टिपल एक्सेस)

JPEG: Joint Photographic Expert Group (ज्वाइंट फ़ोटोग्राफिक एक्सपर्ट ग्रुप)

PDF: Portable Document Format (पोर्टेबल डॉक्यूमेंट फॉर्मेट) 

LMAO: Laughing My ASS Off (लाफिंग माई ऐश ऑफ)

LOL: Laughing Out Loud (लाफिंग आउट लाउड)

OK: Oll Korrect ( ऑल कोर्रेक्ट)

PNR: Passenger Name Record (पेसिंजर नेम रिकॉर्ड)

LCD: Liquid Crystal Display (लिक्विड क्रिस्टल डिस्प्ले)

IFSC: Indian Financial System Code (इंडियन फाइनेंसियल सिस्टम कोड)

TRP: Television Rating Point (टेलिविजन रेटिंग प्वाइंट)

LED: Light Emitting Diode (लाइट एमिटिंग डायोड)

UFO- Unidentifiable Flying Object ( अन आईडेंटिफाइेबल फ्लाइंग ऑब्जेक्ट)

Read source: Click here

How to disable taskbar preview thumbnails in Windows 10

In Windows 10, when you hover over a taskbar button of a running app or group of apps, a thumbnail preview appears on the screen. For a single window it shows a single thumbnail, and for multiple windows it shows a number of thumbnail previews in a row. If you wish to disable these thumbnails in Windows 10, I will explain how it can be done with a simple Registry tweak.

To disable taskbar preview thumbnails in Windows 10, do the following:
  1. Open Registry Editor.
  2. Go to the following Registry key:
    Tip: You can access any desired Registry key with one click.
  3. Here, create a new 32-bit DWORD value named ExtendedUIHoverTime. Note: If you are running 64-bit Windows 10, you still need to create a 32-bit DWORD. Set its value data to 9000 in decimals. This means it will show the thumbnail after 9000 milliseconds (or 9 seconds) of hovering over any taskbar button. So, with such a high timeout value, you will never see taskbar thumbnail previews. disable taskbar thumbnails in Windows 10
  4. Restart the Explorer shell or sign out and sign in back to Windows 10.
This will disable taskbar thumbnail previews in Windows 10. See screenshots below.
single window preview Windows 10
single window preview Windows 10 disabled It is possible to disable taskbar thumbnails only for a group of opened windows i.e.multiple instances of the app. Once this is done, Windows 10 will show a list of windows instead of thumbnails. The list makes it easier to identify them from a group instead of mostly similar looking thumbnails. To do this, follow these instructions:
  1. Go to the following Registry key:
  2. Create a new 32-bit DWORD value named NumThumbnails. Leave its value as 0. Note: If you are running 64-bit Windows 10, you still need to create a 32-bit DWORD value. disable taskbar preview thumbnails in Windows 10
  3. Restart the Explorer shell or sign out and sign in back to Windows 10.

Or simply try this software

Winaero Tweaker

If you would like to avoid Registry editing, here is good news for you. In the past, I created a freeware tool called Winaero Tweaker, One of its options is "Taskbar Thumbnails". It can tweak and change many hidden secret taskbar thumbnail parameters which cannot be changed via the Windows 10 GUI.
Winaero Tweaker taskbar thumbnails It can control all mentioned parameters in the article and many more. Using this tool, you will be able:
  • Adjust thumbnail size.
  • Adjust number of grouped application thumbnail windows.
  • Adjust horizontal spacing between the thumbnails.
  • Adjust vertical spacing between the thumbnails.
  • Adjust thumbnail's caption position.
  • Adjust thumbnail's top margin.
  • Adjust thumbnail's bottom margin.
  • Adjust thumbnail's left margin.
  • Adjust thumbnail's right margin.
  • Completely disable taskbar thumbnails.
To run it in Windows 10, download Winaero Tweaker from here. It works in Windows 10, Windows 8 and Windows 7 without issues.

Friday, August 19, 2016

How to remove trailing spaces from cells in Microsoft Excel?

Sometime we may add unwanted spaces in Excel cells, which are not easy to find out but affect sorting, calculating, or others. This article will introduce several methods to remove trailing spaces after text strings of cells in Microsoft Excel.

arrow blue right bubble Remove trailing spaces from cells in Excel with VBA

Using the Trim function is easy to remove the trailing space in one cell, but time-consuming to remove trailing spaces in many cells. Here provides a macro to remove all trailing spaces of all cells in a selection.
Step 1: Select the range in which you want to remove trailing spaces from cells.
Step 2: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 3: Click Insert > Module, and paste the following macro in the Module Window.
Sub NoSpaces()
Dim c As Range
For Each c In Selection.Cells
c = Trim(c)
End Sub
Step 4: Press the F5 key to run this macro. And all of the trailing spaces of the selection will be removed.

arrow blue right bubble Remove trailing spaces from cells in Excel with Kutools for Excel

Maybe you are not familiar with Microsoft Excel's Macros, and need time to study it. Please do not worry about it. The second method is provided by a third-party add-in, Kutools for Excel. Its Remove Spaces tool can help you remove trailing spaces from cells quickly.
Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.
Step 1: Select the range in which you want to remove all trailing spaces from cells.
Step 2: Click the Kutools > Text Tools > Remove Spaces. See screenshot:
Step 3: In Remove Spaces dialog box, check the Trailing Spaces option in Spaces Type section. See screenshot:
Step 4: Click OK or Apply. And all the trailing spaces after the text string have been removed. See screenshot:
doc-remov-trailing-spaces3 -2 doc-remov-trailing-spaces4
Kutools for Excel's Remove Spaces tool makes it possible to delete all kinds of spaces from strings in cells, including all extra spaces, leading spaces, trailing spaces, or all spaces. Click to know more...

Saturday, August 13, 2016

The Save As dialog box appears two times when you try to save a file in Word 2010 or in Word 2007

When you click Save or Save As to save a file in Microsoft Word 2010 or in Microsoft Word 2007, the Save As dialog box appears two times.

Save as window appears twice
This problem occurs because the Normal.dotm template is corrupted.
To resolve this problem, create a new Normal.dotm file by changing the name of the old file. To do this, follow these steps: 
  1. Start Windows Explorer, type %appdata%\Microsoft\Templates in the address bar, and then press Enter.

    Templates folder
  2. Right-click Normal.dotm, and then click Rename.

    Normal.dotm file
  3. Change the file name to Normal.old.dotm.

    Changing to Normal.old.dotm
  4.  Restart Word. A Normal.dotm template is automatically generated.

    new template file
  5. Try to save a file to check whether the problem is resolved.


Wednesday, March 9, 2016

Count The Number of Cells With Specific Cell Color By Using VBA

Here the steps to create the count cell color UDF:

  1. Open Microsoft Excel then press Alt+F11 to show Visual Basic Editor window.
  2. On Insert menu, select Module to create a module. Then write the following script:
    Function CountCcolor(range_data As range, criteria As range) As Long
        Dim datax As range
        Dim xcolor As Long
    xcolor = criteria.Interior.ColorIndex
    For Each datax In range_data
        If datax.Interior.ColorIndex = xcolor Then
            CountCcolor = CountCcolor + 1
        End If
    Next datax
    End Function
  3. Close VBE window and back to Excel.
  4. To test the UDF, create some example data, or you can download this example file here.
  5. At cell D3, write the function: =CountCcolor(range_data,criteria)
    in range_data argumen, select cell C2 to C51
    in criteria argumen, select cell F1

  6. Press Enter and in cell F2 the result is 6. It means the number of cells with Blue cell color is 6 cells.

  7. You can also test another color. Change the color in cell F1 with any color you want from the data by using Format Painter to get same color.

  8. You can also pack the UDF, so that function can be used in another workbook and machine. Please following this steps :

    Step 1: Save The Workbook

    1. Fill the name that you want named to at the File Name box. Here I name it Count Cell Color.
    2. For the file type, choose Excel Add-In (.xlam) format.

      Note: You can save your Add-In file anywhere you want. But if you want it to be listed on Excel built-in, you should save it into the default location. On my computer with Windows 7 operating system, the default location for any versions of Microsoft Excel is: C:\Users\RADDINI\AppData\Roaming\Microsoft\AddIns

    Step 2: Install the Add-In
    1. Open Microsoft Excel on computer that you want install the Add-In. Open Add-Ins dialog box by clicking Add-In on the Developer tab.
    2. On the Add-In dialog box, click Browse button so Browse dialog box is displayed.

    3. Go to file location that Add-In file is saved. Choose the file and then click Open.
    4. On the Add-Ins dialog box make sure the add-in checkbox is unchecked. Then click OK.

Now the Count Cell Color UDF has installed and ready to use.

Blogger Tips And Tricks|Latest Tips For Bloggers Free Backlinks