OKay first
1) fit on single page
File
Page setup
potrait
fit in page width and height
note.....it won't fit on a page as yet....so go to the next part
2)filtering
select the field
go to data>filter
a drop down appears....for week you do 35
for date...click custom
you'll get a window
in the first drop down....put greater than...and to it's right 01/01/2009
and
in the second put less than...31/01/2009
thennn
3) select the field not require......go to format>column>hide
4) expand the columns so the field names are completely visible
5)click on the date field and staff field>data>sort>ascending order for date first..then by staff
6) view>header and footer>custom.....in the middle type mini tours and in the right tyoe ur name,centre,candidate no
DONE
