Title: DIsplay cell value only Last modified: February 7, 2020 --- # DIsplay cell value only * Resolved [marcfest](https://wordpress.org/support/users/marcfest/) * (@marcfest) * [6 years, 4 months ago](https://wordpress.org/support/topic/display-cell-value-only/) * How do I embed inline a single cell’s value without any formatting and styling( such as the shaded box you see around the “7” at [https://elevatorspeechtraining.com/testing-3/](https://elevatorspeechtraining.com/testing-3/)). * My goal is to display something like: “Slots left: 7.”, with “7” being the value fetched from a spreadsheet’s cell. * So I hope to use something like * Slots left: [gdoc key=”[https://docs.google.com/spreadsheets/d/dsfkjfdlasjdsakldaskldjaskldjas/edit#gid=583979524″](https://docs.google.com/spreadsheets/d/dsfkjfdlasjdsakldaskldjaskldjas/edit#gid=583979524″); query=”select B limit 1 offset 1″ class=”no-datatables”]. * Thanks for helping. * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdisplay-cell-value-only%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 8 replies - 1 through 8 (of 8 total) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [6 years, 4 months ago](https://wordpress.org/support/topic/display-cell-value-only/#post-12412901) * You have it exactly right. To retrieve one cell value, a combination of `limit` and `offset` each with an argument of `1` as part of a `query` like you have it in your shortcode is correct. There is no option for printing this value without its containing `` element, though you can easily style that table to be effectively invisible using some simple custom CSS. You’ll want to look into using [`display: inline`](https://developer.mozilla.org/en-US/docs/Web/CSS/display). * See also: * [https://wordpress.org/support/topic/show-value-of-only-a-specific-cell/](https://wordpress.org/support/topic/show-value-of-only-a-specific-cell/) * [https://wordpress.org/support/topic/extract-cell-value-without-table/](https://wordpress.org/support/topic/extract-cell-value-without-table/) * Thread Starter [marcfest](https://wordpress.org/support/users/marcfest/) * (@marcfest) * [6 years, 4 months ago](https://wordpress.org/support/topic/display-cell-value-only/#post-12413155) * Meitar, thanks so much for your response. My goal is to have the cell’s value appear within a line of text without any distracting formatting artifacts. If I style the table to be invisible, wouldn’t it still be problematic to have the value perfectly “fit in” with the surrounding styling? * Also, I saw the reference to gdoc_table_html in the other ticket whose link you provided as a way to reduce the output to “text-only” and the raw cell value. Can you give me or point me to specific information on how to use this hook to modify your plugin to accomplish this? I do have some coding experience, but will be immensely grateful for your help. * All the best, Marc. * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [6 years, 4 months ago](https://wordpress.org/support/topic/display-cell-value-only/#post-12413218) * > If I style the table to be invisible, wouldn’t it still be problematic to have > the value perfectly “fit in” with the surrounding styling? * That is up to you and your site’s code. * > Can you give me or point me to specific information on how to use this hook > to modify your plugin to accomplish this? * [https://www.wpbeginner.com/glossary/filter/](https://www.wpbeginner.com/glossary/filter/) * Thread Starter [marcfest](https://wordpress.org/support/users/marcfest/) * (@marcfest) * [6 years, 4 months ago](https://wordpress.org/support/topic/display-cell-value-only/#post-12413283) * Meitar, thanks for asking what exactly I want to accomplish. If you look at the page below, you can see it. Basically, I want the bolded numbers to be dynamically updated with the data being fetched from specific cells in a Google sheet, and I want the appearance of everything to be as in this example. * I’ll take a look at the wpbeginner.com link you gave me. Thank you again. * [https://elevatorspeechtraining.com/testing-3-2/](https://elevatorspeechtraining.com/testing-3-2/) * Thread Starter [marcfest](https://wordpress.org/support/users/marcfest/) * (@marcfest) * [6 years, 4 months ago](https://wordpress.org/support/topic/display-cell-value-only/#post-12413328) * I found a solution. Your information was helpful. Thanks again. * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [6 years, 4 months ago](https://wordpress.org/support/topic/display-cell-value-only/#post-12413334) * > I found a solution. Your information was helpful. Thanks again. * Great! * Also, on a side note, your communication style throughout this thread was exceptionally good. If this is indicative of your competency with Elevator Speech Training, I think you’ll do very well indeed. * Glad my plugin could help be a part of building out your site the way you want. I hope the solution you found also increases your general skill with WordPress and PHP-based Web development in general. Good luck with all your endeavors. * Thread Starter [marcfest](https://wordpress.org/support/users/marcfest/) * (@marcfest) * [6 years, 4 months ago](https://wordpress.org/support/topic/display-cell-value-only/#post-12413385) * 🙂 * [everydaydatascience](https://wordpress.org/support/users/elitedatascience/) * (@elitedatascience) * [6 years, 2 months ago](https://wordpress.org/support/topic/display-cell-value-only/#post-12657740) * Hi Marc, * Could I please trouble you to provide details on the solution you arrived at? * Thank you. * Ivan Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘DIsplay cell value only’ 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/) * 8 replies * 3 participants * Last reply from: [everydaydatascience](https://wordpress.org/support/users/elitedatascience/) * Last activity: [6 years, 2 months ago](https://wordpress.org/support/topic/display-cell-value-only/#post-12657740) * Status: resolved