Excel - ftsrg/cheat-sheets GitHub Wiki

Use comma in CSV exports on systems with Hungarian regional settings

Go to the Control Panel, Clock, Language and Region, Change date, time, or number formats. Change the Decimal symbol to . and the List separator to ,.

Regional settings

In Excel, go to Save as and pick the CSV (Comma delimited) type. In Hungarian systems, the type name is always CSV (pontosvesszővel tagolt), even if you changed the list separator from semicolon to comma.

CSV export

Remove password from an Excel document

Most "password-protected" Excel worksheets can be easily unlocked using the Excel Add-in available here: http://www.straxx.com/free-excel-password-remover-2012/