Title: hidden rows
Last modified: August 30, 2016

---

# hidden rows

 *  Resolved [shpeedie](https://wordpress.org/support/users/shpeedie/)
 * (@shpeedie)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/hidden-rows/)
 * Hi,
 * If i hide rows in my google spreadsheet, they seem to be shown via the plugin.
   
   Can you filter them so they aren’t displayed via the plugin?
 * Thanks!
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/hidden-rows/#post-6288736)
 * Yes. This is already in [the plugin’s FAQ](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/faq/).
   Please read it:
 * > **Can I remove certain columns from appearing on my webpage?**
   > If you’re using the “new” Google Spreadsheets, you can strip out columns by`
   > select`ing only those columns you wish to retrieve by passing a Google Charts
   > API Query Language query to the shortcode’s `query` attribute. For example,
   > to retrieve and display only the first, second, and third columns in a spreadsheet,
   > use a shortcode like this:
   >     ```
   >     [gdoc key="ABCDEFG" query="select A, B, C"]
   >     ```
   > 
   > Alternatively, you can hide columns using CSS with code such as, `.col-4 { 
   > display: none; }`, for example.
 *  Thread Starter [shpeedie](https://wordpress.org/support/users/shpeedie/)
 * (@shpeedie)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/hidden-rows/#post-6288763)
 * Thanks, i did read that, but i want to hide rows, not columns.
 * Can this same select method be used for hiding rows?
 * Thanks
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/hidden-rows/#post-6288765)
 * > Can this same select method be used for hiding rows?
 * Yes, of course. Just `select` the rows you want and not the ones you don’t.
 *     ```
       select A, B, C, D where C != 'exclude these rows'
       ```
   
 * Read the [Google Query Language](https://developers.google.com/chart/interactive/docs/querylanguage)
   specification to learn more about how to `select` only the rows/columns/whatever
   you want.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘hidden rows’ 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/)

 * 3 replies
 * 2 participants
 * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/hidden-rows/#post-6288765)
 * Status: resolved