This article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 78,287 times.
Learn more...
This How.com.vn teaches you how to access Google's script editor in a desktop internet browser, and run code in the editor for testing purposes.
Things You Should Know
Steps
- Open Google Sheets in your internet browser. Type sheets.google.com in your browser's address bar, and hit ↵ Enter or ⏎ Return on your keyboard.
- Click a spreadsheet file. Find the spreadsheet you want to run a script on, and open it.Advertisement
- Click the Tools tab. This button is on a tabs bar below the file name in the upper-left corner of your spreadsheet. It will open a drop-down menu.
- Tap Script editor on the Tools menu. This will open the Google's browser-based script editor in a new tab.
- Create your script in the script editor. You can type your script here, or delete everything on the page and paste code from your clipboard.
- If you're looking for some useful scripts, Google offers a few basic suggestions in their developer guides.
- Name your script project. Click the "Untitled project" heading in the upper-left corner of your window, and enter a title for your new script project in the "Edit Project Name" window.
- Click the icon to run your script. This button is on a toolbar below the file name and tabs bar in the upper-left corner of your window. It will save and run the code in the script editor.
- If you're prompted to authorize script testing, click the Review Permissions button, and Allow script testing in your account settings.
Expert Q&A
Tips
About This Article
1. Open Google Sheets.
2. Click a file.
3. Click the Tools tab.
4. Click Script editor.
5. Enter your script into the editor.
6. Click the Play/Run icon on the toolbar at the top.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.