Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Add a new row by clicking a cell.

Posted on 2014-08-03
6
Medium Priority
?
185 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 

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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

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 article discusses how to create an extensible mechanism for linked drop downs.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates how to quickly find related content for YourTango's posts using MozBar Chrome extension.

670 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