answersLogoWhite

0


Best Answer

The use of the enter key in microsoft Excel is to either:

-Confirm a setting, such as if you typed: "cat", that is what you wanted.

-Input things into an equation (2+2=4)

-Move a cell to the left, right, down, or up.*

*This can be changed in the settings of microsoft excel

User Avatar

Wiki User

12y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

12y ago

The Enter key on the numeric keypad or the Return key on the main keypad are the two main keys. Any of the navigation keys such as the arrow keys or Page Up etc. will also enter a value when it has been typed.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

When you are typing something into a cell, it isn't actually stored in it until you hit the enter key. PRessing enter will put what you typed into the cell and then move the active cell to be the next one, so you can type something into another cell.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

The rectangular selected area goes 1 UP. Pressing ENTER alone, makes it go 1 DOWN.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What does shift ENTER do in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you enter data for Microsoft Excel?

Click on a cell and type in what you want to enter.


Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


What does pressing space bar in Microsoft Excel do?

Pressing the spacebar by itself does not do anything special in Excel, except enter a space. In conjunction with other keys, it does a lot more. Ctrl-Spacebar selects and column and Shift-Spacebar selects a row for example


What does ALT ENTER do in Microsoft Excel?

It gives you a line-break inside of a cell.


How do you insert a new spreadsheet in the Microsoft Excel by keyboard?

Shift+F11 inserts a new worksheet.


Can you create separate files in MS Word Documents for entries in an Excel spreadsheet?

Microsoft Word and Microsoft Excel documents can be linked to each other, so that changes in one document will show up in the other. So it is possible to enter data in Microsoft Word and have it appear in Microsoft Excel. It is also possible to do formulas in tables in Microsoft Word, without linking to Microsoft Excel.


Who are the creators of Microsoft Excel?

Microsoft excel was created by Microsoft


Which keyboard key using for filter removing in Microsoft Excel?

Ctrl - Shift - L can turn filters on and off.


How do you launch Microsoft Excel?

Programs->Microsoft Office->Microsoft Excel


Shift enter do in microsoft?

Shift + Enter moves the active cell up by 1 (up one row). This is the opposite of Enter (where the active cell moves down by 1 or one row)


What is the spreadsheet program in Microsoft office 2007?

I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.


How do you find percentage error in Microsoft excel?

=(A1/B1)*100 then press Ctrl + Shift + % and the cell will be displayed as a percent