Jump to content

Worksheet cell default formatting


Recommended Posts

Is there a way to set default cell formatting conditions?

An example of difficulties regarding this. I apply to all cells font Arial Bold, Size 12, Aligned center (both - horizontally and vertically). Then I create new rows or columns and their formatting is what I consider default default formatting - Geneva font, Size 10, Aligned H: General, V: Bottom. Then I have to select new cells/rows/columns and format them again in order to have desired formatting for entire table.

Edited by Yancka
Link to comment

You can certainly write a script to format cells. But even using scripts, I don't think there is a way to get inserted rows/columns/cells to take on the formatting of their surrounding cells.

Actually there probably is, but you would have to read that data from the surrounding cells and then assign that to the new cells.

Doable, but probably about 10 hours of scripting time. Not worth it to me for the infrequent times I want to do this.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...