Home » Education » Get Sheet Names in Google Sheets (Current Sheet and ALL Sheets)

Get Sheet Names in Google Sheets (Current Sheet and ALL Sheets)

Written By Spreadsheet Point on Thursday, Feb 04, 2021 | 07:30 AM

 
Article Link: https://spreadsheetpoint.com/get-sheet-name-google-sheets/ In this video, I will show you how to quickly get the sheet name in a cell in Google Sheets. I'll also show you how you can get the names of all the worksheets within the Google sheet document as a list. While this is not possible using any inbuilt Google Sheets function, you can easily create a custom function using Google app script. You can get the code from this link: https://spreadsheetpoint.com/get-sheet-name-google-sheets/ 00:00 Intro 00:11 Get Active Sheet Name in Google Sheets 02:06 Get the Names of All the Sheets in Google Sheets Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - https://www.youtube.com/c/spreadsheetpoint This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/ #GoogleSheets #GoogleSheetsTips #Spreadsheet