User Profile
mslaurie
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
copy./paste filenames into text of multiple docs?
I have about 70 word documents. Each has a different filename. I need to copy and paste the filename of each file into the text of its document. So a word file called "bio-int 12.docx" would have "bio-int 12" pasted into the top of the text INSIDE that document. Is there a quicker way to do this than opening ea doc. and then copying and pasting that info in?????1.3KViews0likes2Commentssearchable dropdown list
I'm on an imac—os is Big Sur, using Excel 16.43? I think. I've got a 365 subscription. Weirdly, in Google docs its simple to use data validation to set up a searchable dropdown list. Today, I've just spent over an hour online with dozens of tutorials each more complicated and code-heavy than the last—trying to do the same thing in Excel. They all seem to be for much more experienced people than me. Often they show older versions of excel which don't have the same functions. And most of the tutorials are for preparing complicated databases getting info in multiple columns. I have a giant list of categories I use to prepare my taxes. On an excel spreadsheet, I'll show a charge for face cream. The category for that is "personal care." In Google Sheets I just enter the letters, pe and the list opens to show me personal care which I select. It might ALSO show me "pets, or a few other categories. No problem. Instead of 50 choices it's presented me with only 5 or six at most. Is there really no simple way to create a simple but very long SEARCHABLE dropdown list in Excel? Look how easy in google sheets: https://support.google.com/docs/answer/186103?co=GENIE.Platform%3DDesktop&hl=en2.1KViews0likes2Comments
Groups
Recent Blog Articles
No content to show