Inserting New Columns and copying formatting
I have a sheet where I need to add some more columns in the middle, however when I go to insert the columns, the formatting and coloring of the cells follows the columns at the end of the sheet, rather than those on either side of it. Does anyone know how to make it so that when you hit "Insert Column Right" or Insert Column Left, it will copy the formatting of the cell you click on? This seems like a basic detail to overlook.
Comments
-
Hi Brian,
If you marked the whole row and changed the color or formatting, it would follow to the new columns. You could also set up conditional formatting rules to decide how it should look. Another option could select the cells and drag them to the new columns to copy the formatting.
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives