Solved

Add a new row by clicking a cell.

Posted on 2014-08-03
6
176 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Learn new improvements released by Google for Google Calendar. Noted in this article are simple tips and tricks that can make your everyday use of Google Calendar better.
Google is more than just a search engine. Over the years the company has developed a wide range of online services that are readily available to all users. This article highlights how one can use Google services for simple project management.
This Micro Tutorial demonstrates how to create custom reports and the secrets of determine the metrics and dimensions for your data that works best with your needs.
This Micro Tutorial demonstrates in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

770 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