Check sibling questions


How to make all Data Caps?

Step 1

=Upper(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 Cell


Example 1
Upper Command to Make Data in Capital Letters - Basic Formatting

Download Excel File And Try


Excel Shortcuts Masterclass by CA Maninder Singh
- on Sunday, 20 Nov, at 1pm

CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

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