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…
Author: Tomasz Decker
Spreadsheet and Python enthusiast.
Opposite of Concatenate
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…
Selecting rows and columns
In the previous lesson, I presented a few ways to select cells and ranges. This time, I will show you a few methods…
