About 1,497,560 results (5,885 milliseconds)
How do I add a row to a table without it automatically changing the ...
https://support.google.com/docs/thread/87022216/how-do-i-add-a-row-to-a-table-without-it-automatically-changing-the-cell-references-in-another-cell?hl=en Dec 5, 2020 ... ... data in the 1st row in its sum. Is it possible to turn this feature off in specific cells in a google spreadsheet? The two workarounds I ...
Adding New Rows Based on Dynamic Content in an Invoice ...
https://support.google.com/docs/thread/111911712/adding-new-rows-based-on-dynamic-content-in-an-invoice?hl=en May 31, 2021 ... I don't think that we can provide a useful formula for filling an unknown number of rows with values without some idea of where that data is ...
How do I make newly added rows automatically inherit pre-existing ...
https://support.google.com/docs/thread/11907000/how-do-i-make-newly-added-rows-automatically-inherit-pre-existing-formulas?hl=en Aug 13, 2019 ... Currently, adding a new row only inherits data validation rules from pre-existing cells (by default), but not formulas. I tried an Array Formula ...
How can I insert paste instead of replace paste in Sheets? - Google ...
https://support.google.com/docs/thread/3408051/how-can-i-insert-paste-instead-of-replace-paste-in-sheets?hl=en Apr 1, 2019 ... ... data at the top of my spreadsheet and have my old data below it. Each time I do this, I'm having to insert a row, then two rows, four rows ...
Add total row to filtered query from a data validation - Google Docs ...
https://support.google.com/docs/thread/149865346/add-total-row-to-filtered-query-from-a-data-validation?hl=en Feb 7, 2022 ... After unsuccessfully trying to add a total row at the bottom of filtered query data filtering off a drop down data validation I need some help.
How to automatically insert a blank row between date changes ...
https://support.google.com/docs/thread/66186687/how-to-automatically-insert-a-blank-row-between-date-changes?hl=en Aug 21, 2020 ... None of us are familiar w/ google sheets or excel so I'm trying to make it as easy for our director as possible. If possible I'd like the sheet ...
Adding a row below the last row of a table without losing the borders ...
https://support.google.com/docs/thread/149044555/adding-a-row-below-the-last-row-of-a-table-without-losing-the-borders?hl=en Feb 2, 2022 ... en I have new data, I wish to add it to my table by creating new rows after the last row. My problem is that when I click "add a row below" my ...
How to have cell formula auto-populate when adding a new row to a ...
https://support.google.com/docs/thread/92874886/how-to-have-cell-formula-auto-populate-when-adding-a-new-row-to-a-sheet?hl=en Jan 10, 2021 ... Essentially I am looking for the same functionality that happens in Excel when you define a true "table". Example: If the formula of cell F8 is ...
How to add a row in an import range function - Google Docs Editors ...
https://support.google.com/docs/thread/88317722/how-to-add-a-row-in-an-import-range-function?hl=en Dec 12, 2020 ... New data be reflected at the bottom. I don't know if this can be down with a formula or if it need to be a script. Either way ...
How can I format a sheet so additional rows added will assume the ...
https://support.google.com/docs/thread/214192617/how-can-i-format-a-sheet-so-additional-rows-added-will-assume-the-same-formatting?hl=en May 4, 2023 ... ... rows added will assume the same formatting? I have a sheet to which users add new rows of data. Can I format the cells such that, when new data ...
How I can add 4 blank rows after each row of data? - Google Docs ...
https://support.google.com/docs/thread/179324162/how-i-can-add-4-blank-rows-after-each-row-of-data?hl=en Sep 14, 2022 ... Hi, I have a list of states and numbers in the range a2:c I am attempting to insert 4 blanks rows after very row of data.
Forms responses adding new rows rather than overwriting blank ...
https://support.google.com/docs/thread/15177338/forms-responses-adding-new-rows-rather-than-overwriting-blank-ones?hl=en Sep 24, 2019 ... My formulas in 'Compiled' are using data from various different columns so there are quite a few formulas affected. Some of them are pulling the ...
How to get a new row in a data table to inherit properties from ...
https://support.google.com/docs/thread/250371309/how-to-get-a-new-row-in-a-data-table-to-inherit-properties-from-previous-rows?hl=en Dec 26, 2023 ... However, unlike Excel, you can delete all the rows from a sheet and retain only the rows you need. By doing this, the formatting, data ...
Insert rows in a chart and have series automatically update with the ...
https://support.google.com/docs/thread/316739213/insert-rows-in-a-chart-and-have-series-automatically-update-with-the-relocated-rows?hl=en Jan 3, 2025 ... In Excel this is super easy to do. I can insert a row in the middle of a sheet data and it will retain the references, expanding the chart range if needed.
How do I create a chart from data series in rows, not columns ...
https://support.google.com/docs/thread/6259551/how-do-i-create-a-chart-from-data-series-in-rows-not-columns?hl=en May 16, 2019 ... P&L sheets just don't do this, nobody would understand it. How do I make a nice line graph from data in one row? Details. Sheets, ...
Adding rows to fit queries when there is data in rows below. - Google ...
https://support.google.com/docs/thread/40944545/adding-rows-to-fit-queries-when-there-is-data-in-rows-below?hl=en Apr 18, 2020 ... I am trying to insert a query into a spreadsheet that I has static cells. I want to add query results from a range to a cell in the sheet, ...
How to set up a self-expanding named range? - Google Docs ...
https://support.google.com/docs/thread/39590111/how-to-set-up-a-self-expanding-named-range?hl=en Apr 12, 2020 ... ... Sum formula will not include the data in that row. Is there a way to ... I'll go back to my usual Excel workaround of naming a cell at ...
Error with Adding Extra Rows to Dependent Drop Down Columns ...
https://support.google.com/docs/thread/161459431/error-with-adding-extra-rows-to-dependent-drop-down-columns?hl=en Apr 28, 2022 ... I have tried adding additional columns in the "Data Validation and Named Ranges" sheet for each row I wanted to add. ... Microsoft Excel file to a ...
Two Google Sheets are linked. If I add or delete a row in my ...
https://support.google.com/docs/thread/10102201/two-google-sheets-are-linked-if-i-add-or-delete-a-row-in-my-originating-sheet-it-messes-up-formula?hl=en Jul 17, 2019 ... I have 2 Google Sheets. One is referencing a cell in another doc. If I add or move rows in originating doc, it messes up my data in my other sheet.
How to lock a row to move with a filter on a column - Google Docs ...
https://support.google.com/docs/thread/139208234/how-to-lock-a-row-to-move-with-a-filter-on-a-column?hl=en Dec 7, 2021 ... I am a recent transfer from excel and I am having trouble figuring out how to get a row to align itself with column filters so that when I sort ...