Excel Blog - Latest Excel tips, tutorials, and videos.

0 How to Delete Every Other Row in Excel (or Every Nth Row)

Click on the filter icon the helper column header

Sometimes you may have a need to delete every other row (i.e., alternate rows), or every third/fourth/fifth row in Excel. One use-case of this could be when you have weekly data and you only want the data for even weeks or odd weeks. Another could be when you get a data dump from a database […]

0 How to Wrap Text in Excel (with shortcut, One Click, and a Formula)

Address in cells that needs to be wrapped

When you enter a text string in Excel which exceeds the width of the cell, you can see the text overflowing to the adjacent cell(s). Below is an example where I have some address in column A and these address overflow to the adjacent cells as well. And in case you have some text in […]

2 Delete Rows Based on a Cell Value (or Condition) in Excel [Easy Guide]

Delete Rows of Mid-West by selecting the entire group

When working with large data sets, you may have the need to quickly delete rows based on the cell values in it (or based on a condition). For example, consider the following examples: You have sales rep data and you want to delete all the records for a specific region or product. You want to […]

3 How to Automatically Open Specific Excel File on Startup

Excel Startup Screen you see when you start it

Want some Excel files to open automatically when you start Excel? These could be files the that you open every day in the morning (such as tracking sheet or timesheet), or some project related files that you need to open as soon as you start Excel. While you always have the option to open these […]

1 How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)

Sorting data in Excel has been made quite easy with all the in-built options. You can easily sort your data alphabetically, based on the value in the cells, or by cell and font color. You can also do multi-level column sorting (i.e., sorting by column A and then by column B) as well as sorting […]

5 How to Make a PIE Chart in Excel (Easy Step-by-Step Guide)

Excel has a variety of in-built charts that can be used to visualize data. And creating these charts in Excel only takes a few clicks. Among all these Excel chart types, there has been one that has been a subject of a lot of debate over time. …the PIE chart (no points for guessing). Pie […]

4 Count Distinct Values in Excel Pivot Table (Easy Step-by-Step Guide)

Distinct Count Helper Column in Pivot Table Data

Excel Pivot Tables are amazing (I know I mention this every time I write about Pivot Tables, but it’s true). With a basic understanding and a little drag and drop, you can get a bucket-load of work done in a few seconds. While a lot can be done with a few clicks in Pivot Tables, […]

1 2 3 … 52 Next »