Google App Script for Sheets - Simple cell aligner


A small amount of GAS scripting is needed for this project.


1) I select ONE cell per column (holding control)

2) I run your script that does:

A) Processes the selection the user made to obtain the coordinates of every cell

B) It gets the lowest selected cell (the one taht belongs to the row with highest index)

C) It runs a for cycle for every column that determines the "distance" (in cells) between the selected cell of that column and the lowest selected cell.

D) The script finally runs the command "Insert cells and move down" before every selected cell.

The goal is simply represented in the screenshot I attached to the project, where with one script run, I will have all columns aligned for the cells I selected.



Skills: JavaScript, Google App Engine

See more: simple visual basic script copy contents cell, python rss script google app engine, simple facebook app script, simple google checkout script, simple spring mvc using google app engine, google app engine java simple website, simple google app engine, simple facebook iphone app script, string app script google, simple google app database, simple database google app engine, google script update spreadsheet cell, current cell google spreadsheet script, Google app script, google app script tutorial, google app script examples, google app script gadget, google app script ui, google app script gmail

About the Employer:
( 16 reviews ) Milan, Italy

Project ID: #21191738

Awarded to:


Greetings, I am an expert GAS developer and I've worked on scripts for Google Sheet control and manipulation. I can create this script for you in no time. Just a couple of quick questions and then we can start. Are y More

€30 EUR in 1 day
(30 Reviews)

4 freelancers are bidding on average €30 for this job


I can provide you a simple Google Spreadsheet script that will align your selected cells exactly like you want in less than a day for just €30.

€30 EUR in 1 day
(62 Reviews)

Hello, I was recently working with GAS for another company, I could deal with this within 1-2 hours. Leave me the message if you're interested. Best regards, Dawid Rudnicki

€40 EUR in 1 day
(6 Reviews)

Hi, i have experience with GAS scripting and ready to work with you wright now. Contact to me and send test file. Hope for the future cooperation.

€20 EUR in 1 day
(0 Reviews)