In
Excel 2007, you can still select multiple drawing objects by drawing a selection box. Here's how:
- Click on the "Home" tab in the ribbon.
- Click on the "Select" dropdown menu in the "Editing" group.
- Select "Select Objects" from the dropdown menu.
- Click and drag your mouse to draw a box around the objects you want to select.
As for changing the length of a drawing line while maintaining its direction, you can use the
"Shift" key instead of the
"Ctrl" key. Here's how:
- Click on the drawing line to select it.
- Click and hold on one end of the line.
- Hold down the "Shift" key.
- Drag the end of the line to the desired length.
This should maintain the original direction of the line while changing its length.