Here's a quick method, and the equivalent keyboard shortcut, for selecting an entire data range. Working with a complete data set is a common task in Excel. You might want to move the data, apply ...

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

Click the upper-left cell in the range with the border you want to copy. Drag your cursor to the range's lower-right cell, selecting the entire range. Click "Home" on Excel's menu bar.

The Location Range text box should show the cells used to hold the Sparkline graphs, but you can adjust this by selecting the text in that box and using the mouse to select a row or column of cells.