You need to follow the same steps that you used while applying the color, and choose another color or choose the option to remove the existing color. If you don’t do this, anything that you do in any of the sheets would also be done to all the other grouped sheets (which is not desired in most cases)Ĭhanging or removing the sheet tab color is quite straightforward. It is very important that you remember to follow Step 5, where we ungrouped these sheets. Steps to Change Border Color From Ribbon Change Border Color using Format Cells Option Change the Color of Gridlines to use it as Borders Related Tutorials. When you select the first sheet, and then hold the SHIFT key and then select the last sheet, Excel groups these sheets.This method will only work for sheets that are placed together, which means that you cannot have any sheet in between that doesn’t need to be assigned the same color.Alt displays the shortcut keys for the ribbon tabs. Enter the keys one after the other, not together. The above steps would assign the same color to all the selected sheets.Ī couple of important things you need to know when doing this: The shortcut keys for changing the cell border color are: Alt, H, B, I.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |