Solved

Add a new row by clicking a cell.

Posted on 2014-08-03
6
184 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 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
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…
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

628 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