Excel should have already selected the data for you. In the same manner, add the rest of the worksheets you want to combine. Click "OK" to close the Consolidate dialog.

In Excel, there are options to add both predefined cell borders and custom cell borders. 1] How to add borders to a cell in an Excel worksheet Open Microsoft Excel. Click on a cell in the worksheet.

Step by step guide to group Worksheets in Excel to apply common changes. It is useful when you need to apply the same formula, data or column.

How to Add an Overlay to Excel. Microsoft Excel 2010 can create a chart to illustrate numeric data from a worksheet. Excel's "Chart Tools" contain "Labels" that customize the chart area.