If you want to create multiple worksheets in multiple Excel workbooks, you can set the default number of worksheets when you open Excel.

Let’s say you have an Excel workbook with one worksheet that holds data and another worksheet for an income statement. As you construct the income statement, you realize that it would be helpful to ...

You can change views in Excel depending on what you're doing and what you want to see. Learn how in this step-by-step tutorial.