வியாழன், 20 அக்டோபர், 2016

How to Spell Check In Excel

How to check spellings in Microsoft Excel:

Checking spellings in excel is very easy. Follow below steps to perform a spell check in Excel.
  • With your excel spreadsheet opened, simply navigate to the ‘Review’ tab in the ribbon.
  • In the ‘Review’ tab there is an option ‘Spelling’ as shown in the image.

Excel - Changing CAPITAL LETTERS to Sentence case

However you can use this method

So what do you do if you have a column of Names all typed in CAPITAL LETTERS?
Microsoft Excel has some handy functions to change case - this is what you can do:

1. Here is an example of a dreadful muddle of text cases in column A.
excel example

How to Change from Lowercase to Uppercase in Excel

How to Change from Lowercase to Uppercase in Excel

Microsoft’s Excel spreadsheet program has several functions to make your text type-case consistent. If you have a series of names that is in the lowercase, you can use “flash fill” function to capitalize names in Excel 2013. If you need all the text to be uppercase, you can use UPPER function to capitalize all the letters or PROPER to capitalize the first letter.