About 1,498,607 results (1,394 milliseconds)

How to limit number or rows and columns in Sheets. I've seen the ...

https://support.google.com/docs/thread/53725030/how-to-limit-number-or-rows-and-columns-in-sheets-i-ve-seen-the-answers-i-can-t-delete-a-zillion?hl=en
Jun 15, 2020 ... I want three columns and thirty rows. I've seen the answers saying to delete the ones I don't want, but as far as I can tell, the row ...

Is there a limit for Pivot Tables? - Google Docs Editors Community

https://support.google.com/docs/thread/126011962/is-there-a-limit-for-pivot-tables?hl=en
Sep 15, 2021 ... it doesn't have to be an XLS file. I just started it in Excel and then uploaded it to Google Sheets. So might this be the issue here? Should I ...

How to set a maximum row height (not looking to set all rows to the ...

https://support.google.com/docs/thread/210770583/how-to-set-a-maximum-row-height-not-looking-to-set-all-rows-to-the-same-height?hl=en
Apr 12, 2023 ... The 'autofit' setting allows rows to expand all the way up to google sheet's max row height limit (409) to accommodate long entries.

Reducing size of worksheets - Google Docs Editors Community

https://support.google.com/docs/thread/176566821/reducing-size-of-worksheets?hl=en
Aug 25, 2022 ... ... limit the size of each worksheet to say 100 rows and 100 columns. is that possible? Thanks in advance. Details. Sheets,Mac OS,Personal use.

How do you import a large excel file to google sheets? - Google ...

https://support.google.com/docs/thread/155048162/how-do-you-import-a-large-excel-file-to-google-sheets?hl=en
Mar 15, 2022 ... The limit is 10 million cells. It is unusual to have more cells than that — it takes a spreadsheet of 10 tabs with 100 columns and 10,000 rows ...

one million rows in a google sheet. - Google Docs Editors Community

https://support.google.com/docs/thread/89816949/one-million-rows-in-a-google-sheet?hl=en
Dec 21, 2020 ... ... columns cause that will put the sheet at it's limit of 5,000,000 cells. ... I can easily handle 250k rows in office excel (xls/csv) but ...

Google sheets limitations - Google Docs Editors Community

https://support.google.com/docs/thread/88183868/google-sheets-limitations?hl=en
Dec 11, 2020 ... Up to 5 million cells for spreadsheets that are created in or converted to Google Sheets · 40,000 new rows at a time · Maximum number of columns ...

Working with a million row spreadsheet - Google Docs Editors ...

https://support.google.com/docs/thread/94756559/working-with-a-million-row-spreadsheet?hl=en
Jan 23, 2021 ... I would like to work with a million-row sheet in Google sheets. I know there is a 5 million cell limit. I don't need to work with the data, I just need to ...

increase rows when filtered data reaches rowa containing other data ...

https://support.google.com/docs/thread/120254117/increase-rows-when-filtered-data-reaches-rowa-containing-other-data?hl=en
Aug 6, 2021 ... I have a sheet that has information from various sources however when the filtered data reaches rows that contain data the filter function does not work.

Too many rows displaying on spreadsheet

https://groups.google.com/g/microsoft.public.mac.office.excel/c/vNOEt-EJbmw
Apr 20, 2010 ... Any way to reduce the number of empty rows that are displaying? ... 2) Excel maintains a "Last used cell" range in each worksheet. But it ...

Google Sheet - Importrange limit - Google Docs Editors Community

https://support.google.com/docs/thread/26583438/google-sheet-importrange-limit?hl=en
Jan 24, 2020 ... I'm trying to use import range in other big google sheet and there are a lot of dados but when I tried to import unlimited row, google sheet show up message ...

Very slow spreadsheet, but nowhere near max cell limit - Google ...

https://support.google.com/docs/thread/3359850/very-slow-spreadsheet-but-nowhere-near-max-cell-limit?hl=en
Mar 31, 2019 ... If there is at least one more row of data, none of the searches are successful. Why??? I expect this "Edit" worksheet to eventually have up to ...

Is there a rate limit on the GOOGLETRANSLATE function in Sheets ...

https://support.google.com/docs/thread/150823013/is-there-a-rate-limit-on-the-googletranslate-function-in-sheets?hl=en
Feb 14, 2022 ... I've got a Sheet here that heavily utilizes the =GOOGLETRANSLATE function for converting many form entries into several other languages. Each ...

Is there a file size limit in sheets? - Google Docs Editors Community

https://support.google.com/docs/thread/118234513/is-there-a-file-size-limit-in-sheets?hl=en
Jul 22, 2021 ... ... Excel files and see if they have large numbers of empty rows or columns. Empty cells are counted against the 5-million cell limit. I happen ...

How to limit access of individual sheets. - Google Docs Editors ...

https://support.google.com/docs/thread/68463761/how-to-limit-access-of-individual-sheets?hl=en
Sep 1, 2020 ... I can make a sample for you, or you can post something that accurately resembles the set up of your real sheet, enter a few rows of data for ...

Limits on data size - AppSheet Help

https://support.google.com/appsheet/answer/10104789?hl=en
Do not exceed 100K rows or 1000 columns in your spreadsheet. Each ... If you've ever worked in an Excel spreadsheet that uses all the processors in ...

Restrict range in google sheets - Google Docs Editors Community

https://support.google.com/docs/thread/24608752/restrict-range-in-google-sheets?hl=en
Jan 3, 2020 ... You can just highlight a selection and then right click on that selection and you should see the option to delete the columns or delete the rows.

Assigning rows to individuals and restricting access to edit their rows ...

https://support.google.com/docs/thread/109813512/assigning-rows-to-individuals-and-restricting-access-to-edit-their-rows?hl=en
May 14, 2021 ... I would like to setup a spreadsheet to assign cases (rows) to other individuals. I would like to restrict editing of those rows to only those assigned.

How can I limit results from this formula to 10 columns to avoid cell ...

https://support.google.com/docs/thread/263719576/how-can-i-limit-results-from-this-formula-to-10-columns-to-avoid-cell-count-limitations?hl=en
Mar 13, 2024 ... I added a sheet to check it out in my example sheet. array_constrain! 9999 max rows 10 max columns. I will however read up on this... You rock ...

Missing columns after moving from MS excel - Google Docs Editors ...

https://support.google.com/docs/thread/84042481/missing-columns-after-moving-from-ms-excel?hl=en
Nov 19, 2020 ... ... rows, that you are running into a file size limit. Sheets can only handle 5,000,000 cells of data while Excel has a much higher limit. Here ...