Google Sheets

google

http://www.sitepoint.com/interactive-javascript-charts-using-data-from-google-sheets/
https://ctrlq.org/code/19989-convert-excel-vba-macros-to-google-sheet
https://zapier.com/blog/google-apps-script-tutorial/

How can we freeze a header row or column?

  1. Open a spreadsheet
  2. Select a cell in a row or column you want to freeze.
  3. Open the View menu.
  4. Hover over Freeze.
  5. Select one of the options to freeze up to ten rows, or five columns. You can also choose Up to current row (or Up to current column) to freeze the rows or columns before a cell you've highlighted.

How can we unfreeze a header row or column?

  1. Open a spreadsheet
  2. Select a cell in a row or column you want to unfreeze.
  3. Open the View menu.
  4. Hover over Freeze.
  5. Choose either No rows or No columns to unfreeze your rows or columns.

How can we merge cells?

  1. Select the cells that we want to merge
  2. At the top, click on the arrow next to the "Merge cells" icon and select "Merge all"

How can we unmerge a merged cell?

  1. Click on the merged cell
  2. At the top, click on the arrow next to the "Merge cells" icon and select appropriate option.
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License