From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Change cell borders

Change cell borders

- [Instructor] We've got a small event coming up, and somebody sent us this seating chart. We don't need all of these colors here, this green lines, purple lines, and then we have some inconsistency like down here in the front row, we've got a border between these two chairs, border here. We don't need that. Here's where your help is needed. Change all of the borders to gray, dashed lines. You get to pick the shade of gray. You get to pick the type of dashes. Also, remove borders where there are no seats because look at this right here. This is an aisle. We don't need borders there. This is an aisle right here, no borders. This is supposed to be an empty space. All right, please pause the video, and get this squared away. (upbeat instrumental music) (upbeat jingle) Okay, let's clean this up. I am going to highlight this entire calamity. I'm in the home tab of the ribbon. Go here. Now, more borders. Not all of this…

Contents