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.
Many people know that you can select the whole sheet with Ctrl + A but there are lots of other selections it can perform.
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.
I use Alt key shortcuts a lot when I am working and I have found a couple more useful ones.
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.
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.
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.
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?
When you become more advanced with macros and VBA programming (Visual Basic for Applications), you realise that you can create re-useable macros.