Note: This article has done its job, and will be retiring soon. To prevent 'Page not found' woes, we're removing links we know about.
If you've created links to this page, please remove them, and together we'll keep the web connected. A data form provides a convenient way to enter or display one complete row of information in a range or table. The data form displays all the columns so that you can see all the data for a row at one time. This is especially useful when you have a range or table that has more columns of data than can be viewed on the screen. Before you create a data form, you must add labels to the top of each column in the range or table. Excel uses these labels to create fields on the form.
Move the cursor to the place in the text you want to insert the hard return. Hold down the Alt key and press enter. This will then break the text in the cell across two lines within the same cell. This can be done multiple times (for example, if you wanted to show a list within a single cell). How to Enter and Edit Excel Data on the iPad. Software; Microsoft Office for Mac. Related Book. Office 2011 for Mac All-in-One For Dummies. By Geetesh Bajaj, James Gordon. Working with comments in Excel 2011 for Mac is a breeze with the Comments group on the Review tab from the Office 2011 for Mac Ribbon. In the following.
Column labels become field names. Data that you enter in each field on the form is put in the next blank row. Important: You can't use a data form to add, change, or delete a formula. Do any of the following: Add data by using a data form. In the range or table that you want to add the row to, click any cell. On the Data menu, click Form.
![How Do I Enter A Return In Excel For Mac 2011 How Do I Enter A Return In Excel For Mac 2011](/uploads/1/2/5/5/125535721/300583874.gif)
Type the information for the new row. Press TAB to move to the next field in the form. When you finish typing data for this row, press RETURN to add the row to the bottom of the list. When you finish adding rows, click Close to add the last new row and close the data form.
You do not have to press RETURN for the last row.
In my old version of Excel for Mac, the enter and tab keys had the same function with the return key having a separate function. This was extremely useful for entering data into a protected spreadsheet. Each time the enter key was pressed the active cell would move to the next cell SKIPPING the locked cells. You could press number, enter, number, enter, number, enter, etc etc safe in the knowledge that each time you pressed Enter the active cell would simply skip over the locked cells (with formulas etc) and stop at the next cell waiting for the number/data (whatever) to be entered. In the new version only the tab key will do this with the enter key now being paired with the return key which cannot perform the old function.
This - in my opinion - is a huge backward step for Excel. Has anyone else experienced this drawback and does anyone have a solution?
If not I believe Microsoft should quickly revert to the old way or at least make the functions of these keys a user selectable option Malcolm MacBook Pro Core2Duo 4 MB Ram 250GB drive 10.6.6. Hi - thanks for taking the trouble to reply. I should have mentioned that I'm using an external (full) keyboard (since the laptop keyboard does not have a 'proper' numeric key pad). Also, I presume in Excel preferences you have selected what to do after the return key is pressed. I selected 'No Move'. Although having checked it out and selected Move Down after pressing the return key, repeatedly pressing the return key on a protected spreadsheet with locked cells the active cell still moves through the locked cell - it doesn't skip it. There is one other thing which might explain the change - which is in laptops the return and enter keys are physically the same.
Not so on an extended keyboard. Return and enter keys are separate. The return key is in the same physical location as on the laptop keyboard but the enter key is at the bottom right of the numeric section. This probably explains - but in my view does not excuse - the combining of the Return and Enter keys into the same function leaving the tab key to do what the enter key used to do! It would still be nice if this was user selectable.
Well, they kept that hidden! Thanks for the tip. I did that - and it got me half way there. Let me explain. In Excel preferences I had unchecked the box in the Edit menu which asked if wanted to move the selection after hitting return.
What I didn't realise is that I had left the (dimmed) box with Down selected. After this, doing what you suggested simply had the cursor moving down albeit skipping over the locked cells - but only downwards. Go back into Preferences/Edit - Check the box 'After pressing Return move selection.' Choose 'right' from the drop down menu. Then Deselect the check box for 'After pressing Return move selection' so that you leave Right in the choice box (albeit now dimmed!) This way on a protected spreadsheet the active cell moves across and down like I prefer and on an unprotected spreadsheet hitting the Return/Enter key simply doesn't move the selection. This may of course not be to everyone's liking - but it is a eminently suitable work around for me. So, thanks for the tip.
With that and a bit of playing around I think I have cracked it. Good 'ole Microsoft! No doubt I'll find some other gotchas!