From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Create tables and eliminate hyperlinks

Create tables and eliminate hyperlinks - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Create tables and eliminate hyperlinks

“

- [Instructor] All right, we're going to do some table stuff here. We've got two different datasets. Over on the left side, the Name through Volunteer Hours and then a separate dataset with Name through Exam3. What we want to do, convert both datasets into tables, and you get to pick how you name these tables. Then, use the table settings to show a sum of the volunteer hours in column F. Don't write a formula for that, all right? And then, get rid of these doggone hyperlinks. Every time we touch on one of them, some box opens up that we don't want to use. So get rid of the hyperlinks and prevent Excel from automatically creating more hyperlinks, all right? Pause the video, tighten this up, come back, watch me do it. All right, you're back, let's do this. Cursor in the dataset, format is table. Table does have headers. I don't want these filter buttons. I'm going to name this Exams. Now I want to deal with these…

Contents