See all How-To Articles

How to Bold Lines in Excel & Google Sheets

This tutorial demonstrates how to bold lines in Excel and Google Sheets.

 

bold lines initial data

 

Bold Lines

In Excel, you can bold a whole line (row) or multiple lines at once. Say you have the following data set and want to bold all lines with data (1–8).

 

bold lines initial data

 

  1. Select all the rows you want to bold (1–8) by selecting their row numbers on the left side.
  2. In the Ribbon, go to the Home tab.
  3. Click the Bold icon (or use the keyboard shortcut CTRL + B).

 

bold lines excel

 

As a result, Rows 1–8 are now bolded.

 

bold lines final data

 

Note: You can also use VBA code to bold lines.

Bold Lines in Google Sheets

Similar to Excel, you can also bold lines easily in Google Sheets.

  1. Select all the rows you want to bold (1–8).
  2. In the Menu, click the Bold icon (or use the keyboard shortcut CTRL + B).

 

google sheets bold lines

 

The result is the same as in Excel.

 

google sheets bold lines final