Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-sheets-named-ranges]

0
votes
1answer
15 views

How to name a range so that it doesn't automatically change when rows are added in between

Is there a way to name a range so that it doesn't automatically change when rows are added in between? Ex: Range1 = 'Sheet1'!K5:K36 Add a row between rows 6&7 and now this automatically changes ...
0
votes
0answers
22 views

Reference Specific Row in Named Range within another Named Range

I'm writing a spreadsheet to keep track of a small business' financials. They operate a few Rooms for rent, and the structure of the document is made so that each sheet holds a year's worth of booking ...
0
votes
1answer
41 views

Formula for adding sum total from multiple sheets for a specific name

I am stuck in terms of how to set a formula to get the sum total for a specific "name" from multiple sheets.
1
vote
1answer
85 views

Is it possible to create a Named Range that is the union of two other Named Ranges?

Say I have two named ranges, team_a_coaches team_a_players Is it possible to have another named range, team_a and define it as the union of the first two named ranges? The goal would be that if I ...
0
votes
2answers
81 views

Display the name of a cell in a worksheet

Excel has a little box on the upper left corner that displays the name of the cell. Does Google Sheets have a similar capability? I've named cell B5 "hours" and cell B6 "hrlyrate" so I want to be able ...
1
vote
1answer
1k views

Google Sheets Query(Importrange) with named range?

I am looking for a way to query an imported range using named range. Something similar to this, however I cannot makeit to work Sheet ID#A has a column J whose named range is "Signed" that may ...
1
vote
2answers
704 views

Use named ranges to dynamically add rows in google spreadsheets, while maintaining conditional formatting in newly added rows

I have a table that looks like in Google Spreadsheets: Some numbers in this table are calculated upon a range of cells (for instance, the total in the last row). If I add a new row to this table, I ...
4
votes
3answers
3k views

Can Google Sheets have a discontiguous named range?

I have a data set with multiple values that are not adjacent. I wish to make a named range of these values. Simplified example data: A B 1 ABC 536936062976506 2 XYZ ...
3
votes
3answers
1k views

Does Google Sheets have sheet-level named ranges?

Microsoft Excel allows sheet-level named ranges. See here for an explanation. Google Sheets does have "named ranges" functionality, but I have only figured out how to use it on a workbook-level ...
2
votes
1answer
60 views

Named Range insert by mouse

In Google Sheets, when I start to enter a formula and want to insert the reference to a cell, I just click on that cell and get the reference by row and column. However, if the cell is the part of ...
1
vote
1answer
56 views

Toggle named range window with a button?

I would like to know if it would be possible to toggle the different features in sheets with a script. What I am trying to do is to basically create a button that will show the Named Ranges side ...
6
votes
2answers
11k views

Give a name to a cell in Google Sheets

Excel has a little box on the upper left corner that displays the name of the cell (for example A8, C20, BC104, ...) and this name can be changed to a string of choice (like Force, mass, acc, ...) so ...
2
votes
4answers
912 views

Return name of range as string in Google Sheets

I have a range named apple in Google Sheets. I thought a method like getRangeName("apple") would exist. I want to get the names of many ranges and set them as the header for the columns of a new sheet....
1
vote
1answer
580 views

How many named ranges can a single Google Spreadsheet have?

Is there even a limit to the number of named ranges that you can create within a single Google Spreadsheet? It's rather cumbersome to add a new one, so I would prefer to not just open a spreadsheet ...
3
votes
3answers
6k views

how do I get named ranges in Google Spreadsheets to be more reliable/current?

I'd like to pull values from a named range into a calculation. I have this function: function getNamedRange(n){ SpreadsheetApp.getActiveSpreadsheet().getRangeByName(n); } Seems pretty simple. I ...
9
votes
3answers
4k views

Is it possible to use named ranges in Google spreadsheet queries so that the columns references are kept up to date?

Using Google Spreadsheets, you can write queries. However, if you have column letters in quotes, then they aren't updated as column order changes. Is there a way to write these queries so they don't ...