From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Format the cells in a form

Format the cells in a form - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Format the cells in a form

- [Instructor] Our director is creating this form in Excel and has given us the format that he wants for this name and its corresponding field. He wants registration number to look that way. He wants email, arrival date, and departure date to take on phone and its corresponding field and that's where you come in. Pause the video, get this formatting squared away, come back, and I'll show you a solution. Okay, you're back. We're gonna change the registration number and corresponding field to look like name and its corresponding field. I'm gonna highlight both name and its field or the format painter and then click on registration number. So I'm gonna double click column E to widen it so we can see those two fields do look the same. Next, we take phone and its field and replicate that format in the other three fields. So I'm gonna highlight these two cells. Double click format painter because we're gonna do this multiple times. Double click it, click arrival date, departure date, email.…

Contents