How to Create a New Workbook in Excel. In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on ...

If you would like to enable Shared Workbook option, here's a way to add it to Excel Quick Access Toolbar. It is hidden under Excel Options.

I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of your ...

Notes: If you save your range names to the workbook instead of the individual worksheets, you can create formulas that calculate your named ranges from anywhere on any spreadsheet in the workbook.

Microsoft Excel 2007 provided many new features over its predecessors and, to make it more useful in the workplace, it also offered additional tools for collaboration and data sharing. One of ...