# Way to change the formatting of auto-completed columns in SELECT and GROUP BY statements?

**URL:** <https://forums.toadworld.com/t/way-to-change-the-formatting-of-auto-completed-columns-in-select-and-group-by-statements/41190>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [July 19, 2018, 10:37am UTC](https://forums.toadworld.com/t/way-to-change-the-formatting-of-auto-completed-columns-in-select-and-group-by-statements/41190 "2018-07-19T10:37:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![amlloyd](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/amlloyd/32/337_2.png) [@amlloyd](https://forums.toadworld.com/u/amlloyd)\
**Post date:** [July 19, 2018, 10:37am UTC](https://forums.toadworld.com/t/way-to-change-the-formatting-of-auto-completed-columns-in-select-and-group-by-statements/41190/1 "2018-07-19T10:37:20Z")

</div>

Presently, when writing a SELECT (and some others), an auto-complete window pops up and allows you to select the columns you want to include. Then when you select some, and hit Enter, then auto fill onto the same line in the format:

SELECT Col1, Col2, Col3…

Is there a way to change this so it follows my style of:

SELECT Col1  
,Col2  
,Col3

Similar question for GROUP BY auto-completes.

I’m on TDP 4.3.0.718

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [July 23, 2018, 1:22pm UTC](https://forums.toadworld.com/t/way-to-change-the-formatting-of-auto-completed-columns-in-select-and-group-by-statements/41190/2 "2018-07-23T13:22:49Z")

</div>

Select which formatting style you like from format drop down. Then press tool button for formatting to apply.

 ![formatting.png](https://global.discourse-cdn.com/quest/original/2X/1/1a4487e7accfb6b6f327ddc395804af5a3fd84ef.png)