JR's Garage

Home

❯

My Excel best practices

My Excel best practices

Apr 26, 20261 min read

  1. Log statuses in columns, don’t use formatting as data
  2. Minimize the inputs that maximize the outputs
  3. Reference (almost) the entire column in formulas
  4. Never merge cells, use center across selection instead
  5. Never overwrite data from an external source

  • topic/excel
  • admin/collection
  • type/writing

Graph View

  • Follow via:
  • Changelog emails
  • Bluesky
  • X
  • Reddit
  • GitHub

Created with Quartz v4.5.2 © 2026