Google Spreadsheet is commonly used to manage and collaborate complex spreadsheets over web. A lot of people use it for publishing tabular data on the web.
The publish on web feature of google spreadsheet makes the whole spreadsheet available on web for anyone to access. Sometimes it is required to hide a few rows that are not really need to be seen by public.
One way is to manually copy the data from one spreadsheet to another and then share it. However this approach will require you to maintain all changes at two different places.
In this simple tutorial we are going to show how you can selectively share a row of a sheet and without maintaining two different sheets.
For the ease of this tutorial we have used small data however this can be easily done for any large spreadsheet.