Quickly tidy up a spreadsheet with squashed values

    • iTG Technologies |
    • 0 step |
    • 11 seconds

      Download Sample Sheet

      Download our sample spreadsheet. [https://itgtechnologiesltd.sharepoint.com/:x:/s/SalesandMarketing/ES9mxfF5EU1CibIZn_ZGMHAB4AzSDsbEvtQdajClUaLWWg?e=i02o3E](https://itgtechnologiesltd.sharepoint.com/:x:/s/SalesandMarketing/ES9mxfF5EU1CibIZn_ZGMHAB4AzSDsbEvtQdajClUaLWWg?e=i02o3E) [[File > Save as > Download as a copy]]
      Press [[ctrl]] + [[a]] to select all.
      Tip! You can also press the small triangle in the top left corner of the sheet to select all.

      Selecting Auto-Fit Column Width

      Press and hold down the [[Alt]] key, then type [[H]][[O]][[I]] Alternatively on the 'Home' tab press 'Format' and 'Auto-Fit Column Width'.
      The example document should change to match the below. This is because the HOI command chooses 'autofit the column width'.
      You will notice that because Excel has done this automatically, it hasn't quite got it right! So repeat the steps. Press and hold down the [[Alt]] key, while this key is pressed type [[H]][[O]][[I]]
      That looks much better! 😊The columns are sorted, but the rows still look a little squashed.

      Selecting Auto-Fit Row Height

      Press and hold down the [[Alt]] key and type [[H]][[O]][[A]] Alternatively on the 'Home' tab press 'Format' and 'Auto-Fit Row Height'.
      ✅ You have successfully re-formatted the spreadsheet quickly so all data is organised and displayed neatly! 👏
      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe