Skip to content

Google Sheets

Bonnie Wolfe edited this page Apr 18, 2022 · 7 revisions

Google Sheets Hack for LA formatting requirements

Minimum Requirments

Title

  • Should be the initials of the project (e.g. EA: Drive Migration is Expunge Assist's Drive migration tracking spreadsheet)

Create a header row

Create a header row and make it a different color so that it's easy to distinguish that it describes the column

Freezing

  • header row
  • primary column (optional)

Remove extra rows and columns

In order to make your spreadsheets easier to read and navigate, please do some basic cleanup of unnecessary rows and columns

  • Click a corner cell of the range you're wanting to delete
  • Hold CTRL+SHIFT+[arrow key] to select all cells in the row & column, depending on direction, until you hit a cell with a value or the edge of your sheet
  • If your row & column has values, then the selection will stop at the first empty cell or the edge of your sheet
  • Either right click or use Edit menu and delete the selected Row range

Select the arrow to see images:

Before Image

image

After Image

image

Extra

  • Adding logo
    • We often share spreadsheets with our stakeholders, adding the project logo and contact information is always a good idea.
  • Cover page
    • You can use this for instructions
    • Good place to put the logo and contact info
    • Anything else you think would make this spreadsheet next level while not negatively impacting it's performance.