Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home ...

When you complete your analysis, you can convert the table back to a data range by following these steps: 1. Click any cell in the table. 2. Click the Design tab under Table Tools in the title bar. 3.