Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Continuous Formatting
I have a sheet that is used to log data. New data is added several times a day. The sheet currently contains data through line 2223, however I can only format the next 20 rows because that's all the more the sheet will allow. Once I've entered data into line 2243, another 20 rows will be available to format. Is there any way for the formatting to carry through without beyond 20 rows at a time?
Comments
-
Hello,
You can use the steps below to format the entire column or sheet:
- An entire column: Select the column header and apply the formatting you would like. Doing this will apply column formatting to both existing and newly added cells in the column.
- An entire sheet: Highlight all columns in the sheet by clicking the left-most column's header, scrolling to the right, then [Shift]+clicking the right-most column's header. When you release your click, all of the columns and rows in the sheet should be highlighted and you can then click the desired formatting icon.
You can learn more about how to format your sheet here: https://help.smartsheet.com/articles/518246-formatting-options
Kind Regards,
Smartsheet Support
-
One thing to note is that smartsheet has auto-formatting options. As long as you delete the "extra" rows and save your sheet - anything added to the sheet will carry the same formatting as the last row. Even when smartsheet auto-adds extra rows, those will carry autoformatting when new rows are added. See here for more on Auto-formatting: https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives