How to make all Data Small?

Step 1

=Lower(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

Lower Command to Make Data in Small Letters - Basic Formatting

Download Excel File And Try

Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 14 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.