Faye has attended:
Excel Intermediate course
Excel Advanced course
Creating an array
Hi.
I am looking at the section of my training pack for creating an array. It says that instead of pressing E after typing the formula I should press F+S+E.
I have tried to do this but it doesn't seem to be working? Is it literally a case of pressing the letters F,S and E? Or do they have another meaning?
Thanks
RE: Creating an array
Hello Faye,
Thank you for the post,
To create an array formula, select the range of cells or individual cells in different areas of the worksheet, to which you wish to apply the same formula, in the first cell (highlighted) type the formula, then hold down the CTRL and SHIFT keys and press Enter. This will apply the formula to the entire range. You can identify an array formula by {} curly braces.
I'm not too sure what the F,S and E are all about, I will have to check the training manual on the CD.
There are some functions such as Data>Table command which will create an array, usually these can also be identified by the {} curly braces which surround each result cell formula.
I hope that helps, regards Pete