Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2016, 02:30 PM
Jim Robison's Avatar
Jim Robison Jim Robison is offline Change the color of multiple borders Windows Vista Change the color of multiple borders Office 2010 32bit
Novice
Change the color of multiple borders
 
Join Date: Jun 2016
Posts: 9
Jim Robison is on a distinguished road
Default Change the color of multiple borders

I created a very complicated set of black borders on an Excel worksheet. I have now learned that they should have been in another color. Is there any way I can select and change all of them at once, or must I select each one individually? Thanks.
Reply With Quote
  #2  
Old 09-06-2016, 12:44 AM
xor xor is offline Change the color of multiple borders Windows 10 Change the color of multiple borders Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Select the first cell with border. Hold down the Ctrl key and select (one at a time) all other cells with borders. Change the border color. OK.
Reply With Quote
  #3  
Old 09-06-2016, 11:08 AM
Jim Robison's Avatar
Jim Robison Jim Robison is offline Change the color of multiple borders Windows Vista Change the color of multiple borders Office 2010 32bit
Novice
Change the color of multiple borders
 
Join Date: Jun 2016
Posts: 9
Jim Robison is on a distinguished road
Default

Thanks, but I have over 4000 cells. Selecting each one, one at a time, is not an option. Also, when I tried it, I still had to select each cell wall individually. That's up to 16,000 actions.
Reply With Quote
Reply

Tags
borders, change color, select all



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the color of multiple borders different color of borders McCloud Word 1 07-23-2016 11:23 PM
Change color of existing borders for an existing table JayUSA PowerPoint 1 01-21-2016 04:21 PM
Change the color of multiple borders How2 get borders back to their original color pintree3 Excel 13 05-28-2014 04:49 PM
Color White All Table Borders dabrams Word VBA 2 01-23-2013 12:19 AM
Change the color of multiple borders Page-crossing borders in a table with hidden between-cell borders tenpaiman Word 2 08-08-2012 07:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft