Page 59 - TP_Prime_v2.2_Class_5
P. 59
Step 4: A Format Cells dialog box appears. Select Date option in the Category
section. A list of formats is displayed.
2
3
Soft Hint INTRODUCTION TO EXCEL 2016
1 4
To apply the default
5 time and date format:
Ctrl +
Shift + # or
Ctrl + Shift + @
6 57
Step 5: Choose the format you want.
Step 6: Click OK button.
You can see a preview of the active cell in the Sample box with the format
you have selected.
Changing Cell Contents
When you enter the data in a cell, you can change it. The process of changing the
data either partially or completely is known as editing. Cell contents can be edited in
two ways.
1. Replacing cell contents
2. Using the formula bar
Replacing Cell Contents
You can replace the contents of a cell by the following steps:
Step 1: Go to that cell or click on it to make it the active cell.
Step 2: Start typing the new data. The previous data will be automatically replaced
by the new data.

