

Category Archives for "Excel Tips"

0 How to Remove Time from Date/Timestamp in Excel (4 Easy Ways)

Excel allows you to display data in many different formats. And there are way too many to choose from when it comes to dates and time data in Excel. And since there are so many formats, there are also ways to edit and modify these. One common thing many people need to do often in […]

0 How to Assign a Macro to a Button in Excel (Easy Guide)

While there are many different ways to run a macro in Excel, none of those methods can be as easy and user-friendly as clicking on a button. And for that to work, you need to assign a macro to a button first. In this tutorial, I will show you a couple of ways to insert […]

5 How to Remove the First Character from a String in Excel (Quick & Easy)

Manually Enter the second value in the second adjacent cell

Working with text data would often require slicing and dicing it. And one such common thing people often have to do is to remove the first characters from a string in Excel. Suppose you have a dataset as shown below (in column A) and you want to remove only the first characters from each cell […]

0 How to Reference Another Sheet or Workbook in Excel (with Examples)

Create a new named range by specifying the name

To be able to reference cells and ranges is what makes any spreadsheet tool work. And Excel is the best and most powerful one out there. In this tutorial, I will cover all that you need to know about how to reference cells and ranges in Excel. Apart from the basic referencing on the same […]

0 Split Each Excel Sheet Into Separate Files (Step-by-Step)

Files after each sheet is split into separate file

Watch Video – How to Split Each Excel Sheet Into Separate Files If you have an Excel workbook with many worksheets, there is no easy way to split each of these sheets into separate Excel files and save separately. This could be needed when you sheets for different months or regions or products/clients and you […]

0 How to Sum a Column in Excel (5 Really Easy Ways)

To get the sum of an entire column is something most of us have to do quite often. For example, if you have the sales data to date, you may want to quickly know the total sum in the column to the sales value till the present day. You may want to quickly see what […]

0 Insert a Blank Row after Every Row in Excel (or Every Nth Row)

Final Dataset where blank rows have been inserted after each row

Watch Video – Insert Blank Row After Every Row in Excel People who work with large data sets often need simple things such as inserting/deleting rows or columns. While there are already many different (and simple) ways to add rows in Excel, when it comes to inserting a blank row after every other row (or […]

« Previous 1 2 3 4 … 37 Next »