#Microsoft excel versions how to#
#Microsoft excel versions download#

If you include a $ sign, that tells Excel not to move the formula. So, we have our desired cells highlighted and now we click on the “Home” section/group and then “Conditional Formatting.” Otherwise, the other cells (like headings) will also be evaluated and you would be surprised what Excel does with those headings (as an example). You only want to highlight just the cells that you want evaluated.

Now, keep in mind, you do not want to highlight the entire column or row. In order to do this, we first have to highlight the group of cells that we want evaluated. In this example, we are going to use our Excel Example file (with all of the financial data) and look for the “Gross Sales” that are over $25,000. If it seems a little complicated or you are looking for functions and formulas, skip this section and come back to it at your leisure.Ĭonditional Formatting is handy if you want to highlight certain data. This part of the article is included in the section on creating the Workbook because of its display benefits. You can try this by using the right-click on the tab and choosing “Duplicate.” Conditional Formatting What I did was duplicate the tab with all of the financial data (after copying it into my other example file, the one we started with that was blank) and with the duplicate tab I had two versions to play with at will. Rename the file you downloaded and re-download another copy. You can also duplicate your Excel example file if you want to retain the original form. Go ahead and try some other buttons that you see on the Ribbon and see what they do. These are especially helpful when dealing with larger data sets. Then, the second part of our procedure is to click on Delete Rows and watch Excel delete those rows. In this case, we are selecting three rows. Go ahead and click on the row number (to the left of the top left cell) and drag downward with your mouse to the bottom row that you want to delete. Remember our first step? We need to select the rows. 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.

#Microsoft excel versions how to#

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.

#Microsoft excel versions download#

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.