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

Excel VBA / Macros

How to Select Rows with Specific Text in Excel

Rows with specific text selected

When you are working with large amounts of data in spreadsheets, you need all the tips and tricks you can get to quickly access your required data. Oftentimes you might …

Read more

How to Extract Number from Text in Excel (Beginning, End, or Middle)

Extracting numbers from a list of cells with mixed text is a common data cleaning task. Unfortunately, there is no direct menu or function created in Excel to help us …

Read more

How to Find out What Version of Excel You Have (Easy Way)

About Microsoft Excel dialog box

Every version of Excel brings with it new features while making some older features obsolete. As such, we often need to know exactly which version of Excel we are using, …

Read more

How to Hide Rows based on Cell Value in Excel (2 Easy Methods)

Type the value in the cell based on which you want to hide

Working with large datasets that contain rows after rows of data can be quite painful. In such cases, looking for data that match particular criteria can be like looking for …

Read more

3 Easy Ways to Duplicate Sheet in Excel (Shortcuts + VBA)

Select the Move or copy option

Working with spreadsheets often involves a lot of repetitive tasks. A common way that spreadsheet users save time and energy is by making copies of spreadsheets already created and using …

Read more

10 Best Excel Books (that will make you an Excel Pro)

When we talk about learning Excel, we almost always think of videos and written tutorials. While these are great ways to learn Excel, you can also consider using Excel books …

Read more

How to Hide Columns Based on Cell Value in Excel

Dataset with day names and X in row 8

Excel provides features such as filters that let you hide rows based on cell values. However, if you want to hide columns based on cell values, there’s, unfortunately, no dedicated …

Read more

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

Formatting shows up as custom format

There are a variety of ways in Excel to let you highlight or draw attention to important information in your worksheet. You can use highlights, make the font bolder, change …

Read more

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

Dataset where selected selection need to be saved as PDF

Excel has some great features that make it really easy to export workbooks, worksheets, and even parts of a worksheet to a number of other formats. Some of these formats …

Read more

How to Sum Positive Numbers in Excel – Easy Formula

SUMIF formula to add only positive numbers

For someone fairly comfortable with Excel, summing up a list of cells is as easy as pie. But when it comes to summing up cells based on a particular condition, …

Read more

How to Count Negative Numbers in Excel – Easy Formula

COUNTIF Function to count negative numbers in a range

Counting cells in a range of data is fairly easy, even if you are a beginner at Excel. But when it comes to counting only the cells that contain a …

Read more

How to Remove Macros from Excel? 3 Simple Methods

Macro dialog box empty after deleting all macros

Macros provide a great way to automate repetitive tasks. In this way, they help get things done quickly, but there may be times when you want to remove macros from …

Read more

Post navigation
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 Next →

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