1: I'm assuming they used data validation. If so, there's probably a
list either in the validation rule, or a cell range somewhere
(possibly on a hidden sheet). If this is the case, I don't think
there's a way to display the arrows unless a cell with the rule is
selected.

2: You can set Print Area (file menu or Page Setup) to determine what
gets printed. In VBE, you can set scroll area to the worksheet. If
you press Alt+F11, then Ctrl+G, then type ActiveSheet.ScrollArea = "$A
$1:$Z$100" and press Enter, the user will not be able to scroll past
Z100.

3: You can download free PDF Printers, which will preserve
spreadsheets as tables. They install just like regular printers, but
instead of printing on paper, they make PDF files. If you have
Acrobat Pro, I believe it comes with one of these - ours did here at
the office. However, to make it fully functional (with dropdowns,
etc) you'll need some other software (like Acrobat Pro) and some basic
skills using it.


On Nov 29, 4:20 pm, toorie53
wrote:
I am creating a form that will be going to a number of people for a client
and it needs to be as easy as possible for them.

1- I have created drop down boxes, is there any way to keep the arrow
visable at all times. I received a document with it done, but it is
protected and I can't figure out how they did it.

2 - Is there any way to eliminate the unused part the spreadsheet? I'm only
using 1 8 1/2 by 11 page of it

3 - Is there any way to PDF a spreadsheet?

Any help would be greatly appreciated.
Thank you,
Kristen