Contextures

Contextures News

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.

Keyboard Shortcut Problem

You can use Excel keyboard shortcuts to hide rows and columns.

  • To hide columns for selected cells: Ctrl + 0 (zero)
  • To hide row for selected cells: Ctrl + 9

I had a problem though, when trying to unhide columns -- the shortcut didn't work:

  • To unhide a column, select cells on either side of the hidden column, then Shift + Ctrl + 0 (zero)
  • To unhide a row, select cells on either side of the hidden row, then Shift + Ctrl + 9

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.

Favourite Commands

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:

  • Right-click the Ribbon, and click Customize the Ribbon
  • At the bottom right, click New Tab -- that creates a new tab and new group that you can rename. Mine is "DD", shown below.
  • At the top left, from the "Choose commands from" drop down, select a category, such as "Commands Not in the Ribbon"
  • Select a command in the list, then click Add, to put it in your new group.

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.

custom tab on ribbon

Excel Articles

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)

Also see: My Excel Products || Excel Events

Discount Ending

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)

Power BI Webinar

Name That Gadget

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.

weekly photo

That's it for this week! If there are topics that you'd like to see covered in future emails, please let me know.

Debra
ddalgleish @ contextures.com

P.S. You can choose to get the full Contextures news package (news and occasional special announcements), or the basic news package (news only). Click either link to change your news option.

Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: March 15, 2017 11:57 AM