Entering the Same Data Over and Over Again

You lot have several options when you lot desire to enter information manually in Excel. You lot can enter data in one prison cell, in several cells at the same fourth dimension, or on more than than one worksheet at once. The information that you enter can be numbers, text, dates, or times. Y'all can format the information in a variety of ways. And, in that location are several settings that you can adjust to make data entry easier for y'all.

This topic does non explain how to utilize a data course to enter information in worksheet. For more information about working with data forms, see Add, edit, find, and delete rows by using a data form.

Important:If y'all 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, y'all can select cells to view the data, merely you lot won't exist able to type information in cells that are locked. In well-nigh cases, you should not remove the protection from a worksheet unless y'all accept permission to exercise so from the person who created it. To unprotect a worksheet, click Unprotect Sheet in the Changes grouping on the Review tab. If a countersign was fix when the worksheet protection was applied, you lot must first type that password to unprotect the worksheet.

1. On the worksheet, click a cell.

2. Type the numbers or text that yous want to enter, and then press ENTER or TAB.

   To enter information on a new line within a cell, enter a line break by pressing ALT+ENTER.

1. On the File tab, click Options.

   In Excel 2007 but: Click the Microsoft Office Button , and and so click Excel Options.

2. Click Advanced, and and so under Editing options, select the Automatically insert a decimal point cheque box.

3. In the Places box, enter a positive number for 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 prison cell, the value will appear as two.834. If you enter -three in the Places box and then type 283, the value will be 283000.

4. On the worksheet, click a cell, and so enter the number that you want.

   Data that you typed in cells earlier selecting the Stock-still decimal selection is not affected.

   To temporarily override the Fixed decimal selection, blazon a decimal point when you enter the number.

1. On the worksheet, click a cell.

2. Type a date or fourth dimension equally follows:

   • To enter a appointment, apply a slash mark or a hyphen to separate the parts of a engagement; for example, type nine/v/2002 or 5-Sep-2002.

   • To enter a fourth dimension that is based on the 12-hr 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 fourth dimension that stays current when yous reopen a worksheet, yous tin employ the TODAY and NOW functions.

• When you enter a date or a time in a cell, information technology appears either in the default date or time format for your calculator or in the format that was applied to the jail cell earlier you entered the date or time. The default appointment or time format is based on the appointment and fourth dimension settings in the Regional and Linguistic communication Options dialog box (Control Console, Clock, Linguistic communication, and Region). If these settings on your computer have been inverse, the dates and times in your workbooks that have not been formatted past using the Format Cells command are displayed according to those settings.

• To apply the default appointment or time format, click the cell that contains the engagement or time value, and and so printing Ctrl+Shift+# or Ctrl+Shift+@.

1. Select the cells into which you want to enter the same data. The cells exercise not have to be adjacent.

2. In the active cell, type the data, and and then printing Ctrl+Enter.

   You can also enter the same data into several cells by using the fill handle to automatically fill information in worksheet cells.

   For more data, run across the commodity Fill data automatically in worksheet cells.

By making multiple worksheets active at the aforementioned time, y'all can enter new data or change existing data on one of the worksheets, and the changes are applied to the aforementioned cells on all the selected worksheets.

1. Click the tab of the first worksheet that contains the data that you desire to edit. Then hold down Ctrl while yous click the tabs of other worksheets in which you want to synchronize the data.

   

   Note:If you don't run across the tab of the worksheet that yous want, click the tab scrolling buttons to find the worksheet, and then click its tab. If you lot even so can't find the worksheet tabs that you want, you lot might have to maximize the document window.

2. On the active worksheet, select the prison cell or range in which you lot want to edit existing or enter new data.

3. In the active cell, type new data or edit the existing data, and and then press Enter or Tab to move the selection to the side by side prison cell.

   The changes are applied to all the worksheets that you selected.

4. Repeat the previous footstep until yous have completed entering or editing data.

• To abolish a pick of multiple worksheets, click whatever unselected worksheet. If an unselected worksheet is non visible, you lot can right-click the tab of a selected worksheet, and then click Ungroup Sheets.

