Quick Tips for Excel



Quick Tips for ExcelResizing Columns and Rows all at one timeTo Resize columns or Rows all at one time. You must click the area of the spreadsheet above Row 1 and to the left of Column A to highlight the entire Spreadsheet. Next, Place your cursor in between any 2 column letters and when it becomes a double-headed arrow. Double click the left mouse button. Now the columns will be resized to fit all information located in the cells. The same can be done for rows. Refering to cellsEvery cell is labeled by its Column Letter and Row Number. In the example to the right, the cell that is highlighted is known as cell B1. It is also shown in the Name Box. Using FormulasIn Excel, to do calculations, you must key in Formulas. Every Formula must begin with the equals sign. (=) **In the example to the left, if we needed to Add cells B2, B3, and B4, Then we would place one of the following formuals in cell B5.=10+20+30=B2+B3+B4All of the formulas above will give the correct answer. **In the example to the left, if we needed to Multiply cells B2 and B3, Then we would place one of the following formuals in cell B4.=10*20 =B2*B3Again, all of the formulas will give the correct answer. **In the example to the left, if we needed to Subtract cells B2 and B3 , Then we would place one of the following formuals in cell B4.=10-5=B2-B3Again, all of the formulas will give the correct answer. **In the example to the left, if we needed to divide cells B2 and B3 , Then we would place one of the following formuals in cell B4.=10/5=B2/B3Again, all of the formulas will give the correct answer. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download