9
TIL my coworker's one comment about my spreadsheet formatting actually saved me hours every week
She pointed out I was using merged cells instead of center across selection, and now my data doesn't break when I try to sort it, has anyone else had a simple formatting tip completely change their workflow?
3 comments
Log in to join the discussion
Log In3 Comments
spencer_owens5825d ago
Oh man, my buddy actually had this exact same thing happen to him last year. He was building out this massive sales tracker and had merged cells all over the place because he thought it looked cleaner. One day his manager tried to sort the data alphabetically and everything just got jumbled into a complete mess, like names were matching wrong numbers and totals were all over the place. He spent like two hours trying to fix it before someone finally told him about center across selection. Now he tells everyone he trains to never use merged cells, calls it the number one rookie mistake in Excel. It's wild how one little tip can just unlock a whole new level of efficiency, feels like learning a secret handshake or something.
6
the_wesley25d ago
@spencer_owens58 it's like realizing most "hacks" in life are just avoiding common sense mistakes.
2