Skip to content
Spreadsheet Planet
  • About
  • Excel Tips
  • Formulas
  • Charts
  • VBA / Macros
  • Shortcuts

Formulas

How to Select Every Other Cell in Excel (Or Every Nth Cell)

How to Select Every Other Cell in Excel (Or Every Nth Cell)

If you’ve ever tried selecting alternate cells or cells in a particular pattern in Excel, you would know that this is not as easy as it seems. Well, if it …

Read more

SUMPRODUCT vs SUMIFS Function in Excel

SUMPRODUCT vs SUMIFS Function in Excel

The SUMPRODUCT function was always the go-to function for finding conditional sums, till the time SUMIFS was introduced in Excel 2007. A lot of people shifted to using SUMIFS instead …

Read more

How to Auto Format Formulas in Excel?

How to Auto Format Formulas in Excel?

When working with formulas, there is always a possibility that someone (or even you) may delete a cell (or clear the contents of a cell/range) that has formulas in it. …

Read more

How to Extract URL from Hyperlinks in Excel (Using VBA Formula)

How to Extract URL from Hyperlinks in Excel (Using VBA Formula)

If you work with data copied from the web into Excel, you would often get a dataset that has hyperlinks in it. For example, below is an example dataset where …

Read more

Newer posts
← Previous Page1 … Page9 Page10

Most Popular Articles

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

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

How to Remove Dashes (-) in Excel?

How to Center the Worksheet Horizontally on the Page in Excel

How to Merge First and Last Name in Excel

How to Remove Commas in Excel (from Numbers or Text String)

Why does Excel Open on Startup (and How to Stop it)

How to Remove Apostrophe in Excel

How to Unsort in Excel (Revert Back to Original Data)
SpreadsheetPlanet.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

2023 © SpreadsheetPlanet.com Privacy Policy | Sitemap

DMCA.com Protection Status