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 *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>