anything in Excel...

It's Excel-o-lozy...

Keyboard error shift + 2 is ' rather than @ (number help)

www.Excelolozy.comWhen Shift key is held down and 2 is pressed then it shows ‘ (single quote) rather than @ (at).

This happens with all number keys that don’t work in combination with shift key. 

This happens due to language settings of keyboard that is set as UK or some other one, instead of US.
To solve this go to :
Control Panel > Regional settings > Key board settings > Change the keyboard from UK to US > then select all others Key board languages and click “Remove”.

Anything in Excel, be an Excelolozian...

for best MS Excel Tips visit

gotta query??? drop a mail at