Selecting Cells

Excel allows you to select cells in several different ways, using both the mouse and the keyboard. Selecting with a mouse by dragging…

Posted On

Line Chart

The line chart is used to show trends in data. It usually has more data points than a column or bar chart, because…

Posted On

Hyperlinks

A Hyperlink is a text, which references to a particular place. It is usually highlighted and underlined in a way that it can…

Posted On

Column Chart

The most popular chart in Excel is Column Chart. It is located at the top of the chart list. The data in the column…

Posted On

Variables

Because VBA is a programming language, it shares common principles and elements with other languages. One of them is variables. A variable is…

Posted On

Constants

If you need to use a value that never changes, it will be wise to use a constant instead of a variable. When…

Posted On

Loops

VBA, as well as other programming languages, offers loops. Looping is an operation of repeating the same block of code multiple times. Excel…

Posted On

Recover Files

Probably you’ve had to deal with a situation in which you forgot to save the file you have worked a long time. Maybe…

Posted On

Developer Tab

The Developer Tab is an additional, hidden tab that can be useful when you write VBA code, especially if you prefer to work…

Posted On

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