Tag Archives | shortcut keys

How to Find and Replace Something

In the last post, I showed you two ways to quickly find something. But what if you wanted to not only find something, but also replace that something with something else? Well that’s just as easy to do! Let’s use that same data set and go through an example of replacing data. Download the sample […]

Continue Reading 0

How to Find Something

Have you ever needed to quickly find something? Or needed to know how many times a certain word/number/value was used? Here’s how to do it. The fastest way to find something is to use the shortcut key CTRL+F. If you would rather not use a shortcut key, I’ll also show you how to find something […]

Continue Reading 0

How to Quickly Select Data

In today’s post, I want to tell you about three of my favorite navigation shortcut keys. They are: CTRL+ARROW KEY, CTRL+SHIFT+ARROW KEY, and CTRL+SHIFT+END. When I have to move quickly around my spreadsheet, these are total lifesavers. CTRL+ARROW KEY CTRL+ARROW KEY let’s you jump to the end of your data set. For example, if you […]

Continue Reading 0