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

How to Delete Filtered Rows in Excel (with and without VBA)

Dataset from which filtered rows have been deleted

Excel provides a wide range of functionality, a lot of which most users are not even aware of. One of its most fascinating features is the versatility of its Filters. …

Read more

How to Group and Ungroup Worksheets in Excel

Shift key to group the sheets

A few readers had shared their concerns about situations where some of their sheets seem to be stuck together. So, any changes they make to one sheet are also affecting …

Read more

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

Numbers with comma

Commas serve multiple purposes when working with spreadsheets. They make numbers more readable. For example, the number 1,452,346 is much clearer than the number 1452346. Commas also help delimit related …

Read more

How to Set the Default Font in Excel (Windows and Mac)

Excel options to change default font

Most spreadsheet software comes with a default font pre-selected. For example, Microsoft Excel worksheets always start with the Calibri font set at size 11. For Excel on a Mac, the …

Read more

How to Remove Dollar Sign in Excel (4 Easy Ways)

Dataset with dollar sign

When working with financial data, you will notice that currency values are automatically formatted by Excel to include a dollar sign. This might not be the currency symbol you want …

Read more

How to Remove Hyperlinks in Excel (Easy Step-by-Step)

Right-click and then Remove Hyperlinks

Working with a spreadsheet full of hyperlinks can be quite frustrating. Unless otherwise specified, Excel usually recognizes the formats of email addresses and URLs and automatically converts them to hyperlinks. …

Read more

How to Remove Leading Zeros in Excel (3 Easy Ways)

Removing one leading zero with IF formula

If you’re dealing with a spreadsheet that was not created by you, formatting hassles are quite likely. You might come across a list of phone numbers with leading zeros. It …

Read more

How to Find Merged Cells in Excel (2 Simple Ways)

Merged cells are highlighted

You might have encountered times where you find Excel not letting you perform certain operations on your data due to the presence of merged cells. Merged cells are often so …

Read more

How to Insert Square Root Symbol in Excel (5 Easy Ways)

Insert Square Root symbol using UNICHAR formula

Every software in the Microsoft Office package comes with its own purpose and application. Just like MS Word was built for word processing, MS Excel has been created to work …

Read more

How to Calculate Standard Error in Excel (Step-by-Step)

Standard Error Value from Data Analysis Toolpak

Most people use spreadsheets software such as Microsoft Excel to process their data and carry out their analysis tasks. When performing an analysis of data, a number of statistical metrics …

Read more

How to Highlight Every Other Row in Excel (Conditional Formatting & VBA)

Dataset where alternate cells have been highlighted

Working with rows after rows of data can sometimes get monotonous. Often times, it becomes difficult to differentiate one row from the other. The solution? Highlighting (or shading) alternate rows …

Read more

How to Filter as You Type in Excel (With and Without VBA)

Filter formula in cell E4

Excel has some powerful Filter options (with inbuilt filter, advanced filter, and now the FILTER function in Office 365). But none of these options actually filter as you type (i.e., …

Read more

Older posts
Newer posts
← Previous Page1 … Page21 Page22 Page23 Page24 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

2023 © SpreadsheetPlanet.com Privacy Policy | Sitemap

DMCA.com Protection Status