Solved

Add a new row by clicking a cell.

Posted on 2014-08-03
6
178 Views
Last Modified: 2015-03-02
Add a new row by pressing a button.  Here is a video description http://screencast.com/t/5y1liKJoZTw and the link to the actual page https://docs.google.com/spreadsheets/d/17tR99ldMbQKWXZVXIL7efJJzunq26-xtVu1wGNyadOE/edit#gid=0
0
Comment
Question by:frugalmule
  • 3
  • 3
6 Comments
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40239818
You would need a drawing object with a script to do this.  Unfortunately, you can't record macros with Google Sheets.  Instead you have to use Google Apps Script to develop such applications.

-Glenn

Reference:
https://developers.google.com/apps-script/
0
 

Author Comment

by:frugalmule
ID: 40239848
I'm ok with that approach.  What do I insert and where?
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40239872
I'm sorry, I'm a dead-end here. I've not developed any Apps Scripts.  :-(

Check the online help in GoogleDocs/sheets..type "Record macro" and see the short article about Apps Scripts.  There are some free beginner courses online that may help.

-Glenn
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Closing Comment

by:frugalmule
ID: 40261701
thanks
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40261703
Sorry that I couldn't provide more-direct assistance.  I'll probably start developing Apps Scripts in the next year as more folks use Google Sheets.
0
 

Author Comment

by:frugalmule
ID: 40261754
Yeah, I wish I knew as well.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This Micro Tutorial demonstrates the importance of annotations in Google Analytics and how they should be used to document changes made to a site, Google updates (Ex: Panda & Penguin), marketing campaigns, and any other events that might have contri…
This Micro Tutorial will demonstrate common damaging and frequent mistakes I see in most analytic audits. Most of them are campaign tagging mistakes, so this video will break it down into simple steps.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question