Shrink cell data

Excel is kind of clever as if you didn’t already know.  Excel will automatically fit your data to your cells by shrinking it.  The data in the cell is fitted within your column width by the reduction of your font size- which then changes with the width of the columns.  Yes clever!

So, if you want to shrink your data into your Excel cells.

  • Select a cell or a range of cells
  • Home Tab
  • Cells Group
  • Format
  • Format Cells
  • OR select CTRL+1 for even quicker navigation
  • Alignment Tab
  • Select shrink to fit
  • Hit Ok to save your settings

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.