Technology Insights

Google Docs Spreadsheet: Have One Row Always Display At The Top Of The Spreadsheet

Earlier tonight I was working on a spreadsheet with thousands of rows and over a dozen columns so I kept forgetting which column was which when working down inside the spreadsheet. I knew there was a way to have a a single row or multiple rows always display at the top of the spreadsheet but was not sure exactly how and I was unable to find the option in the Google Docs Spreadsheet drop downs. I finally figured out how to have a set number of rows always display at the top of a Google Spreadsheet and have shared the information below.

Technology Errors

Google Spreadsheets: You can’t access this spreadsheet because it is in violation of our Terms of service

About 30 minutes ago we started having trouble accessing Google Spreadsheets that were located on Google Docs. The error displayed stated that the issue was related to something in the spreadsheet violating the Google Terms of Service but the same content has been in the document for some time. Below is an image of what the error from Google states when attempting to access the document.

Technology Insights

Google Docs: Add Background Color To Every Other Row On a Google Spreadsheet

Google Docs is a great tool for storing spreadsheets and other documents because it provides an centralized storage space for all of your documents which can be shared with users and accessed from any where that has an Internet connection. One thing that can be really helpful when creating a Google Spreadsheet is having a unified format to the entire document. A format that can assist in making the data in the spreadsheet easier to read is alternating colors for every row. This way if you have lots of columns per row you can easily see which data belongs to each row. The directions below explain how to set up formatting for two rows and then apply that formatting to the rest of the Google spreadsheet.

Technology Insights

Use Microsoft Excel to Populate Cells on a Second Worksheet in the Same Workbook

If you have an Microsoft Excel workbook with multiple worksheets that contain similar type data it may save you a lot of time to auto populate the other worksheets with the similar data. In my scenario I had a form used to obtain information about customers which needed to be in a certain format but then I had two other forms that had some of the same data that needed to be provided to other departments. So the initial process was to fill out each individual form by hand and send to the proper department. To save time I wanted to auto populate as many like fields as possible.

The resolution ended up being really simple. First I just added the other forms to the workbook of the primary form. This ensured that when I opened up the form to enter customer data that the other two forms were open with t. Once I had added the worksheets and named each one properly I started messing around with formulas to complete the task of copying one cell from the primary worksheet to cells on the second and third worksheets in this workbook.