Change gridline | grid color in Excel sheet (using settings and using VBA)

Published: 28 January 2021
on channel: LearnYouAndMe

200

In this video, I will show you how to change the default grid (gridline) color in Excel?
You will see two methods of changing Excel gridline color
1st is manual using setting
For this click on the File menu then click on Options. Click on Advance, in Display options for this worksheet there is option named Gridline color when you can select grid color from color palette.

2nd is using Excel VBA to change gridline color
Below code is used and ran to change the gridline color of all the sheets or specific sheet in one shot.

'===code starts
Option Explicit

Sub changeGridlineColor()
Dim sht As Worksheet
For Each sht In ThisWorkbook.Worksheets
sht.Activate
'ActiveWindow.GridlineColor = vbBlack
ActiveWindow.GridlineColorIndex = 45
Next sht
End Sub

Sub changeGridlineColorOfASheet()
'shee2 is code name of a sheet
Sheet2.Activate
ActiveWindow.GridlineColor = vbYellow
End Sub
'===code ends

*Jump to a section
Gridline explanation 00:03
Gridline color change using setting 00:50
Gridline color change using setting using VBA 02:21

🔰 Click the below link to download the file.
https://drive.google.com/file/d/1Z7BO...

🌐 Websites 🌐
🌎https://learnyouandme.com
🌎https://www.juggle.biz
🎫 Make your Digital Visiting Card https://mydvc.info/
🔵Facebook   / learnyouandme
🔴Quora link https://www.quora.com/profile/Abhishe...
===================================================
📌📌You can watch and learn from the below videos also.📌📌
✅ Color related VBA - part1
   • Color  Related VBA - Part 1

✅ Color related VBA - part 2
   • Color Related VBA - Part  2

✅ Cell Blinking or flashing Effect in Excel (Color VBA - Part 3)
   • Cell  Blinking or flashing Effect in ...

✅ Highlight active cell row and column automatically in Excel (keeping original cell color)
   • Highlight active cell row and column ...

✅ Automate line formatting or coloring in a text in a single excel cell.
   • Automate line formatting or colouring...

✅ Subtract time in Excel and get number of hours|Time difference in Excel
   • Subtract time in Excel and get number...

✅ Create bar graph in Excel using conditional formatting
   • Create bar graph in Excel using condi...

#learnyouandme #learn#you#and#me #learnyouandme#VBA

Watch video Change gridline | grid color in Excel sheet (using settings and using VBA) online without registration, duration hours minute second in high quality. This video was added by user LearnYouAndMe 28 January 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 200 once and liked it 5 people.

123