• When you enter or edit data, the changes bear upon all the selected worksheets and tin inadvertently supercede data that you lot didn't mean to change. To help avoid this, you can view all the worksheets at the aforementioned time to identify potential data conflicts.

  1. On the View tab, in the Window group, click New Window.

  2. Switch to the new window, and so click a worksheet that you desire to view.

  3. Repeat steps 1 and 2 for each worksheet that you want to view.

  4. On the View tab, in the Window group, click Arrange All, and then click the option that you want.

  5. To view worksheets in the active workbook only, in the Accommodate Windows dialog box, select the Windows of active workbook check box.

There are several settings in Excel that you can change to help make manual information entry easier. Some changes affect all workbooks, some bear upon the whole worksheet, and some bear upon only the cells that yous specify.

Change the direction for the Enter key

When yous press Tab to enter data in several cells in a row then press Enter at the end of that row, by default, the selection moves to the offset of the side by side row.

Pressing Enter moves the selection down ane jail cell, and pressing Tab moves the selection one cell to the right. You cannot alter the direction of the move for the Tab central, but you lot can specify a dissimilar direction for the Enter key. Changing this setting affects the whole worksheet, whatever other open worksheets, whatsoever other open up workbooks, and all new workbooks.

1. On the File tab, click Options.

   In Excel 2007 just: Click the Microsoft Office Button , and and then click Excel Options.

2. In the Advanced category, under Editing options, select the Later on pressing Enter, move selection check box, and then click the management that you want in the Management box.

Change the width of a column

At times, a prison cell might brandish #####. This can occur when the cell contains a number or a engagement and the width of its column cannot display all the characters that its format requires. For example, suppose a cell with the Engagement format "mm/dd/yyyy" contains 12/31/2015. All the same, the column is just broad enough to display half dozen characters. The cell will display #####. To see the entire contents of the cell with its electric current format, yous must increase the width of the column.

1. Click the jail cell for which you desire to alter the column width.

2. On the Habitation tab, in the Cells group, click Format.

   

3. Nether Cell Size, exercise one of the post-obit:

   • To fit all text in the cell, click AutoFit Column Width.

   • To specify a larger column width, click Cavalcade Width, and and then type the width that y'all want in the Column width box.

Note:As an alternative to increasing the width of a column, you can change the format of that column or even an individual cell. For example, you could change the date format so that a appointment is displayed every bit merely the calendar month and day ("mm/dd" format), such equally 12/31, or stand for a number in a Scientific (exponential) format, such equally 4E+08.

Wrap text in a jail cell

You can display multiple lines of text inside a cell past wrapping the text. Wrapping text in a cell does not affect other cells.

1. Click the cell in which yous want to wrap the text.

2. On the Habitation tab, in the Alignment grouping, click Wrap Text.

   

Note:If the text is a long give-and-take, the characters won't wrap (the discussion won't be split); instead, you tin widen the column or subtract the font size to come across all the text. If all the text is not visible after you lot wrap the text, you might have to conform the summit of the row. On the Home tab, in the Cells group, click Format, and then under Cell Size click AutoFit Row.

For more than data on wrapping text, see the article Wrap text in a cell.

Modify the format of a number

In Excel, the format of a cell is separate from the data that is stored in the jail cell. This display difference can have a significant effect when the data is numeric. For example, when a number that you enter is rounded, ordinarily only the displayed number is rounded. Calculations use the actual number that is stored in the jail cell, non the formatted number that is displayed. Hence, calculations might appear inaccurate because of rounding in one or more cells.

After y'all type numbers in a prison cell, you can modify the format in which they are displayed.

1. Click the jail cell that contains the numbers that you want to format.

2. On the Home tab, in the Number group, click the arrow next to the Number Format box, and and then click the format that you want.

   

   To select a number format from the list of available formats, click More Number Formats, and and so click the format that you want to utilize in the Category list.

Format a number as text

For numbers that should not be calculated in Excel, such as phone numbers, you can format them as text by applying the Text format to empty cells before typing the numbers.

1. Select an empty cell.

2. On the Home tab, in the Number group, click the arrow next to the Number Format box, and then click Text.

   

3. Blazon the numbers that you desire in the formatted prison cell.

   Numbers that you entered before you applied the Text format to the cells must be entered again in the formatted cells. To quickly reenter numbers as text, select each cell, press F2, and then printing Enter.

Need more help?

You tin ever ask an adept in the Excel Tech Community or become support in the Answers community.

smitheatilten.blogspot.com

Source: https://support.microsoft.com/en-us/office/enter-data-manually-in-worksheet-cells-c798181d-d75a-41b1-92ad-6c0800f80038

Share this post