Title: Preselecting Columns
Last modified: August 22, 2016

---

# Preselecting Columns

 *  Resolved [Lady Phoneix](https://wordpress.org/support/users/lady-phoneix/)
 * (@lady-phoneix)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/preselecting-columns/)
 * I am trying to publish a paint conversion chart to convert hobby paint manufacturers
   codes from one brand to another.
    Unfortunately there are so many brands that
   the width of the date makes the page look awful.
 * Im aware that the user can select columns using the show/hide columns (Which 
   is an excellent feature) but is there any way to preselect the columns so that
   the data is more compact
 * For example, lets suppose we have 10 manufacturers listed from 1-10
 * The data is preselected to show manufacturer 1 and 2 but hide 3-10
 * The user can then, for example, turn off manufacturer 2 and turn on manufacturers
   5 and 9.
 * Any help appreciated, other than that this seems an excellent plug in and I can
   certainly get some good use out of it
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/preselecting-columns/#post-5464305)
 * If I understand correctly, you want to know [how to show/hide columns programmatically when the table first loads](https://www.datatables.net/examples/api/show_hide.html)?
   As described in the DataTable docs I just linked, you’ll need to use some JavaScript
   to customize the display of your table; a good place to put your custom JavaScript
   code is in your blog’s active theme (or a [child theme](https://codex.wordpress.org/Child_Themes)
   if you don’t have one already).
 * If you are certain you don’t want to show a specific column or set of columns
   _at all_, as in, to make sure they will never load in the HTML of your page, 
   you can use the `query` parameter in the `gdoc` shortcode this plugin provides
   to preprocess your table with [a SQL-like syntax described by Google here](https://developers.google.com/chart/interactive/docs/querylanguage).
 * Hope this helps. 🙂

Viewing 1 replies (of 1 total)

The topic ‘Preselecting Columns’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/)
 * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/preselecting-columns/#post-5464305)
 * Status: resolved