Auto scroll to bottom of Google Sheet | Hotkey & Script guide

Channel:
South Africa TroubleChute
Subscribers:
278,000
Published on ● Video Link: https://www.youtube.com/watch?v=tr8AhQ-8FLk


Category:
Guide
Duration: 3:44
18,858 views
124

Find yourself scrolling to the bottom of Google Sheets files often, but want to make it quicker? This video shows you all you need to know about speeding up the process. From simple hotkey to something that scrolls to the bottom for you automatically.

function onOpen(){
let ss = SpreadsheetApp.getActiveSpreadsheet();
let sheet = ss.getSheetByName(ss.getSheets()[0].getName());
sheet.setActiveRange(sheet.getRange(sheet.getLastRow(),1));
}
Timestamps:
0:00 - Explanation
0:38 - Google Sheets jump to bottom hotkey
1:07 - Auto jump to bottom in Google Sheets
1:46 - Creating a Script in Google Sheets

#Google #Sheets #Script
-----------------------------
πŸ’Έ Found this useful? Help me make more! Support me by becoming a member: https://youtube.com/channel/UCkih2oVTbXPEpVwE-U7kmHw/join
-----------------------------
πŸ’Έ Direct donations via Ko-Fi: https://ko-fi.com/TCNOco
πŸ’¬ Discuss video & Suggest (Discord): https://s.tcno.co/Discord
πŸ‘‰ Game guides & Simple tips: https://YouTube.com/TroubleChuteBasics
🌐 Website: https://tcno.co
πŸ“§ Need voice overs done? Business query? Contact my business email: TroubleChute (at) tcno.co

Everything in this video is my personal opinion and experience, and should not be considered professional advice. Always do your own research and make sure what you're doing is safe.



Other Videos By TroubleChute


2021-05-28How to Force Windows 10 to Upgrade | Updates not showing | 21H1+
2021-05-27Fix DirectX Errors | Resident Evil Village Guide
2021-05-24How to Mod Resident Evil Village | Crash Course
2021-05-22The FASTEST Epic Games Account Switcher (Beta) | Free | Open-Source
2021-05-20Fix: steam_api64.dll Error | Resident Evil Village
2021-05-20Fix: Startup Crash/Blank Screen | Resident Evil Village
2021-05-20Fix WMVideo Decoder Error | Resident Evil Village
2021-05-19Fix Blank Screen/Won't Launch | Epic Games Guide
2021-05-18Fix: Download Incomplete replay error | CS:GO
2021-05-17Fix: Couldn't install dependency error | Valorant Guide
2021-05-09Auto scroll to bottom of Google Sheet | Hotkey & Script guide
2021-05-08How to get Twitch Drops | Don't Starve Together Guide
2021-05-07Fix: Error 0x426-0x0 | Microsoft Office 365, 2019, 2017 etc
2021-05-06Fix: Broken Textures/Models | Apex Legends Season 10 | Steam & Origin
2021-05-06Fix: "No servers found" Error loop | Apex Legends Season 10 | Steam & Origin
2021-05-04How to use Adobe Fonts on your website | Typekit Guide
2021-05-03The FASTEST BattleNet Account Switcher (Beta) | Free | Open-Source
2021-05-02Nvidia eGPU: How to Fix Code 43 Error | Easiest guide
2021-04-30BEST Optimization Guide | Max FPS | Enlisted
2021-04-30Change language back to default/English | Apex Japanese/Audio language
2021-04-28Complete guide to fix Input Lag/Latency | CoD Warzone


Tags:
scroll to bottom google sheets
jump to the bottom of a dataset
jump to bottom
automatically jump to bottom
jump to bottom hotkey
how to jump to bottom
autojump to bottom
google sheets
tutorial
how to
guide
2021
scripting
scripting guide
google sheets tutorial
how to use google sheets
learn google sheets
google sheets tips and tricks
google sheets tips
using google sheets
google sheets tutorials
google docs
google sheets basics
advanced google sheets
sheets