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

Excel VBA / Macros

How to Select Alternate Columns in Excel (or every Nth Column)

Select alternate columns in Excel

When dealing with databases in Excel, you might come across spreadsheets that have data organized in particular patterns. For example, census data usually consists of alternating columns of actual data …

Read more

How to Subtract Multiple Cells from One Cell in Excel

Formula to subtract columns from a cell

If you need to subtract a single value from a range of cells at the same time, there are multiple ways can do this in Excel. For example, suppose you …

Read more

How to Copy Multiple Sheets to a New Workbook in Excel

Check create a copy for new option as well

Using Excel for office work often requires copying sheets from one workbook to another. You might need to compile individual employee sales reports into a single workbook. Or, you might …

Read more

How to Delete a Sheet in Excel Using VBA

Deleting multiple sheets with specific text in it using VBA

Deleting worksheets in Excel is a fairly easy task. All you need to do is just right-click on the sheet’s name at the bottom of the Excel window and hit …

Read more

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

Select every other cell in a column in Excel

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

How to Remove Apostrophe in Excel (3 Easy Ways)

Remove Apostrophe in Excel using Text to Columns

You might have come across Excel documents created by someone else that contains the apostrophe symbol in front of text, numbers, or dates. You might have also noticed this happening …

Read more

How to Auto Format Formulas in Excel (3 Easy Ways)

Autoformat Formulas result after using conditional formatting

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 Unhide All Rows in Excel with VBA

Insert a new module

If you’re in the habit of hiding rows in Excel, you may also sometimes, have a need to unhide all rows in a worksheet in Excel. In this tutorial, I …

Read more

Using Application.EnableEvents in VBA in Excel (Explained with Examples)

Using Application.EnableEvents in VBA in Excel

Application.EnableEvents is a property in Excel VBA where you can specify whether you want events to take place when the VBA code is running or not. An event is usually …

Read more

How to Clear Contents in Excel without Deleting Formulas

Click on Clear All

Excel allows you to clear content in the worksheets selectively. So, you can clear the contents in all the cells except the ones that have formulas. This can be useful …

Read more

How to Delete a Comment in Excel (or Delete ALL Comments)

Click on Clear Commnents and Notes

Comments in Excel are great when you’re working with multiple people and need to tag a few cells with some important notes. And with comments, you can have multiple people …

Read more

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

Using formula to extract URL from a cell in Excel

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

Post navigation
Newer posts
← Previous Page1 … Page3 Page4

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

2022 © SpreadsheetPlanet.com Privacy Policy | Sitemap

DMCA.com Protection Status