video tutorial for excel 2013 free download

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.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.

Video tutorial for excel 2013 free download