Note: The other languages of the website are Google-translated. Back to English
Masuk  \/ 
x
or
x
Daftar  \/ 
x

or

Bagaimana cara meningkatkan ukuran font daftar drop down di Excel?

doc meningkatkan ukuran font daftar drop-down 1

Daftar drop-down adalah fitur yang sangat membantu di Excel, ketika Anda membuat daftar drop-down di lembar kerja Anda, pernahkah Anda mencoba meningkatkan ukuran font dari daftar drop-down untuk membuat catatan yang dipilih lebih besar dan lebih mudah dibaca seperti gambar di sebelah kiri? Artikel ini akan berbicara tentang solusi untuk mengatasinya.

Tingkatkan ukuran font daftar drop-down dengan kode VBA untuk memperbesar zoom


Tingkatkan ukuran font daftar drop-down dengan kode VBA untuk memperbesar zoom

Faktanya, tidak ada cara langsung bagi kami untuk meningkatkan ukuran font dari daftar drop-down, tetapi, Anda dapat menerapkan kode VBA berikut untuk mengubah pengaturan zoom sel daftar drop-down untuk membuat teks tampak lebih besar. Harap lakukan sebagai berikut:

1. Buka lembar kerja yang berisi daftar drop-down yang ingin Anda tingkatkan ukuran fontnya.

2. Klik kanan tab lembar, lalu pilih Lihat kode dari menu konteks, di-pop-out Microsoft Visual Basic untuk Aplikasi jendela, harap salin dan tempel kode berikut ke dalam kolom kosong Modul window:

Kode VBA: Meningkatkan ukuran font daftar drop-down untuk memperbesar zoom sel

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

3. Kemudian simpan dan tutup kode ini, sekarang, ketika Anda mengklik sel daftar drop-down, zoom sel akan diperbesar, dan daftar drop-down akan tampak lebih besar, tetapi, ketika Anda mengklik sel lain yang tidak berisi daftar drop-down, zoom sel akan normal.

Catatan: Pada kode di atas, xZoom = 130 akan mengubah zoom sel daftar drop-down menjadi 130, Anda dapat mengubah nomor zoom ini sesuai kebutuhan Anda.


Buat daftar drop-down dengan kotak centang di Excel

Jika Anda perlu membuat daftar drop-down dengan beberapa kotak centang untuk memilih beberapa item dari daftar ke dalam satu sel, mungkin tidak ada cara langsung bagi Anda untuk menyelesaikan tugas ini. Tapi, Kutools untuk Excel mendukung fitur luar biasa - Daftar Drop-down dengan Kotak Centang, dengan fitur ini, Anda dapat dengan cepat membuat daftar turun bawah dengan kotak centang dalam rentang tertentu, lembar kerja saat ini, buku kerja saat ini atau semua buku kerja yang dibuka berdasarkan kebutuhan Anda.  Klik untuk mengunduh Kutools for Excel!


Demo: Tingkatkan ukuran font daftar drop-down dengan kode VBA untuk memperbesar zoom


Alat Produktivitas Kantor Terbaik

Kutools for Excel Memecahkan Sebagian Besar Masalah Anda, dan Meningkatkan Produktivitas Anda hingga 80%

  • Reuse: Masukkan dengan cepat rumus, bagan yang kompleks dan apa pun yang pernah Anda gunakan sebelumnya; Enkripsi Sel dengan kata sandi; Buat Milis dan mengirim email ...
  • Super Formula Bar (dengan mudah mengedit beberapa baris teks dan rumus); Membaca Tata Letak (membaca dan mengedit sel dalam jumlah besar dengan mudah); Tempel ke Rentang yang Difilter...
  • Gabungkan Sel / Baris / Kolom tanpa kehilangan Data; Pisahkan Konten Sel; Gabungkan Baris / Kolom Duplikat... Mencegah Sel Duplikat; Bandingkan Rentang...
  • Pilih Duplikat atau Unik Baris; Pilih Baris Kosong (semua sel kosong); Temukan Super dan Temukan Fuzzy di Banyak Buku Kerja; Pilih Acak ...
  • Salinan Tepat Beberapa Sel tanpa mengubah referensi rumus; Buat Referensi Otomatis ke Beberapa Lembar; Sisipkan Poin, Kotak Centang, dan lainnya ...
  • Ekstrak Teks, Tambahkan Teks, Hapus berdasarkan Posisi, Hapus Space; Membuat dan Mencetak Subtotal Paging; Konversi Konten Antar Sel dan Komentar...
  • Filter Super (simpan dan terapkan skema filter ke sheet lain); Penyortiran Lanjutan menurut bulan / minggu / hari, frekuensi dan lainnya; Filter Khusus dengan huruf tebal, miring ...
  • Gabungkan Workbooks dan WorkSheets; Gabungkan Tabel berdasarkan kolom kunci; Pisahkan Data menjadi Beberapa Lembar; Konversi Batch xls, xlsx dan PDF...
  • Lebih dari 300 fitur canggih. Mendukung Office / Excel 2007-2019 dan 365. Mendukung semua bahasa. Penerapan yang mudah di perusahaan atau organisasi Anda. Fitur lengkap uji coba gratis 30 hari. Jaminan uang kembali 60 hari.
tab kte 201905

Tab Office Membawa antarmuka Tab ke Office, dan Membuat Pekerjaan Anda Jauh Lebih Mudah

  • Aktifkan pengeditan dan pembacaan tab di Word, Excel, PowerPoint, Publisher, Access, Visio, dan Project.
  • Buka dan buat banyak dokumen di tab baru di jendela yang sama, bukan di jendela baru.
  • Tingkatkan produktivitas Anda hingga 50%, dan kurangi ratusan klik mouse untuk Anda setiap hari!
