Win10: How to Speed Up Internet Using Command Prompt

speed

I noticed that when I used my Android phone as a wifi hotspot to get my Windows 10 laptop connected with the internet, I got very poor connectivity on the laptop while it was just fine on the phone. I guessed it got something to do with the Window Auto-Tuning feature, so I tried to disable it by using these commands in an elevated Command Prompt in a hope that it would improve speed performance.

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

It worked.

However Microsoft has published a statement noting that disabling it will otherwise limit the internet speed! Well, the choice is yours.

 

Advertisements

Excel: Center Alignment for Numbers Formatted as “Accounting”

Untitled

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:

0.00;-0.00;”-”

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

https://www.mrexcel.com/forum/excel-questions/296470-alignment-numbers-formatted-accounting.html

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:

WAIT SECONDS=(n)
(n) is the number of seconds to wait

Example:

...
TAG POS=1 TYPE=SELECT FORM=NAME:f1 ATTR=ID:batch_no CONTENT=%0001
WAIT SECONDS=5
TAG POS=1 TYPE=SELECT FORM=NAME:f1 ATTR=ID:location CONTENT=%1
...

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.

carrots