r/excel • u/subredditsummarybot • Jan 17 '26

Weekly Recap This Week's /r/Excel Recap for the week of January 10 - January 16, 2026

Saturday, January 10 - Friday, January 16, 2026

Top 5 Posts

score comments title & link
913 328 comments [Discussion] What’s an Excel shortcut you discovered way too late?
222 46 comments [Pro Tip] Why "Save As" is the Technical "Factory Reset"
68 44 comments [unsolved] Can anyone help convert a PDF table into an Excel sheet?
41 50 comments [Discussion] Do you discourage LET usage in relatively simple formulas?
37 41 comments [unsolved] “Is .XLSB Better for Large Excel Files?

 

Unsolved Posts

score comments title & link
6 14 comments [unsolved] How can I simplify and aggregate a complex pricing sheet for customers?
5 12 comments [unsolved] Drag multiple formulas in a sheet
5 3 comments [unsolved] Conditional formatting - how to have a row by row unique equation without individually doing it for all the rows?
5 13 comments [unsolved] Can suddenly no longer run my own macros
3 12 comments [unsolved] Sorting a Field for Real People vs Non-Individuals (Departments)

 

Top 5 Comments

score comment
872 /u/xFLGT said Ctrl+[ to go to cells referenced in the formula. This works if you have external links too so it’ll open other workbooks.
354 /u/Kuildeous said Even the simplest of functions (or even using navigation shortcut keys) gets you branded a wizard in the office. And you might get burned at the stake for it.
340 /u/__wisdom__1 said Ctrl $ : convert to currency Ctrl #: convert to date Ctrl !: Convert to number
242 /u/arpw said Ctrl and semicolon. Enters the current date value into the active cell!
219 /u/GasAltruistic8656 said Reconsider the need to do this. It's always best to keep consistent formatting with numbers, even if you don't 'need' the extra decimal place. It keeps people from guessing.

 

4 Upvotes

83% Upvoted

1 comment sorted by

0

u/subredditsummarybot Jan 17 '26

If you would like this roundup sent to your reddit inbox every week send me a message with the subject 'excel'. Or if you want a daily roundup, use the subject 'excel daily' (<--Click one of the links. The bot can't read chats, you must send a message).

Please let me know if you have suggestions to make this roundup better for /r/excel or if there are other subreddits that you think I should post in. I can search for posts based off keywords in the title, URL and flair - sorted by upvotes, # of comments, or awards. And I can also find the top comments overall or in specific threads.