officetab bawah
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    David Frost · 1 years ago
    Thank You for the tip to zoom the size of the font in the drop down box. It did the trick.

  • To post as a guest, your comment is unpublished.
    Ace · 2 years ago
    Hi, Just question i have pasted the code onto blank Module window (Right click in view code). Once i save, is function well that was good. But when i close the file and re-open it, the code was gone and no more enlarge for the drop down list. Can i know how to set for permanent use?
    • To post as a guest, your comment is unpublished.
      skyyang · 2 years ago
      Hello, Ace,
      To save the code, you should save the Excel file as Excel Macro-Enabled Workbook format. Please try it.
  • To post as a guest, your comment is unpublished.
    Paul612 · 3 years ago
    How can I apply this font change size to only one column? I have several columns with drop-down boxes and I only want one specific column to change font size?
  • To post as a guest, your comment is unpublished.
    david.harlev@gmail.com · 3 years ago
    This zooms the whole sheet to 130%
    How do I increase only the drop menu ?
    • To post as a guest, your comment is unpublished.
      skyyang · 3 years ago
      Hello, Dave,
      To only increase the drop down menu, here is a workaround to solve it.

      First, after inserting the drop down list in your worksheet, then you should insert an Combo Box (ActiveX Controls),and then apply the following VBA code into the sheet module code:

      Dim xRg As Range
      Private Sub ComboBox1_Change()
      On Error Resume Next
      xRg.Value = Me.ComboBox1.Text
      End Sub
      Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      On Error GoTo LblExit
      With Me.ComboBox1
      .Visible = False
      If Target.Validation.Type = xlValidateList Then
      Target.Validation.InCellDropdown = False
      .ListWidth = 120
      .ListFillRange = ""
      .ListFillRange = Target.Validation.Formula1
      .Left = Target.Left
      .Top = Target.Top
      .Width = Target.Width
      .Height = Target.Height
      .Font.Size = 16
      .Visible = True
      Set xRg = Target
      End If
      End With
      LblExit:
      End Sub

      After inserting the code, now when you click the drop down list cell, a combo box will be displayed, and font size in the drop down menu is increased as you need. And the inserted combo box will be hidden automatically.

      Please try it, hope it can help you!
      • To post as a guest, your comment is unpublished.
        ITALO BELMONTE · 2 years ago
        Can you explain it step by step for dummies pls?
        • To post as a guest, your comment is unpublished.
          skyyang · 2 years ago
          Hello, ITALO,
          1. Insert the drop down you need in your worksheet;
          2. Then insert a Combo Box (ActiveX Controls) by clicking Developer > Insert > Combo Box (ActiveX Controls), and then drag the mouse to draw a Combo Box object;
          3. And then, right click your current used worksheet, choose View Code, and paste the above code into the module;
          4. At last, click Design Mode under the Developer tab to disable it.
          5. Now when you click the drop down list cell, a combo box will be displayed, and font size in the drop down menu is increased as you need.
          Please try, hope it can help you!
      • To post as a guest, your comment is unpublished.
        GJ · 2 years ago
        GENIUS! Thank you Skyyang! So grateful for your method! Works like a charm!
  • To post as a guest, your comment is unpublished.
    George · 3 years ago
    After using this code, I can't use return key on Excel. How can I code (install) return key?
  • To post as a guest, your comment is unpublished.
    John Driscoll · 3 years ago
    This does not work for me. I pasted the text as instructed. When i clicked on the drop down menu the font size was the same. When i then clicked on a different cell, the whole spreadsheet increased in size perhaps by 30%. Really would like a work around if possible
  • To post as a guest, your comment is unpublished.
    Ahmed Sobhy · 3 years ago
    Thanks, it works well
  • To post as a guest, your comment is unpublished.
    Noel · 3 years ago
    Hi, Just wondering why this feature disappear after the file is saved and re-open?
    • To post as a guest, your comment is unpublished.
      miemieyang005@gmail.com · 3 years ago
      Hi, Noel, you should save the Excel file as Excel Macro-Enabled Workbook format.
  • To post as a guest, your comment is unpublished.
    Travis · 4 years ago
    Like the directions indicate, you must change the zoom from "100" to "130" or a different zoom to see any changes. However, the 1st comment is accurate in that it does not just change the drop down menu, but rather once you click on the cell it will zoom the entire sheet 130% to zoom in on that cell. Not very helpful because then you just have to zoom back out every time.
    • To post as a guest, your comment is unpublished.
      garth · 3 years ago
      or select an alternate cell in the workbook to return it to 100 as stated in the Macro

      Private Sub Worksheet_SelectionChange(ByVal Target As Range)'updateby Extendoffice 20160530 On Error GoTo LZoom Dim xZoom As Long xZoom = 100 If Target.Validation.Type = xlValidateList Then xZoom = 130LZoom: ActiveWindow.Zoom = xZoomEnd Sub
  • To post as a guest, your comment is unpublished.
    Harlem Eins · 4 years ago
    I'm running Office 2016 and using drop-down boxes. I tried the "Increase drop down list font size with VBA code to enlarge the zoom" but it does not work. Is there anything else I should do to make it work?

    Thank you!
  • To post as a guest, your comment is unpublished.
    Michael · 4 years ago
    So, this code makes the whole sheet zoom, not just the drop down box. It also says "cannot save...... VB Project in a macro disabled workbook". Blah blah blah. If I have to hunt all over hell's half acre to get a complete answer to this issue, this is not an answer.
    • To post as a guest, your comment is unpublished.
      Harlem Eins · 4 years ago
      [quote name="Michael"]So, this code makes the whole sheet zoom, not just the drop down box. It also says "cannot save...... VB Project in a macro disabled workbook". Blah blah blah. If I have to hunt all over hell's half acre to get a complete answer to this issue, this is not an answer.[/quote]

      Simply save the workbook as xlsm and follow the steps again. BTW I tried it and it does NOT work for me at all; zoom is still at 100%.