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?

Find more posts tagged with

Comments

Pam Alakai

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

Mike Wilday

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