Excel DHS Questionnaire User’s Guide Page 9
tions to copy and paste. It’s also a good place to find skip arrows and boxes (see
below). You may want to delete it when you’ve finished developing the question-
naire.
Skip arrows and boxes
The skip arrows and filter boxes are Excel AutoShapes. The AutoShapes are an-
chored to the cells they’re in, so they should move with the question they’re at-
tached to when you add or delete questions around them.
Unless you need an entirely new shape, don’t create arrows or boxes from
scratch. Copy one that looks like what you need and modify it. The easiest way
to copy and paste AutoShapes is to select the cells they’re on top of, copy the
cells, and paste them where you need the new AutoShape.
To modify an existing AutoShape (for instance, to lengthen the arrow that
extends from a box), right-click on it and choose Edit Points from the menu.
Black squares will appear at the corners of the AutoShape. You can then drag the
black squares until you have the shape you want. You may find it useful to hold
down the Shift key as you drag the black squares; this will constrain the mouse to
horizontal or vertical movement.
Try to avoid changing the shape of an arrow or box by left-clicking on it and
dragging the handles that appear around it. This will distort its shape. It’s better
to right-click, choose Edit Points, and then make the changes you want.
To move an AutoShape, left-click on it to select it, position your cursor on
top of it until the cursor changes to a four-arrow shape, then click and drag. You
can also use the arrow keys to move an AutoShape when it’s selected.
To delete AutoShapes, click on them to select, and press Delete. If you select
the cells they’re anchored to and delete the cells, the shape usually won’t get de-
leted along with them. Just delete it manually, by clicking on it directly and
pressing Delete.
Printing
To print the questionnaire, go to File > Print, and under the “Print what” sec-
tion, choose “Entire workbook”. Then click OK. This will print the entire ques-
tionnaire. If you want to print just one section of the questionnaire, you can
choose the “Active sheet(s)” button instead, but when you print using this option,
the page numbering will be incorrect.
If you need to print just part of the questionnaire with the correct page num-
bers, go to File > Print, but don’t choose the “Active sheet(s)” button. Instead,
choose the “Entire workbook” button, then click the “Preview” button directly
underneath. Click on the page to zoom in so you can read the page numbers,
then use the “Next” and “Previous” buttons to read through the questionnaire
and determine which page numbers you wish to print. When you know what
pages you need, press the “Close” button. Return to File > Print, choose the “En-
tire workbook” option, then enter the page numbers you want under “Print
range” and click OK.
ow to… create
new skip arrows
and filter boxes