Check sibling questions

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



Proper Command to Make Only First Letter Capital - Basic Formatting

Download Excel File And Try


Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.