[How-To] Shrink Excel Text

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: