---
title: How to Restore Column Layout Under Spread Input
description: "While inputting data under the Spread Input tab, users may find themselves mistakenly hiding the columns when the intention is just to resize them. The column layout can be restored by following these steps; 1. Click '**Options**' and click '**Program…"
url: "https://mes100.com/docs/how-to-restore-column-layout-under-spread-input/"
updated: "2022-12-05"
category: Troubleshooting / General
---

# How to Restore Column Layout Under Spread Input

While inputting data under the Spread Input tab, users may find themselves mistakenly hiding the columns when the intention is just to resize them.

The column layout can be restored by following these steps;

1. Click '**Options**' and click '**Program Settings**'

  ![](https://i0.wp.com/mes100.com/wp-content/uploads/2022/03/image2-1.png?resize=1080%2C558&ssl=1)

1. Go to '**Layout**' and click '**Reset defaults**'.
2. Click '**OK**'

  ![](https://i0.wp.com/mes100.com/wp-content/uploads/2022/03/image1-1.png?resize=1080%2C555&ssl=1)

### *Related*

 [![](https://i0.wp.com/mes100.com/wp-content/uploads/2024/10/me-small.jpg?resize=100%2C100&ssl=1)](https://mes100.com/author/admin/)[Ngu Soon Hui](https://mes100.com/author/admin/)

I’m the [Benevolent Dictator for Life](https://en.wikipedia.org/wiki/Benevolent_dictator_for_life) for MiTS Software cum Editor of this website. Read more [here](/about-ngu-soon-hui/).

You can also contact me at soonhui@mes100.com