Moving around your spreadsheet can be a pain in the neck, depending on how far you need to move, let me share a few tips to speed you up!
We all know that you can move around a spreadsheet using your mouse – simply click on the cell that you want to move to.
But, of course this is a Microsoft product, and we all know that one method just isn’t enough…
Simple (and obvious) methods
Let’s get these out of the way…
Mouse/Scroll Bars
I’ve already mentioned using the mouse to click on a cell to move/select it.
Hopefully, I don’t need to mention that you can use the scroll bars (on the right and at the bottom) to move the sheet in a direction to allow you to click on any cell.
Direction Keys
And of course the other obvious option – the direction keys.
They move you one cell in the direction that you choose – Left, Right, Up or Down.
As I’m sure you know, pressing and holding them down “whizzes” in the direction that you chose.
Home and End Keys
If you haven’t really noticed them before, there are two keys called Home and End on your keyboard.
Where they are can be slightly different, depending on the computer you use – full external keyboard (desktop or laptop), built-in keyboard (laptop), or compact keyboard (Mac, portable keyboard).
However, when you find them (and they are somewhere) then they offer some are useful options when you need them.
Home Key
What it does: Moves you to Column A, while staying in the selected row.
How to use it: Click in any cell, that’s not in column A, and press the Home key.
Doesn’t sound ‘amazing’, but if you’re entering a lot of data, use it on the next line to quickly move to start at the beginning of the row.
End Key
What it does: Moves you to the last cell with data in it.
How to use it: Press the End button (it will show ‘End Mode’ on the Status Bar), then press the arrow in the direction you want to move.
What’s the end of the data?
It’s a good question to ask, as some of these shortcuts take you to the end…
When you’re talking about the end of your data, a spreadsheet defines it as the last cell with information in, before a blank line.
In this example, the data ends at row 23 – because row 24 is blank.
However, if you’re already at the end of your data – then the ‘end’ is the last cell of your spreadsheet.
Moving around with CTRL Keys
The next group of shortcuts use the CTRL Key.
Mac users – replace CTRL with the CMD (Command) key.
GoTo
If you know the cell address that you want to select, then the GoTo command will take you there immediately.
What it does: Move you to a specific cell address.
How to use it: Press CTRL + G to open the dialog box. Type in the cell address and press Return.
Not sure about you, but I don’t usually remember the cell address that I need to move to, so I don’t use it very often.
CTRL + Home
One of the most useful shortcuts to know about moving around, is definitely CTRL + Home!
What it does: Moves you to cell A1.
How to use it: Press CTRL + Home.
CTRL + End
Occasionally this option has it’s moments, but remember what’s defined as the end of your data.
What it does: Move you to the last cell of your data range (i.e. bottom right)
How to use it: Press CTRL + End
Final Tip
As well as moving around your spreadsheet, these can be used to also select cells…
Related Posts
- Why Your Colour-Coded Excel Data Deserves a Better Filter
If you’re already using colour to organise your Excel spreadsheets, here’s some good news — you can filter by that colour too. Excel filter by colour lets you instantly show only the rows that match a specific colour — whether that’s a background fill or a font colour. It’s one of those features that feels… Read more: Why Your Colour-Coded Excel Data Deserves a Better Filter - Excel Paste Values – Get Exactly What You See, Every Time
If you’ve ever copied something in Excel and ended up with a completely different result than you expected, you’ve probably fallen foul of one of Excel’s little quirks. The good news is that once you understand Excel Paste Values, you’ll know exactly how to handle it – and it only takes a couple of extra… Read more: Excel Paste Values – Get Exactly What You See, Every Time - Excel Sparklines: The Tiny Charts Making a Big Difference
If you’ve ever stared at a column of numbers and thought “I just want to see the pattern” — Excel Sparklines are about to become your new favourite thing. These miniature charts sit inside a single cell, right next to your data, giving you an instant visual snapshot without the faff of building a full… Read more: Excel Sparklines: The Tiny Charts Making a Big Difference - Do You Know All the Excel Flash Fill Tricks?
If you’ve ever exported data and thought “why is everything jumbled together in one column?”, Excel Flash Fill is about to become your new best friend. It’s one of those features that looks impressive but is actually really simple to use — and once you know it, you’ll find yourself reaching for it again and… Read more: Do You Know All the Excel Flash Fill Tricks? - The Complete A-Z Guide to Excel Keyboard Shortcuts: Master Your Productivity
When most people think about keyboard shortcuts, Microsoft Word typically comes to mind first. However, as an Excel enthusiast, I’m here to tell you that Excel has its own powerful set of keyboard shortcuts that can dramatically improve your productivity. Today, I’ll guide you through the complete A-Z of Excel’s keyboard shortcuts for Windows users.… Read more: The Complete A-Z Guide to Excel Keyboard Shortcuts: Master Your Productivity
1 thought on “Moving Around Excel – Do you know these shortcuts?”
Pingback: Formatting and it's Impact on Excel Analytics – Michelle Kaye Training Ltd
Comments are closed.