Things I almost always do in a spreadsheet:
- Freeze the header row.
- Delete unused columns.
- Double-click column widths so the content fits properly.
Things I sometimes do:
- Delete unused rows.
- Increase font size to at least 10.
What do you do in your spreadsheets?
Deleting unused Rows & Columns is something I always do in my own spreadsheets. Freezing header rows I’ll do if it’s past like 50 rows. Even if it’s just me handling the data. Future Doug always thanks past Doug for this.
LikeLiked by 1 person
I freeze the header row and set all cells to fit the content as well! 🙌 I cannot manage sheets without these two settings/changes.
LikeLiked by 1 person
Love these tips; most I already do and appreciate from others. An addition: I set the header row background color to dark, and text color to light to offset it visually.
LikeLiked by 2 people
Ohh, I like that one!
LikeLike