#Basic microsoft excel 2007 tutorial pdf how to#

If a row of hashtag symbols appear in cell C2 instead of the date after adding the TODAY function to that cell, it is because the cell is not wide enough to display the formatted data.Р В РІР‚СњР В РІР‚С›s mentioned previously, unformatted numbers or text data spill over to empty cells to the right if it is too wide for the cell.

The current date should be added to cell C2.

Click Done in the box to enter the function and return to the worksheet.

Click on the Today function to bring up the Formula Builder.

Click on the Date & Time option on the ribbon to open the list of date functions.

Click on the Formulas tab of the ribbon.

Click on cell C2 to make it the active cell.

The steps below will add the TODAY function to cell C2 of the worksheet. The TODAY function is also one of Excel's volatile functions, which means it updates itself every time the recalculates Р В Р вЂ Р В РІР‚С™Р Р†Р вЂљРЎС™ which is usually ever time the worksheet is opened. The TODAY function is easy to use because it has no arguments Р В Р вЂ Р В РІР‚С™Р Р†Р вЂљРЎС™ which is data that needs to be supplied to the function in order for it to work. Functions are just built-in formulas in Excel to make it easy to complete commonly performed tasks Р В Р вЂ Р В РІР‚С™Р Р†Р вЂљРЎС™ such as adding the date to a worksheet. Excel has a number of date functions that make it easy to enter the date into a worksheet. It is normal to add the date to a spreadsheet - quite often to indicate when the sheet was last updated. Alternatively, Excel has a feature called merge and center which will be used in a later step to quickly center the title over the data table.

Since the worksheet title is so long compared to the other labels in column A, if that column was widened to display the entire title in cell A1, the worksheet would not only look odd, but it would make it difficult to use the worksheet because of the gaps between the labels on the left and the other columns of data.Р В РІР‚СњР В РІР‚С›s there are no other entries in row 1, it is not incorrect to just leave the title as it Р В Р вЂ Р В РІР‚С™Р Р†Р вЂљРЎС™Р В РІР‚в„ўР вЂ™Р’В spilling over into the cells to the right. Widen other columns to show data as needed.Click and hold down the left mouse button and drag the double-headed arrow to the right to widen column A until the entire entry Thompson A.The pointer will change to a double-headed arrow.

Place the mouse pointer on the line between columns A and B in the column header.

#Basic microsoft excel 2007 tutorial pdf how to#

The steps below cover how to widen columns using the mouse. As with all Microsoft programs, there are multiple ways of widening columns. To correct this problem so that the data is fully visible, the columns containing that data need to be widened. entered into cell A8 are truncated because the cells to the right contain data. Several cells of data entered in the previous step, such as the label Deduction Rate: entered into cell B3 and Thompson A. If the cell to the right contains data, however, the contents of the first cell are truncated to the first eight characters. If the cell or cells to the right are blank, the entered data is displayed in the worksheet, as seen with the worksheet title Deduction Calculations for Employees entered into cell A1. By default, the width of a cell permits only eight characters of any data entry to be displayed before that data spills over into the next cell to the right.