Working with Multiple Workbooks

In some situations, you might have more than one workbook open at a time. You can open as many workbooks as will fit in your computer's memory. However, when you open multiple workbooks, you need to know how to manage them. You can arrange them in various ways on your screen and then move between them in a snap to get to the workbook you want. You can even copy and move data between workbooks instead of typing the same data over and over into multiple workbooks.

Arranging Workbooks

Suppose that you want to see all the open workbooks at one glance. You can do just that by arranging them on the screen for easy viewing. Excel makes it easy to have multiple workbooks open and to avoid getting lost in the maze. With ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.