11 Keep the existing filter and add a filter to display classes
5.000 that start at 9:00 AM , 10:00 AM , 11:00 AM , and 12:00 PM .
12 In the Faculty sheet , insert a field on the right side of the
15.000
Room field . Type the label Capacity . Insert a lookup function that looks up the room number , compares it to the lookup table in the Room Capacity worksheet , and returns the room capacity . Make sure the function copies down the entire column .
13 To prepare the workbook for printing , repeat the column
10.000 labels on all pages for the Faculty , Rooms , and Prime Time worksheets .
Select the first three sheet tabs . Set 0.2-inch left and right margins , Landscape orientation , and 95 % scaling .