Excel Shortcut Problem
February 21, 2017
Problem with Excel shortcut, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there.
You can use Excel keyboard shortcuts to hide rows and columns.
I had a problem though, when trying to unhide columns -- the shortcut didn't work:
If you have multiple language keyboards installed, in Windows 7 or later, that shortcut is used to switch keyboards. You can follow the instructions here to change that setting.
You can get a full list of Excel keyboard shortcuts on my website.
Do you have your favourite Excel commands on the Quick Access Toolbar (QAT), so they're easy to use? My QAT is running out of room, so I decide to add a custom tab on the Excel Ribbon. On there, I added commands that I use often, but not every day. It's a good place for commands that aren't on the Ribbon, or are hard to find, such as the Pivot Wizard, and the Data Form.
To add a custom tab:
Remember to export your customizations when you're finished!
You can also create a custom tab that only appears when a specific workbook is active.
Here are a couple of recent Excel articles that you might find useful.
Debt Snowball - On the Life and My Finances blog, download the free debt snowball calculator, to see how it works (no macros). It's interesting to see how someone else tackles a problem in Excel (Level - All)
Excel Chart - Ivan Bondarenko shows how to make a Marimekko chart with Power Query. To do this with normal Excel, there are instructions on my site, and if you have Jon Peltier's Excel chart utility, it has a Marimekko feature. (Level - Intermediate/Advanced)
Power BI: Mynda Treacy is hosting free Power BI Webinars this week, to give you a quick overview of what you can achieve with the free suite of Power BI tools.
Mynda is offering a full Power BI Course too, and if you plan to register, don't miss the 20% discount (ends Thursday Feb 23rd, 8PM Pacific)
I'm still decluttering my office, and have found several interesting gadgets hidden away in the dark corners. Can you identify all of them? Some are easy, but I had to Google one gadget (but not the Google gadget), because I couldn't remember what it was! I'll give you the answers next week.
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 15, 2017 11:57 AM