How to make all first letter Caps and all other small?

 

Step 1

=Proper(Select One Cell)

 

Step 2

Copy Paste for all Cells

 

Step 3

Copy whole Row or Column

Paste Special at the place where required

 

Step 4

Delete Copied Cells

 

Example

Proper Command to Make Only First Letter Capital - Basic Formatting

Download Excel File And Try

 

  1. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 8 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .