Otherwise, Excel opens a new spreadsheet for you to use. Click once on the line number, which appears as the first column on the Excel workspace, to highlight.

In addition to basic calculation functions, Excel also provides data analysis tools that allow you to find the R2 of two lines with an Excel formula. R2, or R-squared, is the relationship between ...