Excel usage at work rant
retained text
I’m not an excel pro, but I do know how to use tables, filters, pivots, conditionals, power query just for pdfs, and various formulas. I work with mostly older folks and noticed in my environment that they are mostly just doing data entry and simple formulas like =sum, down a column. On one of our spreadsheets (I primarily update it), I simply froze a column and row as they show what the various data of cells are for and to prevent you from having to always scroll all the way up or to the left side just to remember what the numbers were for. My coworker reviewed my spreadsheet the other day and was confused with why the columns/rows are frozen and how it’s blocking the row above as you scroll down… and how you’re unable to go up as it gets stuck on the frozen row if that makes sense. (She was scrolling with the keyboard rather than the mouse and didn’t know how or remember at the time of how the frozen rows and columns work). There were other complaints of the workbook such as filters being used and how the arrows are blocking the text, highlights of discontinued locations and whatever else data that were still on it from years before my time. She handled it for over a decade prior to turning it over to me, but did mention how she could’ve deleted the gray areas herself. TL;DR Do you work with anyone who barely uses any excel functions and is primarily data entry who also complain of simple things like frozen rows/columns and the filter arrows blocking texts or any similar situations? I just react understandably and try to work around their comfort rather than trying to make them adapt.
document fetched 2026-10-11 00:17 · canonical https://reddit.com/r/Accounting/comments/1x2r5o0/excel_usage_at_work_rant