98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Creating an array
Creating an array
Resolved · High Priority · Version 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
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Make macros work in newer versions of ExcelIf you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using. |