How to Make a Colored Table in Excel Automatically

        Tables are often used to group important data, for example, for a recap of sales of goods at the end of the month. The table format, which only consists of rows and columns, of course, makes it easier for us to read a report. In this regard, this page will share tips on how to easily create tables in Microsoft Excel and is very suitable for beginners or those who are new to this Microsoft data processing program. Well, create a table in Excel to make it neat and look more professional. You can give color to the Excel table, especially in the header or table head. More than that, in making tables in Microsoft Excel, the problem of choosing a style must also be considered by adjusting to the existing document format.

        Apart from that, editing a table in Excel is also very practical. You can simply thicken the line or table border as you wish. Well, to maximize the creation of a table on a Microsoft Excel worksheet, it is a good idea to do it on a laptop or computer. As a result, the android phone is not ideal, and the interface is too small. Let's get right to it and show you how to make a table in Excel with Windows users.

Steps to Create a Table in Microsoft Excel

        A few tips to quickly start the process of creating a table in Excel, especially if you need it in large quantities, are by copying the Excel table. Without having to start from scratch, you just need to move the data into the Excel table.

Creating Plain Excel Tables

our first tutorial will try to create a table that is commonly used by many Microsoft Excel users, namely by bolding the lines on the table. The method is very simple and easy to follow, especially for those of you who are new to this data processing application.

1. Open the Microsoft Excel worksheet on your computer or laptop.
2. Enter all the required data when you are finished. Please select all of them with the cursor or press the Ctrl+A  keys on the keyboard.

3. Enter the Font category, then open the Bottom Border dropdown menu, then select All Borders to create a line on the table.
4. Well, next to set the table title or header. You can select it using the cursor, then you select Merge & Center to unite rows and columns into one cell.

5. The next step is to thicken the table lines to have a neat and attractive appearance. You open the Bottom Borders dropdown menu and select the More Borders option.

6. Well, after the Format Cells appear, you go to the Border menu tab. In the Line Style section, select the thickest line. If you want to make it more formal, from the Presets section, you can choose Inside and Outline
7. Then all the lines inside and outside the table will be bolded. You can check them in the sample border-box below.

8. Finally, when you have finished setting the line thickness on the table, You click OK to save it.

Thank you everyone for visiting my blog and waiting for the next update. See you next time... 😊


Daily Page View


Adobe Acrobat Adobe Photoshop Alexa Rank Andorid Application Art Austria Beginner Belgium Blog Community Blogger BUMN Bupati Gresik Canada chromium tricks Coin Market Cap Computers Cosmology CPNS/PPPK Cryptocurrency Dancing Denmark Doctoral Doker Education Educational Excel Excel Table Features Film Finland font French Gadget Gallery Garuda Emas Germany Google Analytics Google Form Hardware Homestay Hong Kong Ilovepdf Indrawan Vpp Interior Design iphone iphone 13 Pro iphone 13 Pro Max iphone 13 Pro Max gsmarena Ireland Italy Kampung hijau Karang Taruna Karir/Career Keyword Keywords KKPR dan PKKPR LaTeX Linux LKPM Lowongan Kerja BUMN/SWASTA Mac Majalah Tech Material Physics Material Physics. Mechanical Engineering (ME) Microsoft 365 Microsoft Excel Microsoft Office Microsoft PowerPoint Microsoft Word Nero Nero Burning 2021 Networking New Technology NFC online Operating Systems Optic OSS RBA OTOMOTIF PDF Perizinan Berusaha Persetujuan Lingkungan Pinjaman Online Posgraduate Postgraduate PowerPoint Presentations Profil Perusahaan/Company Profil Profil-Perusahan PT Aerotrans Services Indonesia (Garuda Indonesia Group) PT Astra Tol Nusantara (ASTRA Infra) PT Indomarco Prismatama (Indomaret Group) PT Indonesia Epson Industry PT Jakarta Industrial Estate Pulogadung PT Pertamina Training & Consulting (PTC) PT. Indofarma (Persero) PT. Kimia Farma Group Publisher Pyrolysis Quantum Computing Quantum Physics Quiz Renewable Energy Research Scholarship Semi conductor Semiconductor SEO Sertifikat Halal Smartphone Spintronic Study Abroad Super Capasitor Superconductor SWASTA Tata Cara Pendaftaran Surat Izin Usaha Industri (SIUI) Technology Tecnology Thailand The Best Trip & Travel Tutorial United Kingdom United Stated United States VGA card Website Windows 365 Windows Tips Word Document WordPress Zero Waste zodiak