MULTI IN ONE: How to Edit Text in a Cell

<div dir="ltr" style="text-align: left;" trbidi="on">
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
In the previous part, you created a simple Excel spreadsheet. You'll now learn how to edit text in a cell.</div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
To change the text in cell A1, you can just click inside of the cell and start typing. Anything you had there previously would be erased. But if you just want to edit the text (if you've made a spelling mistake, for example), then this is no good. If you want to keep most of the text, and just make minor changes, then you need to do something else.</div>
<div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
In the image below, you can see what's known as the <b>Formula Bar</b>. The Formula Bar is like a long textbox that you can click inside and start typing. Here's what it looks like in Excel 2007:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Excel 2007 Formula bar" border="1" height="166" src="http://www.homeandlearn.co.uk/excel2007/images/FormulaBar.gif" width="340" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
And here it is in Excel 2010 and 2013:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The Formula Bar in Excel 2013" height="160" src="http://www.homeandlearn.co.uk/excel2007/images/2013/section1/formula_bar.gif" width="407" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
To edit a Cell in Excel, first click inside the cell you want to edit (A1 for us). Then click inside the formula bar. Notice where your cursor is now:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Text in the Formula Bar" border="1" height="146" src="http://www.homeandlearn.co.uk/excel2007/images/FormulaBar2.gif" width="346" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
The image above shows that the cell A1 is active, but the cursor is inside of the formula bar.</div>
<div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
With the cursor in the Formula Bar, try changing the text "Numbers" to "Add these Numbers". Press the Enter key when you've made the changes. Your spreadsheet should look like ours below:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The text in the Formula Bar has been changed" border="1" height="146" src="http://www.homeandlearn.co.uk/excel2007/images/FormulaBar3.gif" width="282" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Notice that the active cell is now A2, and that the Formula Bar has a 3 in it.</div>
<div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
However, there's a problem. There's not enough room in cell A1 for our new text. Part of it seems to be in the B column.</div>
<div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
The solution is to widen the whole of Column A. Try this:</div>
<ul style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<li>Move your mouse up to the start of the A Column</li>
<li>The pointer will change shape and now be a black arrow</li>
</ul>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The pointer has changed shape" border="1" height="124" src="http://www.homeandlearn.co.uk/excel2007/images/ChangeColumnWidth.gif" width="217" /></div>
<ul style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<li>Move your mouse over the line that separates Column A and Column B</li>
<li>Your mouse pointer will change shape again, this time to a cross with arrows</li>
</ul>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The mouse pointer is now a cross" border="1" height="124" src="http://www.homeandlearn.co.uk/excel2007/images/ChangeColumnWidth2.gif" width="217" /></div>
<ul style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<li>When you see the new shape, hold down your left mouse button</li>
<li>Keep the left mouse button held down, and drag your cross to the right</li>
<li>Once you have all the text in the A column, let go of the left mouse button. The images below show the process in action (the top two are from Excel 2007 and the bottom two are from Excel 2010/2013):</li>
</ul>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The Column is being Widened" border="1" height="146" src="http://www.homeandlearn.co.uk/excel2007/images/ChangeColumnWidth3.gif" width="237" />      <img alt="All the text is now in Column A" border="1" height="145" src="http://www.homeandlearn.co.uk/excel2007/images/ChangeColumnWidth4.gif" width="239" /></div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img height="146" src="http://www.homeandlearn.co.uk/excel2007/images/2013/section1/widen_1.gif" width="237" />      <img height="146" src="http://www.homeandlearn.co.uk/excel2007/images/2013/section1/widen_2.gif" width="237" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
You can make the height of the Rows bigger or smaller by using exactly the same technique.</div>
<div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
The numbers, however, don't look very tidy. We'll now see how to centre them, and the text as well. </div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<br /></div>
</div>

How to Edit Text in a Cell

In the previous part, you created a simple Excel spreadsheet. You'll now learn how to edit text in a cell. To change the text in cel...