To make a spreadsheet public:
1. Click Share > Publish. Choose whether to publish to everyone or within the organization. You can also choose to allow others to export the sheet and to hide your formula cells by using the checkboxes provided.
2. Right click on a selected range of cells and click on 'Publish This Range' to publish only a range of cells present within the spreadsheet and choose whether you want to publish internally or externally. Alternatively, click on Data and click on Publish this Range.
3. To view the published ranges, click on Data and click on Manage Published Range.