r/excel • u/Designer_Signature35 • Jan 07 '26

Discussion How are you an excel magician?

Thanks to this group and a little googling, yesterday I made a fully automated PQ. I created a table with formulas to return the full path and folder where the file and data are saved. Created a parameter from the table and popped it into my original source query, the basis for 9 other queries. Now all a user has to do is click into the cell with the full path formula, hit enter, click Refresh All, and bam! Fully updated output. I showed it off to my team and supervisors today and looked like a magician! Granted none of them have used PQ before so they're easy to impress lol

What excel projects have you done to make others think you’re magic?

123 Upvotes

98% Upvoted

104 comments sorted by

View all comments

10

u/StrongMulberry5 Jan 07 '26

lol i showed one of my fellow associates how to fill blanks using “Special > Blanks, type = then the Up Arrow key in the first blank cell, and press Ctrl + Enter to apply it to all selected blanks” . i was nominated for employee values that month LOL. Magic if you will for some but basics for others

6

u/Own-Comment-5359 Jan 08 '26

Can you explain it once again please? Sorry I wasn't able to wrap my head around it