Fast Tip Friday – Excel Fill Handle Double Click
This fast tip demonstrates one particular way to use the fill handle in Excel.
Source: David Carns
Similar Posts
Fast Tip Friday – Download Web Pages Using HTTrack Website Copier
This fast tip demonstrates how to download pages from a website, in case you need to get a “snapshot in time” of a website for a litigation matter, using free software called HTTrack Website Copier. In a previous tutorial, I demonstrated how to download web pages to PDF using Adobe Acrobat.
Fast Tip Friday – Search and Redact Regex Text Patterns Using Adobe Acrobat
This fast tip demonstrates how to search for custom text patterns using regular expressions and then redact the text. UPDATE: When searching for the XML file locations, you may need to unhide system files before running the search so that you can see this additional location under your user profile: C:\Users\[user profile name]\AppData\Roaming\Adobe\Acrobat\[Acrobat version]\ Preferences\Redaction\ENU. You can…
Fast Tip Friday – Formatting an Excel File as a Trial Exhibit
This is an adaptation of a recent article written by Jeff Bennion for the Above the Law blog. In my legal career, I have formatted hundreds of Excel files for printing, at the request of an attorney who is uncomfortable using Microsoft Excel. I use many of the same steps that Jeff mentions in his…
Fast Tip Friday – Generate Word List From Multiple Files
This fast tip demonstrates how to use a free program called TextStat to quickly and easily generate a concordance (aka word list) from multiple MS Word documents. NOTE: If you have PDF files, you could convert them to MS Word format or text format in order to use this software tool.
Fast Tip Friday – The Art of Rubber Banding
This fast tip demonstrates how to use an efficient mouse selection technique. Download Sample Files
Fast Tip Friday – Hard Disk Space Usage Using Treesize Free
Have you ever wondered what is taking up so much space on your hard drive? Have you ever wanted to get an overview of the file contents that just arrived on an external drive? This fast tip demonstrates how to use Treesize Free to break down hard disk space usage down to the file level.
Good tip, especially with respect to entering the cell range as E2:E24! Spending too much time scrolling around in Excel is a huge time suck.
Thanks Sean. I can’t believe how long it took me to learn the double-click after loving Excel for years. My friend David Carns shared the tip when he learned it. Ha!
I saw you branched out to video and you’re getting subscribers now. Congrats!
Thanks, Amy. The free version of Active Presenter makes it easy to do the videos. I love it.
When I saw your post about it, I took a look and made a mental note to check back later. I already have Camtasia and Screenflow that I use almost every day. But I was able to forward a link to one of my students that asked me a few months about a free tool to record videos for Youtube. She has a project she wants to record videos for.
You are definitely a google search fanatic! I still remember before Google existed and how limited we were in finding answers to everything.
I remember the pre-Google days. Alta Vista seemed great in 1997, but I think if everyone had to go back to the internet of that era they would really be surprised at how limited it was.
Applications like Active Presenter and Screenflow ought to be part of the general business culture. There’s no better way to provide instructions to someone, and it’s almost as easy to do a presentation in these applications as it is to illustrate steps with screen grabs.