AutoFill in Excel
AutoFill is a very useful Excel feature. It allows you to create entire columns or rows of data that are based on the…
Tag: pinterest
Trendlines in Excel
One of the easiest methods for guessing a general trend in your data is to add a trendline to a chart. The Trendline…
Remove Leading Zeros in Excel
When you have to work with a spreadsheet that you didn’t create, sometimes you may encounter poorly formatted data or formatting errors. For…
Relative, Absolute and Mixed Cell References in Excel
When you open an Excel spreadsheet, the first thing you see are cells. You can enter a value into a cell, or use…
Opposite of Concatenate in Excel
The CONCATENATE function is used in Excel to merge several strings into one. Let’s suppose that you want to reverse the process and change the “JohnDoe45” to “John”, “Doe” and “45”….
Deleting a Row With VBA
In Excel, you can delete a row by right-clicking on the number of the row and then selecting Delete. But when you want…