/docs/community?hl=en
/docs/community?hl=en
5/11/14
Original Poster
Jimmy8675309

Feature Requests: User-Definable Default Numbers of Rows and Columns + Thicker Scroll Bars

Dear Google,

1)  Please enable G-sheets to have user-definable default numbers of rows and columns.  Please place the control for this feature into Drive > Settings > Editing.
  • 1000 rows causes vertical scrolling problems for many people.  Considering that the best "average" of use among the Google population is actually the Geometric Mean and not the Arithmetic Mean of the numbers of rows and columns, 1000 rows is too many for many people.  Furthermore, I would guess that is it too many for most people.
  • I love the feature which allows users to truncate the number of existing rows and columns.  Please do not remove this feature.  Excel does not have it; we can only find this feature in G-sheets.
2)  Please also add a similar (but manual) feature to Spreadsheet > File > Spreadsheet Settings which allows users to manually set the number of rows and columns for the currently-viewed spreadsheet.  Please make this feature to truncate all spreadsheet contents and to give a validation alert whenever users change this setting in a manner that occupied cells would be lost.

3)  Please thicken the scroll bars to normal thickness in Chrome.  The scroll bars are too narrow (half the normal thickness) when Google Products are viewed in Chrome.  Scroll bars still look great in Firefox on XP.  In light of the scrolling problems due to too many rows, the current thinness of the scroll bars exacerbates the aforementioned problem of too many rows.

Thank you!
Community content may not be verified or up-to-date. Learn more.
All Replies (9)
chrisnann
5/13/14
chrisnann
Excellently expressed Jimmy, and my sentiments entirely
TWCO
5/22/14
TWCO
Agreed 100% on the number of rows. Every time we create a new doc we have to spend about 20 seconds selecting all of the blank rows and deleting several hundred to make the spreadsheet manageable for scrolling. 300 - 500 default rows please, we can always add more. Or allow users to specify their preferred default number of rows.
James/mreighties
5/22/14
James/mreighties
Hello,

You can always create a new spreadsheet (old or new, maybe both) and then make the rows and columns the number you want to start with by deleting unwanted rows and columns. Now use this sheet as a "template" and each time you need it just go to "File/Make a copy" and use the copy to work with.

Here is another post where I offer the same solution but I provided them with the "templates".



James :)
5/22/14
Original Poster
Jimmy8675309
Hi James, that is not worthwhile for me.  I have too many folders & files.  For the time I spend creating a new spreadsheet from a template, and then MOVE it to the desired folder, I could spend the same amount of time editing the # of rows and columns.

Everyone else, please mark "Me, too!" on my original post if that is how you feel and the option is available to you.

Finally, thank you, Google for making things as good as they already are.  Woohoo!
Simon Pride
6/17/14
Simon Pride
I just went searching for how to do this and came across this post. I much preferred the previous default which was something like 20 rows, IIRC. I support this request!
Gill
6/19/14
Gill
It was 100, Simon.
Paul Davis - NW VA
6/24/14
Paul Davis - NW VA
Me too!
Maggie Tzakos
6/26/14
Maggie Tzakos
I can't find a "Me Too" button, but please consider this my vote!
chrisnann
6/26/14
chrisnann
In the meantime until it's fixed, you can speed up the delete by selecting your bottom row and then using shift + PageDown. It's much faster (and less frustrating) than using the mouse or down arrow
Were these replies helpful?
How can we improve them?
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Google Employee — Google product team members and community managers
 
Community Specialist — Google partners who help ensure the quality of community content
 
Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts
 
Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions
 
Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions
 
Product Expert Alumni — Former Product Experts who are no longer members of the program
Community content may not be verified or up-to-date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.

false
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false