Win10: How to Speed Up Internet Using Command Prompt


I noticed that if I used my Android phone as a wifi hotspot to get my Windows 10 laptop connected with the internet, I got very poor connectivity with the laptop while the connection is fine with the phone. And when I used these commands in an elevated Command Prompt to fix the issue, somehow it works.

netsh int tcp set heuristics disabled
netsh int tcp set global autotuninglevel=disabled

The reason is based on the opinion that sometimes poor internet connections are caused by Window Auto-Tuning, and disabling the feature will improve speed performance. However Microsoft has published a statement noting that disabling it will limit the internet speed and won’t improve it! So the choice is yours.



Excel: Center Alignment for Numbers Formatted as “Accounting”


If you select one of your cells formatted in Accounting and go Format –> Cells –> Number tab and then click on the Custom category, you will see how your format is built up.

It will be something like the following:

_($* #,##0.00_);_($* (#,##0.00);_($* “-“??_);_(@_)

It is the “* ” (asterisk followed by a space – ignore the quotes) in the number format that prevents you from centering.

However, if you customize by removing the asterisk then your currency symbol won’t remain left-aligned in the cell. If you can live without the currency symbol then something like:


will suffice, and you can easily center this in the cell yourself.

That Annoying Printer Problem

This works for Epson L-210.

When ink indicator light is blinking:

Press and hold paper/ink button for 5 seconds then release the button, quickly press and hold again for about 3 seconds then release the button and finally press again once. Restart the printer.

When ink indicator light is on:

Turn off the printer. Wait 10 seconds. Press and hold paper/ink button, then press and release Power button. The printer will turn ON and Power Green light will start to blink. Release paper/ink button. Press and hold the button again for 10 seconds, then release. Press and hold for 1-2 seconds again and release.

How to format a volume larger than 32 GB in size using the FAT32

Few days ago I just found out that I could not format a volume larger than 32 GB in size using the FAT32 file system with the Windows native formatting tool.  Windows can mount and support FAT32 volumes larger than that, but can’t format. The options are only exFAT and NTFS. FAT32 is an outdated file system, but it’s the only one my TV can read. So if for that reason or something else you have to format a flashdrive larger than 32 GB using FAT32, use this tool: fat32format.exe.

You have to run it from the command line, btw. But so far, it’s the only one that really get the job done. For download link and instructions go here.

iMacros: How to Delay Executing the Next Command

While filling out a form, sometimes we need to wait for few seconds before continuing replay with the next command in iMacros, e.g. when a dynamic dropdown list is responded slower than it should. What can we do?

Use this command:

(n) is the number of seconds to wait



Volume²: the Windows Volume Control Replacement

I’ve been in this situation: The tiny little volume control icon on my Win 10 notification area went missing. Or maybe it was actually never there since the beginning, I didn’t know. I did some searching around but nothing found so I was really up the creek on this one. But then there was one thing that finally came to the rescue. It’s a tiny little free software called Volume², a program to replace the standard Windows Volume Control developed by Alexandr Irza from Ukraine.

OK. That’s it. Sorry for the short post. Here eat a carrot.