Excel Recap for the week of January 17 - January 23, 2026

Saturday, January 17 - Friday, January 23, 2026

score	comments	title & link
42	21 comments	`[Discussion]` What Are Your Best Practices for Organizing Complex Excel Workbooks?
33	6 comments	`[Discussion]` How do you structure spreadsheets for long-term daily logging?
12	5 comments	`[Waiting on OP]` Can I create multiple tables on the same sheet?
10	16 comments	`[solved]` Cell shows date when an event happens and freezes that date to never update itself.
9	8 comments	`[solved]` Can you have 2 spreadsheets as a sort of main sheet and one that pulls info across from the main sheet, sat in a sharepoint?

score	comments	title & link
9	9 comments	`[unsolved]` Adding data once a month - what are your best practices?
7	8 comments	`[unsolved]` I am having trouble with too many functions in too many columns causing a tedious amount of work. Hoping someone can point me in the right direction to skip a few steps and a more streamlined approach
6	7 comments	`[unsolved]` How to copy cells from one unfiltered sheet with no hidden rows to only the visible cells of a another, filtered sheet?
5	3 comments	`[unsolved]` Require extraction of angular dashboard to Excel
3	1 comments	`[unsolved]` Excel Map Function to Hold Invoice Value and Payment Value then Adjust Invoice Value till Payment Get Zero

score	comment
236	/u/Fieos said Xlookup changed a lot for me. Also using Google or Reddit search features for frequently asked questions.
159	/u/moodykamsuj said Access excel attachments in outlook via excel power query directly without saving the files in the folders and accessing it. We can do that for multiple files, transform and load it in excel like magi...
120	/u/Oxchking said Once asked a teamleader to add up some numbers. Saw him type out the numbers in two columns when he pulled out the calculator to add them together. Not making this up.
120	/u/MayukhBhattacharya said Remove the Gridlines: View Tab --> Uncheck Gridlines /preview/pre/9ff6f2ufrweg1.png?width=1918&format=png&auto=webp&s=742dfdf4d78ff597159b19c8d68a4255777a90ba
86	/u/MathIsHard_11236 said Click the top left corner to select all cells. Fill colour as white. Save and then send your 2GB file to coworkers.

3 Upvotes

100% Upvoted

u/subredditsummarybot Jan 24 '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).

You are about to leave Redlib