Data Selection keyboard shortcuts -Source Data Window

[Carol Hackney]

When making scatterplots in Excel 2000, is there a
keyboard shortcut to select the data once you are in the
Source Data window? This is a very large spreadsheet and
standard keyboard data selection shortcuts don't work when
the Source Data window is open.

 

[Debra Dalgleish]

When creating the chart, keyboard shortcuts (e.g. Ctrl+Home; Ctrl+End;
Shift, followed by arrow key) should work while you're in the Source
Data page of the Chart Wizard.

However, after the chart has been created, if you choose Chart>Source
Data, you'll have to select the cells with the mouse.