Creating Arrays using Google Sheets


The benefits of using arrays, is that the cells are protected without going into the protection process.

The first cell contains the array formula.

To create an array you must use these keys Ctrl Shift Enter then Enter

Create an Array

1.    Select a group of figures

2.    Press =

3.    Select eg: Group of Qty figures

4.    Select eg: Group of amount figures

5.    Press Ctrl Shift Enter, Press Enter

Delete an Array

1.    To delete all cells that are performing the array

2.    Select the First cell which contains the formula

3.    Press Delete

 

 

=ArrayFormula(F3:F9*G1)

Related Topics

Choosing Microsoft Office v’s Google Apps

Skilled v’s unskilled workers on Microsoft Office products – Excel, Word, PowerPoint, Outlook

How to decide which course level of Excel to book into – Intro, Interm or advance

 

 

Advertisements

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Google Apps and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s