Data Entry in Excel: A Beginner’s Step-by-Step Guide

Posted January 29, 2024

Mastering data entry in Excel is a fundamental skill that opens the door to efficiently setting up and managing tables of data.

If you’re new to Excel or find data entry a bit challenging, you’re in the right place. In this guide, we’ll walk you through the essential steps, tips, and hacks for entering data into your Excel worksheet easily and effectively.

Let’s dive into the world of Excel data entry and transform how you handle your data!

Entering data into an Excel worksheet

You can enter either values (numbers and dates) or labels (text) into any cell within the worksheet.

1. Move the cell pointer to the required cell and then type the data. While you type the data you will notice that it appears both in the worksheet (in the example below, the text appears in cell A1) and in the Formula Bar.

data entry in excel

2. Press ENTER to enter the information into the cell. Your cell pointer will move down to the cell below.

Tip: If you press the ESC key instead of ENTER the data will not be entered into the cell.

Deleting and replacing data

  • To delete data select the cell containing the data and then press DELETE.
  • To replace data just type directly over the top of the existing cell contents. The new data will replace the old.

Using Undo and Redo

There will be times when you enter data only to realise you have made a bit of a mess of things.

Most times you want to back-back to where you were before the mistake was made.  If this happens you can click the fabulous “Undo” button which will undo the last thing you did.

excel data entry

You can actually keep clicking it until you get back to a point where you feel in control again.

And if you go one step to far back, you can click the Redo button to go forward a step again.  These buttons are fabulous and you use them a lot.

Overlapping data

If you enter data that will not fit the column width it will overlap into the next column. In the example below the text ‘Travel Expenses’ is entered into cell A1, however it looks as though the text is included in cells B1. With cell A1 selected we can see in the Formula bar that both words are indeed in A1.

data excel

If you are not using the column into which the text is overlapping you may leave the text as it is. However, as soon as you place text into a cell that has been overlapped it will look as if your text has been lost. In the example below, the text ‘Amount ex GST’ has been entered into cell C3. However the content of cell D3 is hiding part of the content is C3.

data in excel

By selecting C3 the entire cell’s content can be seen in the Formula Bar. In order to view the entire contents of cell C3 the width of column C needs to be adjusted.

Working with columns

The standard column width for Excel is 8.43 character spaces. You can change the column width by dragging with your mouse on the column headers, or by double clicking between two column headers.

Tip: If multiple columns require the same width, select the columns and widen one of them with the mouse. The rest will be adjusted to the same width.

Adjusting the column width

To use your mouse to adjust the column width:

1. Move your mouse pointer over the column’s right edge in the column header area. Your mouse pointer should change to a double-headed arrow.

data on excel

2. Click and drag to the right to expand, or to the left to shrink the column width to the size you require.

excel data sheet

You will now be able to see your entire text. Continue dragging until all columns are the width you require.

data in excel sheet

 


Tips:
To quickly adjust the column width to fit the widest entry, move your mouse pointer over the lines between the column headers. When the pointer becomes a double-headed arrow double-click.

Use the same method for adjusting the height of any row. Just move the mouse pointer over the line separating the rows. When the pointer becomes a double-headed arrow, drag or double-click to adjust the row height, or double-click to set the height to fit the tallest entry.

enter data

By the way, row heights will automatically alter if the font size of data is altered.

Extra info: to set a column width to a precise measurement on the Home tab in the Cells group select Format and then select Column Width. Type the desired width in the Column Width box and then click OK to accept the new column width.

What do hash signs mean in Excel?

If you ever see a cell containing  ########  (hash signs)  it means the column isn’t wide enough to display the content. Just extend the width and the content will become visible.

Making changes to the data

Once you have entered data into your worksheet, you can edit the data in a number of ways.

  • Select the cell and then click in the Formula bar. A flashing insertion point will be placed into the bar. Use the arrow keys on the keyboard to move the insertion point. Make the changes you require and then press ENTER.
  • You may also type directly over the data in the cell with new data and then press ENTER. The new data will replace the old.
  • Double clicking a cell or pressing F2 allows you to edit the contents of the cell directly on the worksheet. Make the changes and then press ENTER to update the cell.

