# show/hide columns selection doesn't persist

**URL:** <https://forums.toadworld.com/t/show-hide-columns-selection-doesnt-persist/30453>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 14, 2014, 11:09am UTC](https://forums.toadworld.com/t/show-hide-columns-selection-doesnt-persist/30453 "2014-07-14T11:09:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![merickso](https://avatars.discourse-cdn.com/v4/letter/m/e79b87/32.png) [@merickso](https://forums.toadworld.com/u/merickso)\
**Post date:** [July 14, 2014, 11:09am UTC](https://forums.toadworld.com/t/show-hide-columns-selection-doesnt-persist/30453/1 "2014-07-14T11:09:46Z")

</div>

When in schema browser, I select only a few columns to display in the grid, but when I change the filter or navigate to another table and come back, all of the columns are displayed again.

Toad version is 12.1.0.22

How do I get my column selections to persist?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 14, 2014, 11:17am UTC](https://forums.toadworld.com/t/show-hide-columns-selection-doesnt-persist/30453/2 "2014-07-14T11:17:16Z")

</div>

Main menu -\> View -\> Options -\> Schema Browser -\> Data Tab -\> (RHS) -\> Save Layouts.

Check it. and column selections, order, & widths will persist.

---

<div class="post-metadata">

**Author:** ![jsilver](https://avatars.discourse-cdn.com/v4/letter/j/b19c9b/32.png) [@jsilver](https://forums.toadworld.com/u/jsilver)\
**Post date:** [March 22, 2016, 10:39am UTC](https://forums.toadworld.com/t/show-hide-columns-selection-doesnt-persist/30453/3 "2016-03-22T10:39:10Z")

</div>

Hi, I’m using Toad for Oracle 12.1.0.22. I’m running into the same issue. The ‘Data tab - Save Layouts’ works sometimes, not always.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 22, 2016, 11:09am UTC](https://forums.toadworld.com/t/show-hide-columns-selection-doesnt-persist/30453/4 "2016-03-22T11:09:39Z")

</div>

If I recall correctly, in older versions, there were certain actions that should have made the grid save its state but didn’t. If you just toggle a column visibility or moving it to a different position and it doesn’t persist, try also manually resizing a column slightly, and I think that will do it. Or upgrade to the newest version of Toad. This has been fixed.

---

<div class="post-metadata">

**Author:** ![jsilver](https://avatars.discourse-cdn.com/v4/letter/j/b19c9b/32.png) [@jsilver](https://forums.toadworld.com/u/jsilver)\
**Post date:** [March 22, 2016, 11:27am UTC](https://forums.toadworld.com/t/show-hide-columns-selection-doesnt-persist/30453/5 "2016-03-22T11:27:22Z")

</div>

Thanks John, your suggestion worked! I simply resized one of the columns and the settings were saved.
