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.

Clean up bizarre formatting

Clean up bizarre formatting - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Clean up bizarre formatting

- [Instructor] Well, well, our jokester friend Connie is at it again. You and I are gettin' ready to go into a meeting with our best clients, we asked Connie to send us a report, and she does things like this. The formatting is all weird and this laughing heart, what is that about? We've got to hurry up, get this straightened out so we can go into the meeting. Remove the laughing heart, convert the entire sheet to Calibri font, clear all cell field colors, merge project status report across columns A through F and underline it, then in the days behind schedule column make those numbers red and bold. Pause this, come back, I'll show you a solution so we can go to this meeting. We're back and I hope you got this straightened out. We gotta hurry up and get this ready. So, remove this heart. Highlight it, click delete, gone. Convert the sheet to Calibri font, go up to this corner, okay, highlight the whole sheet, go on up here, and I'm gonna select Calibri. Next, clear all cell field…

Contents