Office
 

Getting Started with Microsoft Excel 2010 : Arranging Windows

10/8/2011 3:47:41 PM
Every Office program and workbook opens inside a window, which contains a title bar, Ribbon, and work area, which is where you create and edit your data. Most often, you’ll probably fill the entire screen with one window. But when you want to move or copy information between programs or documents, it’s easier to display several windows at once. You can arrange two or more windows from one program or from different programs on the screen at the same time. However, you must make the window active to work in it. You can also click the document buttons on the taskbar to switch between open documents.

Resize and Move a Window

  • Maximize button. Click to make a window fill the entire screen.

  • Restore Down button. Click to reduce a maximized window to a reduced size.

  • Minimize button. Click to shrink a window to a taskbar button. To restore the window to its previous size, click the taskbar button.

  • Close button. Click to shut a window.

Resize and Move a Window Using a Mouse

If the window is maximized, click the Restore Down button.

Use the following methods:

  • Move. Move the mouse over the title bar.

  • Resize. Move the mouse over one of the borders of the window until the mouse pointer changes into a two-headed arrow. The directions of the arrowheads show you the directions in which you can resize the window.

Drag to move or resize the window.

Arrange or Switch Between Windows

Open the workbooks you want to arrange or switch between.

Click the View tab.

In the Window group, perform any of the following:

  • Click Switch Windows, and then click the workbook name you want.

  • Click Arrange, click an arrange window option (Tiled, Horizontal, Vertical, or Cascade), and then click OK.

  • Click New Window to open a new window containing a view of the current workbook.

Compare Windows Side By Side

Open the workbooks you want to arrange or switch between.

Click the View tab.

In the Window group, perform any of the following:

  • Click the View Side By Side button to compare two worksheets vertically.

  • Click the Synchronous Scrolling button to synchronize the scrolling of two documents so that they scroll together. To enable this feature turn on View Side By Side.

  • Click the Reset Window Position button to reset the window position of the documents being compared side-by-side so that they share the screen equally. To enable this feature turn on View Side By Side.

 
Others
 
- Getting Started with Microsoft Excel 2010 : Moving Around the Workbook
- Microsoft Outlook 2010 : Working with the Ribbon and the Backstage View
- Microsoft Outlook 2010 : Working in the Outlook Program Window
- Microsoft OneOnte 2010 : Creating Pages - Choose the Default Page Template for Section Pages
- Microsoft OneOnte 2010 : Creating Sections & Creating Section Groups
- Facilitating Your Plan with Microsoft Project 2010
- Microsoft Project 2010 : Understanding Project Management Basics
- Microsoft Access 2010 : Working with Table Data
- Microsoft Access 2010 : Working with an Existing Database
- Microsoft Visio 2010 : Sharing and Publishing Diagrams - Saving in Other File Formats
- Microsoft Visio 2010 : Sharing and Publishing Diagrams - Creating Graphics
- Microsoft Word 2010 : Customizing Word - Setting Editing Options
- Microsoft Word 2010 : Customizing Word - Setting Print Options
- Microsoft PowerPoint 2010 : Presenting a Slide Show - Annotating a Slide Show
- Microsoft PowerPoint 2010 : Presenting a Slide Show - Navigating a Slide Show
- Getting Started with Microsoft Excel 2010 : Converting an Existing Workbook & Using Task and Window Panes
- Getting Started with Microsoft Excel 2010 : Creating a Workbook Using a Template & Opening an Existing Workbook
- Get Started with Outlook 2010 : Troubleshooting Connection Problems
- Get Started with Outlook 2010 : Connecting to E-Mail Accounts
- Microsoft Access 2010 : A Preview of the Database Components (part 2)
 
 
Most View
 
- System Center Configuration Manager 2007 : Distributing Packages - Creating Advertisements (part 2) - OpsMgr Advertisement - Additional Advertisement Settings
- Windows Server 2008 R2 Remote Desktop Services : Installing and Configuring Remote Desktop Services (part 4)
- Microsoft Project 2010 : Setting Up Project for Your Use - Defining Project Information (part 1) - Understanding the Project Information Dialog Box
- SQL Server 2012 : Fault Tolerance - Configuring an AlwaysOn Availability Group (part 2) - Configuring the SQL Server Instance
- Windows 7 : Working with Files - Change the File View, Preview a File
- Developing, Integrating, and Building Applications in Sharepoint 2013 (part 2) - User Interface Integration - App Parts and Pages
- SQL Server 2012 : Delivering A SQL Server Health Check (part 11)
- Windows 7 : Working with Files - Create a New File
- Microsoft Project 2010 : Maintaining Baselines (part 1) - Clearing a Baseline
- Windows 8 : Getting Around the Windows Desktop - Using the Notification Area (part 2) - Using scroll bars, Using Back and Forward buttons
 
 
Top 10
 
- Microsoft Sharepoint 2013 : Administering Sharepoint with Windows Powershell - Basic PowerShell Usage (part 3) - Controlling Output
- Microsoft Sharepoint 2013 : Administering Sharepoint with Windows Powershell - Basic PowerShell Usage (part 2) - PowerShell Help , PowerShell Variables
- Microsoft Sharepoint 2013 : Administering Sharepoint with Windows Powershell - Basic PowerShell Usage (part 1) - Listing the SharePoint Commands
- Microsoft Sharepoint 2013 : Administering Sharepoint with Windows Powershell - Commands
- Microsoft Sharepoint 2013 : Microsoft SharePoint 2013 Management Shell and Other Hosts
- Microsoft Word 2010 : Using Advanced Text Features - Addressing Envelopes
- Microsoft Word 2010 : Using WordArt (part 2) - Changing the Format of a WordArt Object
- Microsoft Word 2010 : Using WordArt (part 1) - Inserting WordArt Text
- Microsoft Word 2010 : Creating and Formatting Text Boxes (part 3) - Formatting Text in a Text Box, Linking Text Boxes
- Microsoft Word 2010 : Creating and Formatting Text Boxes (part 2) - Resizing a Text Box , Moving a Text Box