training Archives | Page 3 of 8

Delete Rows and Columns

Excel allows you to delete rows and columns which you don’t want to be present inside the worksheet. You can delete them by…

Besides changing the font and color of cells, you can also distinguish them by using cell borders. In order to add borders, go…

In some cases, you may want to hide some rows or columns. For example, those that are used only for calculations, and there…

In Excel, you can save your files in a few different ways: If you try to close Excel, but you haven’t saved your…

If you want to change the look of the worksheet, you can do it in a very simple way- by changing the type,…

If the text you entered in the cell is too long to display it in its entirety, Excel will display only a part…

If you want your procedure to behave differently depending on the conditions it meets you have to use one of the conditional statements….

Object-Oriented Programming (OOP for short) is based on the idea that everything in programming can be described as an object. These objects are…

Besides horizontal text orientation, you can also display text vertically or at an angle. You can change the orientation of the text go…

When you write VBA code you can use a subroutine (sub for short) or a function. The generic name for both is a…