Technofriends

Tim Roth has written me a mail asking for a step by step process to Shrink Excel Text. Tim in his mail writes

I use MS Excel 2003 with text in the cells, and the General format applied. When I change the format of a portion of the text, that part of the text’s font size is reduced. I can manually fix the font size, but I use Excel a lot and this is quite troublesome.

Therefore, for the information of Tim and all other readers of my blog, i am putting below a solution for this issue. Please follow the steps mentioned below.

1. Press CTRL+A to select all.
2. Right-click anywhere in the selection and select Format Cells.
3. In the Alignment tab, uncheck the box Shrink to fit and click OK.
4. If all the text is supposed to be the same size, click the Font tab and set the desired size.
5. Click OK to finish.

Hope this helps.

Also read:

[How-To] Calculate Equated Monthly Installment using MS Excel

Google Code University: Learn programming the Google way

How-To: Create Basic Charts using Microsoft Excel

MS Office Fun: Excel Games

How-To: Copy Excel cells into a Word document

Do stay tuned to Technofriends for more, one of the best ways of doing so is by subscribing to our feeds. You can subscribe to Technofriends feed by clicking here.

Cheers

Vaibhav

Related posts:

1. How-To: Copy Excel cells into a Word document
2. [How-To] Calculate Equated Monthly Installment using MS Excel
3. [How-To] Conditional Formatting Using Microsoft Excel
4. How-To: Create Basic Charts using Microsoft Excel
5. [How-To] Hide “0″ in Microsoft Excel Chart Axis