![Meet the Family: Find a Formula’s Relatives with Ctrl [ and Ctrl ]](https://thetechmentors.com/wp-content/uploads/2026/10/excel-trace-precedents-dependents-1080x675.jpg)
by Tom Chandler | Oct 12, 2026 | Keyboard shortcuts, Spreadsheets
Meet the Family: Find a Formula's Relatives with Ctrl [ and Ctrl ]=====================================================================RANK MATH SEO (copy into the Rank Math panel in WordPress) SEO title: Excel Ctrl [ and Ctrl ]: Trace Precedents and Dependents Fast...
by Tom Chandler | Jul 30, 2026 | Spreadsheets, Keyboard shortcuts, Presentations, Tips, Word Processing
The pioneers who crossed the plains toward Utah, Oregon, or California didn't have the luxury of a shortcut. Every mile was earned — on foot, over months, often without knowing exactly how much further the trail would go. You, on the other hand, have a computer. And...
by Tom Chandler | Jul 1, 2026 | Keyboard shortcuts, Tips
Picture this: it is the night of April 18, 1775, and Paul Revere needs to warn the countryside that the British are marching. Now imagine if, instead of riding from house to house, he could have instantly jumped between every household in the colony with the press of...
by Tom Chandler | Feb 16, 2021 | Keyboard shortcuts, Presentations, Word Processing
Have you ever had a list where EVERYTHING WAS ACCIDENTALLY ENTERED IN UPPER CASE? oR wORsE It WaS All miXed uP. Of course, you want to fix it, but what is the fastest way to do it? In this blog post we will show you how to do it quickly in Microsoft Word, PowerPoint...
by Tom Chandler | May 30, 2020 | Keyboard shortcuts, Spreadsheets
Have you ever had a need to quickly fill in the blanks of a spreadsheet? For example, suppose you need to fill in all the blank regions, store names, and order numbers with the value from the previous cell as shown in the image above. It is true you can “easily” fill...
by Tom Chandler | May 25, 2020 | Keyboard shortcuts, Spreadsheets
When I teach an Introduction to Excel course, I challenge my students to a race, and then I cheat. I first teach them about the arrow keys: the down arrow moves the cursor down one cell, and the up arrow goes up, and the left and right arrows go left and right. We...
