Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Filter Data Based on Date in Excel
  • How to create Checklist in Excel
  • Example of COUNTIFS with variable table column in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to sum a total in multiple Excel tables

References

  • How to use Excel INDIRECT Function
  • Merge tables with VLOOKUP in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • Count rows with at least n matching values
  • How to retrieve first match between two ranges in Excel

Data Validations

  • Excel Data validation unique values only
  • Excel Data validation only dates between
  • Excel Data validation no punctuation
  • Excel Data validation require unique number
  • Excel Data validation with conditional list

View Multiple Workbooks at The Same Time in Excel

by

If you want to view multiple Excel workbooks at the same time, execute the following steps.

1. First, open two or more workbooks.

2. On the View tab, in the Window group, click Arrange All.

3. Select the desired arrange setting. For example, click Horizontal.

4. Click OK.

5. On the View tab, in the Window group, click View Side by Side (by default, Synchronous Scrolling is activated), to scroll both workbooks at the same time.

Post navigation

Previous Post:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use IFS function in Excel
  • IF with wildcards in Excel
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function
  • XOR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Add workdays to date custom weekends in Excel
  • List holidays between two dates in Excel
  • How to get number of days, weeks, months or years between two dates in Excel
  • Convert Excel time to decimal hours in Excel
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Group times into 3 hour buckets in Excel
  • Calculate conditional mode with criteria in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • Running count group by n size in Excel

General

  • List worksheet index numbers in Excel
  • Find, Select, Replace and Go To Special in Excel
  • How to calculate percent sold in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Index and match on multiple columns in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning