If you see the above image only, the font of the row and column headings has been changed. You will observe the changes in font of row and column headings in your Excel workbook. Open the Excel sheet, go to Page Layout, go to Themes group, select Fonts in that and choose one of the Font you like from the drop-down list. In Excel, you can change the Fonts using the Page Layout to trade solely the font of the row and column headings. Note that you cannot use the 'undo' button in this method.Ĭhange the Font of Row and Column Headings with Font Feature In your workbook, the font and size of your row and column headings have been changed as shown below.

Once you click on the Format a dialog box will pop up in that choose Font, select the desired style and size under the font tab as shown below. In the Style dialog box, click on the Format button as shown below. You can also get this dialog box by pressing Alt+' (single quote) keys from the keyboard. Go to the Home tab, and in the Style group, right-click Normal and choose Modify from the context menu to open the Style dialog. Open the workbook that you want to change its row and column headings font and size.

With the futures we have in the Excel workbook, you can change the font and size of the row and column as you like.Ĭhange the Font and Size of Row and Column using the Styles Feature in Excelįollowing are the steps to change the Font/Size and row/column in excel. When you use the Excel workbook, have you ever tried to alternate the font or measurement of row and column headings to make the headings larger or extra beautiful? In fact, Excel offers some tricks for you to solve this task.

Change excel row to column