How to stay in the same cell after pressing the Enter key in Excel?
Normally, when you finish the content in a cell and press Enter key, the cursor will be moved to the next cell by default. But, sometimes, you just need stay in the same cell after pressing the Enter key. This article, I will introduce you some quick tricks to solve this job in Excel.
- In the Excel Options dialog box, click Advanced from the left pane, and in the right list box, under the Editing options section, uncheck After pressing Enter, move selection, see screenshot: 3. And then click OK button, from now on, when you enter the content into a cell and press Enter key, the input cell is still selected but not move.
- All versions of Microsoft Excel for the PC and Mac now support the ability to press the keyboard shortcut Alt+Enter to move to the next line. To use this keyboard shortcut, type text in the cell. When ready for a new line, press and hold down the Alt key, then press the Enter key. The shortcut key can be used as many times as needed.
Excel On Mac Help
The answer is to use Control + Option + Enter, which will create a line break in the cell. As an alternative, Control + Command + Enter can also be used to achieve the same. These combinations work both in Excel for Mac 2011 and the new Excel for Mac 2015. As pointed out by Shameer in this answer, Alt + Enter now seems to work as well in the new Excel for Mac 2015.
Stay in the same cell after pressing the Enter key with Excel Options
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
In Excel, you can go to the Excel Options to set the option for changing the direction of the cursor after pressing the Enter key, please do as follows:
1. Click File > Options to go the Excel Options dialog.
2. In the Excel Options dialog box, click Advanced from the left pane, and in the right list box, under the Editing options section, uncheck After pressing Enter, move selection, see screenshot:
3. And then click OK button, from now on, when you enter the content into a cell and press Enter key, the input cell is still selected but not move.
Stay in the same cell after pressing the Enter key with Shortcut Keys
In Excel, you can also use shortcut keys to solve this task.
After entering the content, please press Ctrl + Enter keys together instead of just Enter key, and you can see the entered cell is still selected.
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.Does not do anything useful - I want return to act as a return and start a new line within the cell - this 'solution' simply removes the pre-existing text if you start to type again
- To post as a guest, your comment is unpublished.Alt+Enter starts a new line in the cell
- To post as a guest, your comment is unpublished.Can you use these options specifically just for one particular worksheet or range of cells? i want normally to move down on pressing ENTER but in a range of cells want to move right!
While working with Excel, we sometimes enter long text strings in a cell so that the contents either spill over to the empty adjacent cells, or are visually clipped such that we cannot see the rest of the contents.
We can display all the contents of column C above by doing any of these methods:
- Adjust the column width to show the contents
- Wrap the text in cells C4:C6
- Insert a line break or a hard return
Figure 1. Final result: Inserting a hard return
This article assists all levels of Excel users on how to add a hard return in a cell.
What is a hard return?
Hard return, also referred to as a paragraph or line break, causes a line to break at a certain point, and begins the next line with the remaining text string.
It can be done through the keyboard shortcut:
Alt + Enter
How to add a hard return?
In order to make a hard return or the equivalent of a carriage return, we simply follow these steps:
- Enter the edit mode by pressing F2 or double-clicking the cell we want to edit
- Suppose we want to insert a hard return before “123” in cell C4. We place the cursor to the left of “123”.
Figure 2. Enter edit mode and place cursor at specific position
- Press Alt + Enter on the keyboard
Only “4th Floor” remains in the first line of text while “123 8th Avenue New York” is now on the second level.
Figure 3. Inserting a hard return through Alt + Enter
We can insert one more hard return within the cell after “Avenue” to enter “New York” on the third line. Below image shows the output after we have inserted hard returns to cell C4. All the contents of the cell are now visible in the window.
Figure 4. Output: Hard return in a cell
We can do the same to the succeeding cells C5 and C6 in order to display all the contents in the cells.
Figure 5. Output: Hard return within cells
We have successfully added hard returns within the cells and we can now apply this tip when entering data into our worksheet. Hard returns come in handy when we want to force line breaks within cells with long text strings or sentences, and it is super easy to do with just one shortcut: Alt + Enter.
Instant Connection to an Excel Expert
Entering In Excel For Macs
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our liveExcelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.