Print preview

When you finish working on your project and you want to print it on paper, you can do it by opening the Backstage View in FILE…

Posted On

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…

Posted On

Cell borders

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

Posted On

Hide rows and columns

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

Posted On

Save files

In Excel, you can save your files in a few different ways: By Save and Save As buttons, which are located under the FILE tab. Using Share and Export buttons. By Ctrl + S keyboard…

Posted On

Fit text in a cell

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

Posted On

Conditional statements

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

Posted On

Objects in VBA

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

Posted On

Text orientation

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

Posted On