There is a keyboard shortcut to select the first column in a row, but as far as I know there is no shortcut for the first row in a column.
Tag Archives: shortcuts
Excel Alt key Shortcuts
Short video at bottom of post
The Alt key offers a way to use icons without using the mouse. In some cases, these Alt key shortcuts can be quicker than using the mouse.
Excel Shortcut keys revisited 20 years on
Some things don't change much
20 years ago I had an article published on Excel shortcuts keys – let’s revisit it.
Entering today’s date in Excel
It works in lots of places
You can use a keyboard shortcut to enter today’s date in a cell, but you can also use it in lots of other places in Excel.
Mouse Based Formulas in Excel
Are you a man or a mouse?
Do you hate using the keyboard for formulas? Does having to peck the = or + key to create a formula annoy you? Well there is an answer.
Selecting a single word in Excel
Mouse shortcut
If you are editing a sentence or a heading and you need to replace a single word there is a quick and easy way to do it.
Data Validation Shortcut
Two options
The Data Validation dialog allows you to limit or control what a user enters into a cell. There are two keyboard shortcuts to open it.
Free Excel Webinar Recording – Mouse Shortcuts
Feedback score 93%
When I ran some face to face training sessions recently I was reminded how much people LOVE shortcuts. I did a keyboard shortcut webinar session in October 2018.
In November 2018 I shared lots of mouse shortcuts. Download the materials using the button below and watch the video.
CPD note – if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances.
Some of the topics and techniques you will learn include:
- the various cursor shapes and how to use them correctly
- right clicking options you may not know exist
- copying anything quickly with the mouse, even sheets
- drawing perfect circles and squares
- lining up charts and other shapes perfectly
- cool techniques with the Fill Handle
- something you may never have tried with the right mouse button
- using the Office clipboard
- a trick to use the Series dialog
This session will demonstrate lots of techniques using the mouse and also using the mouse with the keyboard.
Even if you prefer using the keyboard you might learn a few useful new techniques.
Filling a large range in Excel with a series [Video]
Keyboard and mouse shortcuts
Let’s assume you need to fill a vertical range with all the whole numbers from 1 to 100. There are lots of ways to do this, but I think the keyboard could be the quickest.
Selecting All with Ctrl + A
Some other useful techniques
Many people know that you can select the whole sheet with Ctrl + A but there are lots of other selections it can perform.
Following Links in Excel
A Name Box trick
Excel has a shortcut that allows you to follow a link to its source but it has a limitation find out how to get around that limitation.
Alt Key Shortcuts
Two more
I use Alt key shortcuts a lot when I am working and I have found a couple more useful ones.
Excel and Ctrl + A
A powerful shortcut
This Excel keyboard shortcut is powerful, but it has a few quirks you need to be aware of. Its quick to use because the A and Ctrl keys are so close together.
Creating a Hyperlink in Excel Based on a Search
Teleport to a cell in a data table
Let’s say you have a table of codes and every month there are a few you want to check out. You could use a VLOOKUP to extract all the details for each code, but let’s say you want to view the codes in the table.
Excel Full Screen
Maximise your grid area
There are times in Excel when you want to see as much of the Excel grid as possible. You may be reviewing or presenting a dashboard or looking at a large PivotTable. Excel has a Full Screen mode that shows just the grid and the sheet tabs.
Disabling Sheet Unhide in Excel
How to hide a sheet and make it hard to unhide
You can right click a sheet tab and select Hide, but it is just as easy to Unhide the sheet. What if you want to make it harder to unhide the sheet?
VBA macros that run other macros
When you become more advanced with macros and VBA programming (Visual Basic for Applications), you realise that you can create re-useable macros.