A few helps for the final excel practice

10 Sort all rows except the headings in description order:
Overview: The purpose of sorting is to put rows in a different order, and to set that order to follow one of the parts of the row alphabetically. Because you want the entire row to sort, you need to highlight the entire row, not just the column that is being alphabetized. Sorting is like formatting in that it will effect all the highlighted parts, so the first step is to highlight all the rows. Then, unlike formatting, you need to select from the data menu instead of the format menu. Choose the sort option, and it will ask you which column is being alphabetized.

Relation to inventory exercise: This is the same as step 5. in the inventory excel spreadsheet, and here are the exact steps as it pertains to the final exercise.
1. Highlight rows 5-57 by placing your cursor on the # 5 and then hold the shift key and click the number 57. You want all the rows selected, not just a few cells.

2. Choose Data and then Sort and then choose Description or column C in "Sort by". When you press okay, you will see all your items in a different order, but the same quantities should be next to them. If it is wrong, immediately choose Edit / Undo and try again. Be sure the entire rows are highlighted before you sort.

11 set up the headings (Item #, Category, Description, Vendor, QTR 1) to print at the top of each page
Overview: Headings happen behind the scenes of the spreadsheet. You only see them when you print or print preview. Everything that happens behind the scenes upon printing is bundled into page setup. Column headings are set on the "sheet" tab of page setup. They are labeled "rows to repeat". What you really want is for excel to repeat row #4 every time it prints a new page. So, you will put row 4 into the rows to repeat. Excel wants the number for row 4 formatted a strange way though, so instead of typing in 4, hit the little spreadsheet entry button and then click on row 4 and enter so that Excel formats the row 4 properly.

Relation to inventory exercise and exact steps: This is the same as step 13, but you will be choosing row 4 instead of row 1.
1. Click on file
2. Click on page setup
3. Click the sheet tab (in page setup)
4. click on the box after "Rows to repeat at top".
5. Click on the row number 4 and then hit enter.
6. hit enter again

12 set up those same headings to stay put as you scroll
Overview: When you scroll down, your headings will disappear. You want the headings to stay put, and all the items to slide up underneath the headings as though the heading where the top windowpane and the first item row were the top of the bottom window pane. When you slide the window up, the top of the window disappears behind the top window.
This is done with the freeze pane function. It does not effect how the spreadsheet prints, so it is not in the page setup option. Instead, it is in the Window option. I think it is difficult that you need to define the top of the moving pane, not the row headings, so you highlight the whole row UNDERNEATH the heading, and then click window / freeze pane.

Relation to inventory exercise and exact steps: This is the same as step 17, but you will highlight row 5 instead of row 2.
" Click the row number 5 to highlight the entire row 5.
" Choose windows / freeze pane.
" Scroll down to be sure that row one does not move.

13 Tell excel to only print landscape and only one page wide
Printing landscape just means turning the paper sideways. Because this doesn't change how the spreadsheet will be viewed, it is in file / page setup. Just click landscape in there.

Fitting to one page wide is trickier. It means taking a spreadsheet that doesn't fit all the columns across one page and squishing it so it fits. This is also something you will only see when you print, so it is in page setup. You need to click the option "fit to" which will fit the columns even if normal spacing would have a column hanging off the page. You want to set it to only 1 page wide because you are looking to squish the columns into only one page across. You don't want to squish the number of pages into 1 though, so be sure to set the total number of pages tall to a big number.

Relation to inventory exercise and exact steps: This is the same as step 14.
1. Set the page to print only one page wide, so you don't have to tape two pages together.
" Click the Page tab
" Click the fit to button
" choose 1 page wide by 99 tall

14 Print preview to see the headings and to see that it is just one page wide.

When you press file / print preview, you want to keep scrolling to see that every page looks normal. If the squish to one page did not work, at the end of the pages of items, you would see every page again, but this time only with the last column all by itself.