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 – The Art of Rubber Banding
This fast tip demonstrates how to use an efficient mouse selection technique. Download Sample Files
Fast Tip Friday – Cut Out Sections of a Screenshot
We create a lot of screenshots in litigation support. We use a number of different software tools to create the screenshots. My favorite is Snagit. This fast tip demonstrates one of my favorite Snagit features and I provide some examples of why I use it. For reference, you can read my previous Snagit article.
Fast Tip Friday – Editing the Same Word Across Multiple PDF Files
This fast tip demonstrates how to perform a search and replace across multiple PDF files using Adobe Acrobat. This feature is available in both Acrobat XI and DC.
Fast Tip Friday – Identify Unsearchable PDFs Within Folders
This fast tip demonstrates how to use a free tool called Count Anything to identify which PDF files are unsearchable. Sean O’Shea shared this tip in his article entitled Where Are My Unsearchable PDFs. Source: Sean O’Shea
Fast Tip Friday – Greatly Reduce Time Copying Gigabytes of Data to Server
This fast tip demonstrates how to greatly reduce the amount of time it takes to copy gigabytes of data from a local drive to the server. Source: David Carns
Fast Tip Friday – Search and Highlight and Extract Pages
This fast tip demonstrates how to use an Adobe Acrobat action to perform searches across multiple PDF files, highlight all of the terms and extract the pages that have hits highlighted. The highlight colors available to use in the javascript are listed below: color.transparent color.black color.white color.dkGray color.gray color.ltGray color.red color.green color.blue color.cyan color.magenta color.yellow…
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.