Remember the data we copied from this article and pasted into our blank Excel sheet in the above example? We probably don’t need it anymore so it is a perfect example for the process of deleting rows. The first part is the selection process and the other is the right-click and choosing the insert or delete option. There are two parts to adding or deleting rows or columns. Fortunately, once you get the hang of it, it is fairly easy to do. It is helpful to know how to work with, as well as adjust the width and dimensions of, columns and rows. The alignment is very similar to what you would see in a word processing application. top, bottom) in the Ribbon.Īlso, if you notice, aligning things like numbers may not look right when aligned left (where text looks better) but does look better when aligned right. You can also choose other alignment options (i.e. right, left, etc.) is on the second row of the Ribbon option. A little later we will also download another sample Excel sheet.Īs you can see from the images above, the alignment of the text (i.e. The interface will vary, from version to version, but should be similar enough to get the idea. So go ahead and select the blank document option. For our article, we are starting with a blank document and playing around with data and formulas, etc. One way of learning how to use Excel is to play with those templates and see what makes them “tick”.

The templates themselves may vary between versions of Excel, but you should get some sort of selection. When you click on New you are more than likely going to get some example templates. Note: The above image says Open at the top to illustrate that you can get to the New (left-hand side, pointed to with the green arrow) from anywhere.

This may vary, depending on your version of Excel, but is generally in the File area. It is helpful to start with a blank Workbook. We will give you some example steps as we go along in this article so you can try them out for yourself. There are many things you can do with your Excel Worksheet. Creating & Formatting a Worksheet Example When we reference the formula bar, we are simply indicating that we should type the formula in that spot while having the appropriate cell selected (which, again, will automatically happen if you select the cell and start typing). You enter the data in the cell and it will also appear in the formula bar if you have your mouse on that cell. The formula bar is an area that appears below the Ribbon.

Basics of microsoft excel 2007