Skip to content
Spreadsheet Planet Logo
  • About
  • Excel Tips
  • Formulas
  • VBA / Macros
Menu
  • About
  • Excel Tips
  • Formulas
  • VBA / Macros
Search
Close

Excel Tips Articles

Compare-two-columns-and-highlight-matching-cells

How to Compare Two Columns in Excel (using VLOOKUP & IF)

Click here to Read More »

How to Remove Formulas in Excel (and keep the data)

Click here to Read More »
Excel-if-statement-multiple-condition

Multiple If Statements in Excel (Nested Ifs, AND/OR) with Examples

Click here to Read More »
Substitute-formula-to-remove-dashes-hyphens-in-Excel

How to Remove Dashes (-) in Excel?

Click here to Read More »
Cell-referneces-with-two-dollar-signs-absolute-references

What does $ (dollar sign) mean in Excel Formulas?

Click here to Read More »
Excel-If-And-statement

How to use Excel If Statement with Multiple Conditions Range [AND/OR]

Click here to Read More »
Dataset with day names and X in row 8

How to Hide Columns Based on Cell Value in Excel

Click here to Read More »
Formatting shows up as custom format

How to Flash an Excel Cell (Easy Step-by-Step Method)

Click here to Read More »
Print preview with row and column numbers

How to Print Row Numbers in Excel (3 Easy Ways)

Click here to Read More »
Shrink to fit

Why are Dates Shown as Hashtags in Excel? Easy Fix!

Click here to Read More »
Dataset where selected selection need to be saved as PDF

How to Save Selection in Excel as PDF (3 Easy Methods)

Click here to Read More »
Dataset with merged cells

Why is Merge and Center Grayed Out?

Click here to Read More »
« Previous Page1 Page2 Page3 Page4 Page5 Next »

2021 © Spreadsheet Planet
Privacy Policy | Sitemap

DMCA.com Protection Status