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

Lookup and Reference Examples

  • How to get relative column numbers in a range in Excel
  • Two-way lookup with VLOOKUP in Excel
  • How to use Excel ROWS Function
  • How to use Excel OFFSET function
  • Two-column Lookup in Excel

Data Analysis Examples

  • Chart Axes in Excel
  • How To Compare Two Lists in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • Number and Text Filters Examples in Excel

Data Validation Examples

  • Excel Data validation allow uppercase only
  • Excel Data validation date in specific year
  • Excel Data validation only dates between
  • Excel Data validation date in next 30 days
  • Excel Data validation with conditional list

Tag: Find & Select

How to Copy Visible Cells Only in Excel

by

By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only. In this example, row 2 is hidden. When you copy/paste this range, this is the result: To copy visible cells only, execute the following easy steps. 1. Select the range A1:A4. 2. On the Home tab, in the Editing group, …

Continue Reading

Advanced Find Features in Excel

by

This chapter teaches how to incorporate special characters with find option. A question mark (?) matches exactly one character. For example, F?rrari will find Ferrari, Forrari, Farrari, etc. An asterisk (*) matches a series of zero or more characters. For example, F*rrari will find Ferrari, Foorrari, Faaaaaarrari, etc. To access some more advanced find features in Excel, execute the …

Continue Reading

Delete Blank Rows at Once in Excel

by

When you have empty rows cluttering your spreadsheet and you need to tighten it up, easy and fast? Removing blank rows is the first thing you should do! This example teaches you how to delete blank rows or rows that contain blank cells. 1. On the Home tab, in the Editing group, click Find & Select. 2. …

Continue Reading

Quickly Highlight Cells Containing Different Content in a Row

by

This example teaches you how to quickly highlight cells whose contents are different from the comparison cell in each row. 1. To select the range A1:C15, click on cell A1 and drag it to cell C15. Note: because we selected the range A1:C15 by clicking on cell A1 first, cell A1 is the active cell …

Continue Reading

Find, Select, Replace and Go To Special in Excel

by

Detailed steps on how to use Excel Find, Select, Replace & Go To Features You can use Excel’s Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel’s Go To Special feature to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, etc. Find To quickly find …

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
  • Split numbers from units of measure in Excel
  • CONCATENATE function: Description, Usage, Syntax, Examples and Explanation
  • Convert text to numbers using VALUE function in Excel
  • How to strip non-numeric characters in Excel
  • Join first and last name — Manipulating NAMES in Excel
  • Calculate days remaining in Excel
  • Get last weekday in month in Excel
  • Display the current date and time in Excel
  • Get week number from date in Excel
  • Sum race time splits in Excel
  • YIELDDISC function: Description, Usage, Syntax, Examples and Explanation
  • Future value vs. Present value examples in Excel
  • YIELDMAT function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
  • Bond valuation example in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles