answersLogoWhite

0

The first key you type in Excel to create any kind of formula is the equal sign (=). If you are trying to create an array formula press CTRL+SHIFT+ENTER. Excel surrounds the formula with braces ({ }) and places an instance of the formula in each cell of the selected range.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the first action you would take to use the pointing technique to create a formula with a worksheet reference?

Type an equal sign (=) in the cell where you want to put the formula.


When Windows Vista and 7 create volumes what type are the first three you create?

When Windows Vista and 7 create volumes, what type are the first three you create


What type of entry does Excel assume you are typing if the first thing you type in a cell is a equals?

A formula.


What is the world's first musical instruments?

I am not sure but music and beats have been around since the beginning of time. Maybe people back then used natural resources to create a musical sound and or beat.


What type of entry does Excel assume you are?

Excel assumes data is text initially, but can treat it differently depending on the way you enter it. That is why you enter an equals sign at the beginning of a formula to indicate to Excel that you are creating a formula.


What type of animal did god create first?

The snake that tricked eve.


What must you type to start off a formula in Excel?

Excel formulas begin with an equal sign, for example:=SUM(A1:A7)will give you the total of the numbers in cells A1, A2, A3, A4, A5, A6 and A7.Array formulas start with = but are enclosed in brace bracket{}.You can also use the plus or minus sign to start a formula, but as soon as you press Enter, a plus will be converted into an equals sign and a minus sign will have an equals sign inserted before it, so the formula will still show as starting with an equals sign.+5+7 will become =5+7-10*2 will become =-10*2Lotus 123 was the big spreadsheet application before Excel. It used the @ sign to start its functions. In order to help people moving from using Lotus 123 to Excel, the ability to start functions with the @ sign was included in Excel, and you can still do that. This applies only to functions at the start of a formula, not any formula.


What feature will provide a list of available functions if you type equals and the first letter of a function in the Formula Bar?

formula auto-complete


When writing a chemical formula the (what type of ion) gets written first.?

Cations are written first. For instance, NaCl or H2O.


Words beginning with type?

Words beginning with 'type' are: type typewriter typecast typeface typeset typesetter typestyle


When the Etruscan's were removed what type of government did Rome create?

First an oligarchy and then a developing limited democracy.


What is the formula type of galena?

formula of ammotal