Embedded Files
Microsoft Excel
Microsoft Excel
UTF-8 Encoding
UTF-8 Encoding
Set UTF-8 Encoding as default: https://superuser.com/questions/911369/excel-change-default-encoding-file-origin-of-text-import-wizard-to-utf-8-650
> Registry Editor > Computer > HKEY_CURRENT_USER > Software > Microsoft > Office > [version number e.g. 16.0] > Excel > Options: create new file DefaultCPG as 32 bit DWORD, open and change to decimal, and enter 65001.
Shortcuts
Shortcuts
Rows and Columns
Rows and Columns
ALT + H, O, I: adjust column width
ALT + H, O, A: adjust row height
Freezing
Freezing
ALT + W, F, F: unfreeze / freeze by selected cell
ALT + W, F, R: only free first row
Formatting
CTRL + Shift + 1: number with thousands separator and two decimal places, e.g. 7,348,23
CTRL + Shift + 4: currency, e.g. € 1,439.95
CTRL + Shift + 5: percentage, e.g. 59%
Page updated
Google Sites
Report abuse