This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
For some time I have been looking for a simple global way of making changes to Excel spreadsheet price lists from various Vendors.
I would like to know how to globally affect a spreadsheet so I can separate the rows with the chosen border style without doing this row by row or column by column. I have one vendor that has more than 24,000 line items so by the time I would "try" to make the desired border adjustments a new price list would be released.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
How were the rows chosen to apply the specific border styles?
Excel is better dealing with numbers. To the best of my knowledge while it may be able to pick up that a border has been applied, I don't think it can pick differnt colors or styles.