From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Horizontal sort

Horizontal sort - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Horizontal sort

“

- We're trying to manage these projects and we've got this data that makes no sense because of the way that the columns are lined up. Why is Project Number in the middle of the dataset? It should be on one end or the other. So, we're going to clean this up. First, get the columns in the following order, Project, Approved, Approved By, Started, Days Allotted, Complete, Actual Time, Days, and wrap it up by center-aligning Approved, Complete and Started. Okay, ready to take that on? Pause the video. Get the exercise file. Clean this up, come back and we'll do it together. Alright, let's do this 'cause I'm going to take you into an area of Excel that's known by few. Let's go up to Row 1, right-click, Insert. Now what is the order that we want the columns in? Project is number one. Approved... Two. Approved By... Three. Started... Four. Days Allotted... Five. Complete... Six. Actual Time...…

Contents