Wikipedia:Reference desk/Archives/Computing/2020 June 29

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

June 29

Excel Find and Replace

Hi, does anyone know how to anchor the find and replace box in place in Microsoft Excel? It jumps around constantly when editing cells near it or scrolling past it. Libre Office allows it to be anchored to the toolbar, but Excel doesn't have that function as far as i can see, and using Libre Office isn't possible in this situation. Thanks ツ Jenova20 ^(email) 08:21, 29 June 2020 (UTC)

Why do you want to anchor it? Are you trying to click it with the mouse? Have you considered using keystrokes to control it instead? Elizium23 (talk) 09:16, 29 June 2020 (UTC)

I need it on screen because i use it every few minutes and opening and closing it regularly would be tedious. The cells i'm searching for sometimes end up under the box and so it spazzes out and moves somewhere else. This is annoying as it happens so regularly. With Libre Office at least the find box can be positioned in the toolbar so this doesn't happen. Thanks ツ Jenova20 ^(email) 10:00, 29 June 2020 (UTC)

As Elizium is implying, it will be much easier if you use keystrokes. Ctrl+H to bring up the box, type the thing you want to remove, tab, type the thing you want to replace with, Alt+A to replace all, escape to close the box. If you have multiple commands, you can Shift+Tab a number of times to get back to the first blank (what you want to remove), but I've found it easier to escape out of the box and bring it back up again: just two keystrokes needed, not several. Nyttend backup (talk) 02:04, 5 July 2020 (UTC)

I doubt this will help you, but for some perspective: A truly excellent, streamlined search-and-replace function (which it sounds like is what you're looking for here) is depressingly rare among modern computer applications. With some regularity I have found it necessary to save a file in a text format (for Excel this would be CSV), open the text file in GNU emacs, do my query-replace there, save the file, and finally open it up in the original application again. This is a monumental nuisance, to be sure, but if it makes the difference between a painful, error-prone, hourlong session using a crappy query/replace feature, versus five minutes in emacs, sometimes it's worth it. —Steve Summit (talk) 13:55, 5 July 2020 (UTC)

I could do that with Ctrl + F, but i was just hoping there was a way to anchor it or stick it in the toolbar somewhere. Thanks for the reply ツ Jenova20 ^(email) 14:00, 6 July 2020 (UTC)

Animated image swinging in sync with music

What is the typical or simplest software to make videos with an animated or static image swinging, bouncing or wobbling to the music beat (not randomly, as some online programs offer)? Roughly similar to this. Brandmeister^talk 09:50, 29 June 2020 (UTC)

Archive all the urls of a website to WaybackMachine (https://web.archive.org/) so that it can always be used for references

The Oxford English Dictionary website offers the entries of the dictionary online, just by counting numbers in the final numerical expression in its URL: https://www.oed.com/oed2/00000001, https://www.oed.com/oed2/00000002 ... the last url being https://www.oed.com/oed2/00291601.

Surprisingly enough, https://web.archive.org has not yet archive them all, and I'd like to know how I can do/request so. That archive could then be used for references.

I've found a possible solution for Linux, so but how can it be implemente on Windows 7? https://webapps.stackexchange.com/questions/115369/how-to-archive-the-whole-website --Backinstadiums (talk) 15:24, 29 June 2020 (UTC)

You can boot to Linux from a thumb drive on any Windows machine without it making any changes to tour hard disks. Remove the Thumb drive and reboot and you are back to Windows. See Tiny Core Linux. --Guy Macon (talk) 22:29, 29 June 2020 (UTC)

And you can also get versions of wget that work under windows. You can however get into trouble with file names, upper and lower case, or weird unicode characters. Graeme Bartlett (talk) 12:28, 2 July 2020 (UTC)

Recording microphone and system mix simultaneously

Hi. Audacity is unable to record both the microphone input and the system mix. Windows 10 audio recorder is able to do it but fiddling with the levels of it can be really touch and go. Strangely enough, I am able to use streaming OBS studio as a workaround. I record video and then convert it to a sound file and viola! I have both mic and the computer's sound. My ultimate goal is to record my voice speaking and the audio of a telephone call from Google Voice.

The work around solution is time consuming and annoying. Can anyone please suggest a program that'll simply do it for me? Preferably freeware but I wouldn't be against paying for a program if it was guaranteed to work the way I want it to. Many thanks. Roseychicken (talk) 17:20, 29 June 2020 (UTC)