Advance Excel Me Dropdown List Font Size Ko Increase Kaise Kare

Advance excel me drop down list option bahut hi helpful feature hai. Lekin bahut se logo ko dropdown list ke chhote font size ko lekar thodi problem hoti hai. Agar aapko bhi advance excel me drop down list ke mini font se problem ho rahi hai. To aaj mein aapko iss post me yahi batane wala hu ki ms excel me dropdown list font size increase kaise karte hai. Jisse ki ki dropdown list text aur bhi jyada readable ho jaye.

Excel worksheet me vaise to koi direct method nahi hai drop down list ke font size ko increase karne ka. Lekin aap drop down list ko zoom karne ke liye VBA code ka use kar sakte hai. Excel workbook me VBA code ka use kaise karte hai or dropdown list font size increase kaise karte hai aaiye step by step janate hai.

Advance Excel Me Dropdown List Font Size Increase Kaise KareĀ 

 

Step 1

Sabse pehle niche diya gaya vba code copy kare. Aap zoom size 200 ko kam jyada kar sakte hai.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'updateby Extendoffice 20170620
On Error GoTo LZoom
Dim xZoom As Long
xZoom = 100
If Target.Validation.Type = xlValidateList Then xZoom = 200
LZoom:
ActiveWindow.Zoom = xZoom
End Sub

 

 

Step 2

Ab uss excel worksheet ko open kare jisme drop down list hai. Aur jika dropdown list font size increase karna chahte hai.

Dropdown List Font Size

  1. Sheet tab par right click kare.
  2. View code par click kare.

 

 

 

Step 3

View code par click karte hi ek vba editor open hoga, isme copy kiya code paste karna hai.

Dropdown List Font Size

  1. VBA code paste kare.
  2. Save button par click kar dijiye.

 

Save button par click karte hi vba command work karne lag jayegi. Ab jaise hi aap drop down list par click karenge to list zoom ho jayegi. Aur dropdown list ka font bhi increase ho jayega aur other cell or me click karenge to list zoom out ho jayegi, niche image dekhe.

Dropdown List Font Size

 

Issi tarah se aap excel worksheet me dropdown list font size ko increase kar sakte hai. I hope aapko ye trick samajh me aa gayi hogi fir bhi aapka koi saval ho to niche comment box me comment kar sakte ho. Aur agar aapko ye jaankari helpful lagi ho to apne dosto ke sath bhi isse share jarur kare.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

Leave a Reply

Your email address will not be published. Required fields are marked *