- Home
- shortcuts
How To Add Macros To Custom Toolbar
Having trained a variety people and helped others with macros, especially in Excel, I have noticed a common issue – assigning keyboard shortcuts to the most regularly used macros. Ctrl along with most of the letters are already assigned as shortcuts, by assigning for example Ctrl and B to your macro, this overwrites the […]
Continue readingA Quicker Way To Create VLookUps Across Multiple Columns
Recently I have been asked by a few people for a quicker way to create VLookUps across multiple columns. In each case the user wanted a VLookUp to pull in several columns of data, but did not want to have to create a VLookUp for each column (one case would have been over 20 columns […]
Continue readingOne button that will boost your personal efficiency
Top Fives I have a faint memory of reading about a statistic regarding how much men like lists (top 5 lists, top 10, etc). At the time I remember believing it to be true because a lot of my friends and I were constantly comparing top fives of pretty much everything. But, this statistic was […]
Continue readingExcel Tip : Ctrl And Arrow Keys
One of the keyboard shortcuts that I use most often in Excel allows you to quickly move around big spreadsheets by jumping to the start, end, top or bottom of the table. It is also the basis for some of the most repeated VBA Macro code snippets that I use. There are 8 shortcuts […]
Continue readingNavigating Tabs Shortcut
This tip is aimed at those of you who use keyboard shortcuts, or are interested in trying them out. A lot of people may already be familiar with using the Ctrl key and a lettered key for shortcuts (Ctrl+B for Bold, Ctrl+I for Italics, etc.), another really useful Ctrl shortcut is Ctrl+PgUp/PgDn. Combining the Ctrl […]
Continue readingStyles In Word
Note : This applies to MS Word 2010 and later. For earlier versions of Word the steps involved maybe different. Styles in Word allow you to quickly format sections of your document – headings, subheadings, paragraphs, indents, etc. When putting together a large document, I use the Styles mostly to highlight headings and subheadings. One […]
Continue readingThe Scroll Button
If you are using a mouse with your computer/laptop you may already be familiar with the left button and the right button, but do you use the middle button much? Talking to different people at different levels of computer skill, I was surprised by the number that did not use the middle button, or know […]
Continue readingContext Menu Shortcut
This tip is aimed at people who already use keyboard shortcuts or are looking to try them out. You may already have noticed that when you use the right-click button on your mouse you get a different menu on screen depending on what you are clicking on. This is a context menu, if you right-click […]
Continue readingWhen a shortcut’s not a shortcut
A shortcut is only a shortcut when it’s a shortcut. There you go, the shortest blog ever!! Want me to expand? My computers are set up with customized quick access tool-bars, quick launch bars and macros linked to shortcuts to help me work faster. I frequently keyboard shortcuts (Ctrl + C to copy for example) […]
Continue reading