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...]

Integrating Google Forms in a WordPress Site [Following up requests]

I've had two requests in the last week for the following: "How can we have a form that people can use to request a copy of a download, and then we can follow up later? I just want to use a spreadsheet." There are a number of autoresponder-type systems that allow you to create a form, where a mailer is sent day 0 (when they sign up) and then follow up emails are sent on the days that you specify … [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...]