How to View Two Excel Sheets side by side in single screen I Arrange All Option in ExcelHow to View Two Excel Sheets side by side in single screen I Arrange All Option in Excel

By | May 22, 2023
(Last Updated On: May 22, 2023)

How to View Two Excel Sheets side by side in single screen I Arrange All Option in Excel

This Video will answer following Questions

  1. What does the “Arrange All” option in Excel do?
  2. Where can I find the “Arrange All” button in Excel?
  3. What are the different arrangement options available when using “Arrange All”?
  4. How does the “Tiled” option arrange the open windows in Excel?
  5. How does the “Horizontal” option arrange the open windows in Excel?
  6. How does the “Vertical” option arrange the open windows in Excel?
  7. What is the purpose of the “Cascade” option in the “Arrange All” feature?
  8. Can I resize or adjust the windows after using the “Arrange All” option?
  9. How can the “Arrange All” option help me work with multiple workbooks or worksheets?
  10. Can I switch between different workbooks or worksheets easily after using the “Arrange All” option?

In Microsoft Excel, the “Arrange All” option allows you to view multiple open workbooks or worksheets simultaneously, making it easier to compare and analyze data across different files. This feature is particularly useful when you want to work on different parts of your data or reference information from one workbook to another. Here’s how you can use the “Arrange All” option in Excel:
  1. Open Microsoft Excel and ensure that you have multiple workbooks or worksheets that you want to arrange on your screen.
  2. Click on the “View” tab located in the Excel ribbon at the top of the window.
  3. In the “Window” group of options, you will find the “Arrange All” button. Click on it.
  4. A dialog box will appear with several arrangement options. You can choose from the following:
    • “Tiled”: This option arranges the open windows in a grid pattern, ensuring that each workbook or worksheet is visible and shares an equal amount of space on your screen.
    • “Horizontal”: This option arranges the open windows side by side in a horizontal manner. Each workbook or worksheet will be stacked horizontally, allowing you to easily compare data between them.
    • “Vertical”: Similar to the “Horizontal” option, this choice arranges the open windows vertically. Each workbook or worksheet will be stacked vertically for convenient data comparison.
    • “Cascade”: This option cascades the open windows, with each workbook or worksheet appearing slightly offset from the others. The title bars of the windows will be visible, allowing you to easily switch between them.
  5. Select the desired arrangement option by clicking on it, and then click the “OK” button.

Excel will then rearrange the open workbooks or worksheets on your screen based on your chosen option. You can resize, maximize, or minimize each window as needed. This feature helps you multitask and work efficiently with multiple datasets simultaneously.

Remember, the “Arrange All” option in Excel is designed to enhance your productivity by providing a clear view of multiple workbooks or worksheets. It enables you to compare, analyze, and perform operations across different files with ease.

arrange all in excel,arrange all,microsoft excel,excel,ms excel,arrange all option in excel,excel arrange all,arrange all option in excelin telugu,ms excel in hindi,how to arrange all in excel,arrange all cascade in excel,arrange all command in excel,how to use arrange all in excel,arrange all option,excel tutorial,arrange all windows,arrange all excel,how to use arrange all in excel tutorial,sorting in excel excel view two sheets side by side,microsoft excel,view sheets side by side,excel,two excel sheets side by side,view excel sheets side by side,view sheets side by side excel,view sheets side by side excel mac,how to view two excel sheets side by side,compare two sheets in excel,how to view two separate excel sheets side by side,compare two excel sheets, #exceltips,excel view multiple sheets,excel view side by side,two excel files side by side