To Learn Excel VBA, You Must Already Know Excel Really Well

Pretty much everyone who uses a computer know Microsoft Excel to some degree and most are aware of macros and VBA. However, the vast majority shy away from VBA assuming it to be the preserve of Excel gurus and professional programmers. Nothing could be further from the truth: having Excel VBA training is a natural progression for anyone who knows Excel well and want to take their knowledge to the next level.

Microsoft Excel Selection Techniques

In this article, we will look at Excel selection techniques which involve using the mouse in conjunction with the keyboard. One of the most useful is click followed by Shift-click. This is particularly useful for selecting large ranges of data since it allows you to simply click on two opposite corners of the rectangular range of cells which you want to highlight. To use this technique, first click in the top left cell of the range you want to highlight. Next, scroll to make the bottom right cell of the proposed range visible. Finally, hold down the Shift key and click on the bottom right cell. All the cells between the two cells that you have clicked on will now be highlighted.

Manipulating Cells In Excel 2007

Whenever new cells are inserted into a worksheet, existing data has to shift in order to make room to the newly inserted cells. When we are inserting entire rows or columns the direction in which data will be moved is predetermined. If we insert an entire column, existing data is shifted to the right. If we insert an entire row, any existing data is shifted down. However when we insert cells rather than entire rows or columns excel needs to ask us in which direction we want the existing data to be shifted: to the right or down.