Excel Spreadsheets

Question

In an Excel spreadsheet how do I increase the size of the font for the Row numbers and the Column letters so that I can see them the same size as the fonts in the spreadsheet

Answer 1

Hi Rin- L

I have followed your suggestion in part but was unable initially to access the drop-down box with the modify function. I had to right click on all the custom styles of which I had about five versions and change each of them to the same font and then finally when I right clicked on the Normal in the Good, Bad and Neutral heading I was able to get the drop down box with the modify function in it. I then modified the font so that it was the same as all the 5 Normal versions I had. The Row and Column headings then changed to what I had specified. Finally success.

However one small further question is do I need all the different Normal styles. I have now made the font the same in all, but I am worried that if I get rid of these alternatives I may affect previous workbooks and spreadsheets I have produced.

Answer 2

Hi @John Thomas, 

I think I see what’s happening here. It looks like you created a new cell style, so it’s only being applied to the cells you selected. That’s why you’re not seeing any change to the row numbers or column letters, and it also won’t automatically carry across the entire worksheet. 

Coming back to your original goal, if you’re looking to make the row numbers and column letters larger, as I mentioned in the previous response, Excel unfortunately doesn’t offer a separate setting just for those elements. They always follow the workbook’s default formatting, which is controlled by the Normal style, so adjusting that is still the most reliable way to achieve what you’re after. 

If you can open that window, you can follow the same steps I shared earlier: find and right-click on Normal, choose Modify, click Format…, go to the Font tab, then pick a larger font size and confirm with OK twice. That should scale both your cell content and the headers together. 

If anything in those steps or in my explanation feels unclear, please feel free to reply, I’m more than happy to clarify further.

Answer 3

Good day @John Thomas, 

Thanks for sharing your question. I’m really glad to help and happy to share what I know about this. 

By design, Excel doesn’t provide a separate setting specifically to increase the font size of the row numbers (1, 2, 3) and column letters (A, B, C) independently from the worksheet content. These headers always follow the font and size defined by the Normal style, which is also tied to the workbook’s default font settings. 

So, to make them larger and consistent with your worksheet content, you’ll need to adjust the Normal style. Here’s how you can do that:  

• Open the Excel file you’d like to modify 
• Go to the Home tab, then look for the Styles group 
• Right-click on Normal and choose Modify 

• Click the Format… button, then go to the Font tab
• Choose a larger font size, then click OK, and OK again 

Once applied, you’ll notice that both your cell content and the row/column headers will increase in size throughout that workbook.

As a quick note, since I’m a moderator and not part of the product development team, I see things very much from an end-user perspective like you. If you feel Excel would benefit from having a separate setting just for header font sizing, I’d definitely encourage you to share that idea through the official feedback portal here: Excel · Community  

That channel goes directly to the product team, so your suggestion can be reviewed for future improvements. If you do submit feedback, feel free to drop the link here. I’d be more than happy to support it with a vote to help increase its visibility. 

Thank you so much again for taking time to read my response.  

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.