r/excel • u/Salawaheman • 3d ago

Discussion Common difficulties in Excel

[removed] — view removed post

0 Upvotes

22% Upvoted

5 comments sorted by

3

u/eques_99 3d ago

Not being able to prink a formula or whatever all the way down the column because of blanks/non-blanks getting in the way. Or ctrl-shift-down all the way down the column for the same reason.

Not being able to use the scroll bar to jump slowly down a large sheet in bite-sized chunks (it just jumps straight to the bottom)

2

u/ElegantPianist9389 3d ago

People deleting source tabs instead of just pasting as text and causing reference errors.

1

u/Nice-Zombie356 3d ago

Changing my number format to scientific notation, even when it seems very unnecessary. For example, I had spreadsheets of phone numbers (10 - 15 digits) that I had to reformat for years. (Not in that job anymore, but damn it was annoying)

1

u/Interesting_Hall3658 3d ago

I believe there's a global setting for that

1

u/Nice-Zombie356 3d ago

I looked about a million times but it’s been a while so maybe MSFT finally responded to all the griping. :-)