AutoComplete

AutoComplete is the ability for Excel to automatically complete an entry for you.
For example, if you have typed text in the cells above as soon as you start typing a letter or two in a cell below, Excel will check the list above for a matching entry and complete the entry for you.

entering data
This can be very useful when you need to make the same entry several times.

To accept the entry press ENTER. To reject the displayed entry and type something different either ignore the entry and type right over it or press DELETE.


Was this blog helpful? I'm here to empower your journey with Excel, aiming to make your daily tasks more efficient and boost your potential.

Share your thoughts in the Comments below - your insights not only enrich others, they also help me tailor future content to your needs.

And if you're looking to take a step further, join our exclusive '
Insider Group'. As a member, you'll get early access to our latest tips, and in-depth tutorials. Sign up Today!"

Happy Excel-ling!!

Excel enter data

How to enter data in Excel (data entry)

When you haven’t been shown how to enter data it can be a little tricky, so follow these steps to learn the tips and hacks to entering your data easily into your worksheet.

Instructions

Entering data into an Excel worksheet

  1. Move the cell pointer to the required cell and then type the data.
  2. Press ENTER to enter the information into the cell. Your cell pointer will move down to the cell below.

Deleting and replacing data

To Delete: Select the cell containing the data and then press DELETE.

To replace data: Type directly over the top of the existing cell contents. The new data will replace the old.

Using Undo and Redo

If you make a mistake, you can use the Undo button on the top right of the Excel spreadsheet to undo the last thing you did. You can keep clicking it to go back multiple steps.

If you Undo something you didn't want undone, you can use the Redo button to the right of the Undo button to go forward a step again.

Overlapping data

If you enter data that will not fit the column width it will overlap into the next column. Adjust the width of the columns in order to view the entire contents.

Working with columns

Adjusting the column width

  1. Move your mouse pointer over the column’s right edge in the column header area. Your mouse pointer should change to a double-headed arrow.
  2. Click and drag to the right to expand, or to the left to shrink the column width to the size you require.
  3. You will now be able to see your entire text. Continue dragging until all columns are the width you require.

Making changes to the data

  • Select the cell and then click in the Formula bar. A flashing insertion point will be placed into the bar. Use the arrow keys on the keyboard to move the insertion point. Make the changes you require and then press ENTER.
  • You may also type directly over the data in the cell with new data and then press ENTER. The new data will replace the old.
  • Double clicking a cell or pressing F2 allows you to edit the contents of the cell directly on the worksheet. Make the changes and then press ENTER to update the cell.

AutoComplete

Sometimes when you are typing in a cell, Excel will automatically complete the entry for you. To accept the entry press ENTER. To reject the displayed entry and type something different either ignore the entry and type right over it or press DELETE.

Notes

Note: While you type the data you will notice that it appears both in the worksheet cell and in the Formula Bar.

Tip: If you press the ESC key instead of ENTER when typing data into a cell the data will not be entered into the cell.

Tips: To quickly adjust the column width to fit the widest entry, move your mouse pointer over the lines between the column headers. When the pointer becomes a double-headed arrow double-click.

Extra info: to set a column width to a precise measurement on the Home tab in the Cells group select Format and then select Column Width. Type the desired width in the Column Width box and then click OK to accept the new column width.

Note: If you ever see a cell containing  ########  (hash signs)  it means the column isn’t wide enough to display the content. Just extend the width and the content will become visible.

Did you try this?

If you found this blog helpful please leave a comment below.

Elevate your Excel game and become a pro with our exclusive Insider Group

Be the first to know about new tutorials, videos, and tips for Microsoft 365 products. Join us now and claim your exclusive bonus today!

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
    Skip to Instructions
    >