Linking Google Sheet Cells Between Sheets (aka Spreadsheets)

This was something I've only done occasionally in Excel since I've started this blog, and never had the need to in Google Sheets - Excel has the capability to link cells from one workbook to cells in another workbook. This is also referred to as an external reference. This usually is done in the format: =[Budget.xlsx]Annual!C10 Where : Budget.xlsx  is the name of the spreadsheet … [Read more...]

Freezing or Unfreezing Rows in Google Docs Spreadsheets

You can freeze up to ten rows or five columns in any particular sheet in Google Spreadsheets. Freezing Columns and Rows Go to the View menu. Then, point your mouse to Freeze rows... or Freeze columns.... Select one of the options. When you scroll, you'll notice the frozen row(s) or column(s). Unfreezing Columns and Rows Go to the View menu. Then, point your mouse to Freeze … [Read more...]