Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get last row in mixed data with blanks in Excel
  • Convert text string to valid reference in Excel using Indirect function
  • Two-way lookup with VLOOKUP in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel COLUMN Function

Data Analysis Examples

  • Working With Tables in Excel
  • How to Sort by Color in Excel
  • Get column index in Excel Table
  • Everything about Charts in Excel
  • How to Create Column Chart in Excel

Data Validation Examples

  • Excel Data validation must not contain
  • Excel Data validation must begin with
  • Excel Data validation allow uppercase only
  • Excel Data validation unique values only
  • Data validation must not exist in list

Tag: View Tab

Excel Workbook Views

by

Excel offers three workbooks views, Normal, Page Layout and Page Break Preview. Normal At any time, you can switch back to Normal view. 1. On the View tab, in the Workbook Views group, click Normal. Result: Note: if you switch to another view and return to Normal view, Excel displays page breaks. Close and reopen the Excel file to hide …

Continue Reading

Freeze and Unfreeze Panes in Excel

by

If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet. Freeze Top Row To freeze the top row, execute the following steps. 1. On the View tab, in the Window group, click …

Continue Reading

Split Worksheet Window in Excel

by

To view multiple distant parts on worksheet at once, you will need to split your worksheet. To split your worksheet (window) into an upper and lower part (pane), execute the following steps. 1. First, select a cell in column A. 2. On the View tab, in the Window group, click Split. 3. Notice the two vertical scroll …

Continue Reading

Things you find in Excel Status Bar

by

The quickest way to see the average, count, numerical count, minimum, maximum or sum of selected cells is by taking a look at the status bar. 1. Select a range of cells. 2. Look at the status bar at the bottom of your window to see the sum of these cells. 3. Right click the status …

Continue Reading

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, …

Continue Reading

Zoom Worksheet in Excel

by

Use the buttons on the View tab to zoom to a specific percentage and to zoom to a selection. In most cases, you can use the minus and plus symbols in the status bar to quickly zoom the document. 1. To quickly zoom the document, use the minus and plus symbols in the status bar. To zoom …

Continue Reading

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
  • EXACT function: Description, Usage, Syntax, Examples and Explanation
  • How to extract substring in Excel
  • How to count specific characters in a cell in Excel
  • Normalize text by removing punctuations, extra spaces and more in Excel
  • REPT function: Description, Usage, Syntax, Examples and Explanation
  • How to Calculate Age in Excel
  • Count dates in current month in Excel
  • How to calculate future date say 6 months ahead in Excel
  • How to enter Today’s Date or Static Date and Time in Excel
  • How to join date and text together in Excel
  • Calculate original loan amount in Excel
  • COUPDAYSNC function: Description, Usage, Syntax, Examples and Explanation
  • PDURATION function: Description, Usage, Syntax, Examples and Explanation
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • YIELDMAT function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles