Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

creating array

ResolvedVersion 2003

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

Edited on Fri 18 Jul 2008, 17:36

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

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.