Search in Excel 2007
How to select all the embedded charts on the worksheet
If you need to select all objects embedded into the worksheet, e.g. select all charts to adjust their size,
press Ctrl+G and click the Special button or use Ctrl to select objects individually.
How to use keyboard to navigate in the spreadsheet
To move around the worksheet with your keyboard, use the key combinations: