Category: MS Office
-
How to Change the Decimal Separator in Excel
Why Change the Decimal Separator? Different regions around the world use different characters as decimal and thousands separators. For example, in the United States, a period (.) is commonly used as a decimal separator, while a comma (,) is used to separate thousands. In many European countries, the opposite is true—a comma is used as…
-
A trick to flip a column upside down in Excel
Excel users can sort a column using the Sort feature available as part of Sort & Filter menu. But what if you want to flip a column upside down. Let us see this with an example column having some text values as shown below. We will not be able to apply sort feature directly on…
-
Prevent users from adding new worksheet in Excel
Excel 2016, 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure. So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet, rename or move worksheet then you can use Protect Workbook Structure option to…
-
Turn off display search as you type in Microsoft Outlook
Microsoft Outlook provides option to display search results as we type the text in search box. This is a useful feature but if you think the real-time search result is a distraction then you can disable “display search as you type” feature using Search options. Listed below are steps to turn off this feature in…