Enter And Edit Data

The various kinds of entries that can be made in a cell are :

Text- First select the cell in which the data has to be entered and type - in the text.

Press Enter Key to finish your entry . The data will be displayed in the active cell  as well as in the formula Bar . To enter digits as text ( calculations cannot be done using these kind of entries ) use an apostrophe(') as the first character .

Number -Numbers include digits from 0 to 9 and some special characters like:
$ % + - / ( ) , . E e

Date and Time -Date and Time entries are interpreted in a special way in Excel. They are represented as numbers for Excel given to each day from 01.01.1900 ( Serial number 1 ) to 31.12.2078 (serial number 65380 ).
Although when you type a date in the cell like 01/01/2022, It will be displayed as it is.

Example: Ty[e TODAY ( ) in a blank cell and press Enter Key .( This function will display the system date and time ).

Data in Series - You con fill a range of cells either with the same value or with the series of values .
This can be done using Autofill handle ( Small square on the bottom -right corner of the active cell drag this handle till the last cell to create a range of cells which are to be filled -in with the values . 

Example:

1- Enter MONDAY in cell E20.
2-Drag the Autofill handle till the cell k 20.

(The whole range will be filled with days from MONDAY to SUNDAY.)

To create a series of numbers 

Example :Select the cell H20 and enter 1 in it .

Select the range from H20 to H11.

Though Excel provides the facility of built -in lists 
(e.g. MONDAY to SUNDAY ) to perform Autofill, the users can also create their own lists which are used frequently in your worksheets. 

Comments

Popular posts from this blog

Worksheet Layout and Print Setup एक्सेल में प्रिंट लेआउट कैसे सेटअप करें

Rearrange Cell Contents within Excel

What is a spreadsheet # how to make a spreadsheet