how can we enter data in cells
Answers
Answer:
You have several options when you want to enter data manually in Excel. You can enter data in one cell, in several cells at the same time, or on more than one worksheet at the same time. The data that you enter can be numbers, text dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you.
Note: If you can't enter or edit data in a worksheet, it might have been protected by you or someone else to prevent data from being changed accidentally. On a protected worksheet, you can select cells to view the data, but you won't' be able to type information in cells that are locked. In most cases, you should not remove the protection from a worksheet unless you have permission to do so from the person who created it. To unprotect a worksheet, click Unprotect Sheet in the Changes group on the Review tab. If a password was set when the worksheet protection was applied, you must first type that password to unprotect the worksheet.
Enter text or a number in a cell
On the worksheet, click a cell
type the numbers or text that you want to enter, and then press Enter or Tab.
To enter data on a new line within a cell, enter a line break by pressing Alt+Enter.
Enter a number that has a fixed decimal point
On the File tab, click Options.
Click Advanced, and then under Editing options, select the Automatically insert a decimal point check box.
In the Places box, enter a positive number four digits to the right of the decimal point or a negative number for digits to the left of the decimal point.
For example, if you enter 3 in the Places box and then type 2834 in a cell, the value will appear as 2.834. If you enter a -3 in the Places box and then type 283, the value will be 283000.
On the worksheet, click a cell, and then enter the number that you want.
Data that you typed in cells before selecting the Fixed decimal option is not affected.
To temporarily override the Fixed decimal option, type a decimal point when you enter the number.
Enter a date or time in a cell
On the worksheet, click a cell.
type a date or time as follows:
To enter a date, use a slash mark or a hyphen to separate the parts of a date; for example, type 9/5/2021 or 5-Sep-2021.
To enter a time that is based on the 12-hour clock, enter the time followed by a space, and then type a or p after the time, for example, 9:00 p. Otherwise, Excel enters the time as AM.
To enter the current date and time, press Ctrl+Shift+; (semicolon).
To enter a date or time that stays current when you reopen a worksheet, you can use the TODAY and NOW functions.
When you enter a date or a time in a cell, it appears either in the default date or time format for your computer or in the format that was applied to the cell before you entered the date or time. The default date or time format is based on the date and time settings in the Regional and Language Options dialog box (Control Panel, Clock, Language, and Region). If these settings on your computer have been changed, the dates and times in your workbooks that have not been formatted by using the Format Cells command are displayed according to those settings.
To apply the default date or time format, click the cell that contains the date or time value, and then press Ctrl+Shift+# or Ctrl+Shift+@
Steps to enter data in cells.
- On the worksheet, click a cell.
- type the numbers or text that you want to enter, and then press Enter or Tab. To enter data on a new line within a cell, enter a line break by pressing Alt+Enter Hope it helped