Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Removing Borders

Converting to Octal

Filtering Columns for Unique Values

Printing Multiple Worksheets on a Single Page

Changing the Default Font

Creating a Drawing Object

Determining a Value of a Cell

 

Arranging Workbook Windows

Summary: Got a lot of workbook windows you want to arrange? It's easy to do if you start by using the Arrange or Arrange Windows dialog boxes. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

If you have more than one workbook open at a time, Excel allows you to view all the workbooks at the same time, and to arrange each workbook window as you desire. The easiest method of arranging workbook windows is as follows, if you are using a version of Excel prior to Excel 2007:

  1. Choose Arrange from the Window menu. This displays the Arrange dialog box. (Click here to see a related figure.)
  2. The Tiled option should be selected. Click on OK. This divides the screen space evenly between all your workbooks. The main benefit is that each workbook gets at least a piece of the screen.
  3. Click on the window whose size you wish to adjust. It becomes active.
  4. Move the mouse cursor near the border of the active window. When the cursor turns into a set of arrows, click the mouse button and drag the window edge to the desired size. Release the mouse button.
  5. Repeat steps 3 and 4 for each window you want to adjust.

If you are using Excel 2007, follow these steps instead:

  1. Display the View tab of the ribbon.
  2. In the Window group click the Arrange All tool. Excel displays the Arrange Windows dialog box.
  3. The Tiled option should be selected. Click on OK. This divides the screen space evenly between all your workbooks. The main benefit is that each workbook gets at least a piece of the screen.
  4. Click on the window whose size you wish to adjust. It becomes active.
  5. Move the mouse cursor near the border of the active window. When the cursor turns into a set of arrows, click the mouse button and drag the window edge to the desired size. Release the mouse button.
  6. Repeat steps 4 and 5 for each window you want to adjust.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2738) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.
 
Check out Timesheet Templates today!