0
If you have more than one cell selected and type something and then press Ctrl-Enter, it will put what is typed into all the selected cells. So it can be used as a quick way of filling a lot of cells or copying a formula into a range when it is entered, rather than copying it separately afterwards. If just one cell is selected, then after pressing Ctrl-Enter the same still will still be active, rather than moving to a different cell.
Wiki User
∙ 13y ago
Wiki User
∙ 9y agoF2 edits a cell. Shift Ctrl Enter will enter a value into a cell. If more than one cell has been selected, all the selected cells will be filled with the value. If a formula is entered, Shift Ctrl Enter, will enter it as an array formula.
Add your answer:
Earn +20 pts
What does ctrl comma do in Microsoft Excel?
Ctrl-comma does not do anything in Excel. Ctrl ' copies from the cell above and Ctrl `switches to and from the formula view.
What key do you hold down to use drag and drop in Microsoft Excel?
Ctrl
What does pressing Ctrl plus Enter in Microsoft word do?
trt...... Ctrl shift enter is page break. Meaning it forms a new page.
How can you expand to cell XFD in Microsoft Excel 2007?
Use the CTRL- right arrow
How do you line break in Excel for Mac if alt enter doesn't work?
With Excel on a Mac a line break is entered by adding the Command (cmd) key to the other two - cmd alt enter. The Command key may be replaced by the Control key (ctrl) in some versions of Excel - It's a Microsoft thing.
How do you enter data for Microsoft Excel?
Click on a cell and type in what you want to enter.
How is a sheet made active in Microsoft Excel?
Use Ctrl and Page Up or Ctrl and Page Down to switch between open worksheets.
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 is the shortcut key in Microsoft Excel to copy a formula from the cell above instead of dragging it?
Ctrl-D
In Microsoft Excel what key combination do you press to move the last cell containing data?
Ctrl - End.
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.
Which keyboard key using for filter removing in Microsoft Excel?
Ctrl - Shift - L can turn filters on and off.
