Search in Excel 2016
How to remove the diamond with question mark symbol
When you paste or import data into the Excel spreadsheet, you might notice unusual symbols like
a diamond with a question mark. The replacement character � (often a black
diamond with a white question mark or an empty square box) represents an unknown, unrecognized
or unrepresentable character:
How to change comma to decimal point and vice versa in Excel
Because of different standards of different countries and cultures, there is a lot
of situations when you need to change commas to dots, decimal points or dots, decimal
points to commas in an Excel spreadsheet:
How to select all the embedded charts on the worksheet
If you need to select all objects embedded into the worksheet, e.g., select all charts to adjust their size,
press Ctrl+G and click the Special button or use Ctrl to select objects individually.
How to use keyboard to navigate in the spreadsheet
To move around the worksheet with your keyboard, use the key combinations: