Group (Outline) Data in a Worksheet

When you have a table or record of transactions, some items just repeat don’t they? If they do, sometimes it’s easier to see them when there is some sort of categorization for “like” items. And if you are able to categorize them you may also be able to sum up … Continue Reading →


Use a Dropdown List to Switch between a Table or Chart

  • By Doug H
  • 9 August, 2017
  • Comments Off on Use a Dropdown List to Switch between a Table or Chart

Sometimes you want to see a Table and sometimes you’d want to see a Chart.  How about both?  And have the option to switch between both?  It like having a button to go between a table and chart.  This tip will step you through how to create not a button … Continue Reading →


Use a Dropdown List to Switch between a Table or Chart

  • By Doug H
  • 26 July, 2017
  • Comments Off on Use a Dropdown List to Switch between a Table or Chart

Sometimes you want to see a Table and sometimes you’d want to see a Chart.  How about both?  And have the option to switch between both?  It like having a button to go between a table and chart.  This tip will step you through how to create not a button … Continue Reading →


Customize a Tab on the Ribbon

  • By Doug H
  • 12 July, 2017
  • Comments Off on Customize a Tab on the Ribbon

Are you the type that likes to be unique?  Do you like to customize your phone or desktop screen?  Are there some icons on the tab in the Excel Ribbon that you’d like to change or maybe you’d just like to add more command icons to certain tabs.  Well there … Continue Reading →


Sort Columns or Rows

  • By Doug H
  • 28 June, 2017
  • Comments Off on Sort Columns or Rows

Sorting things is just one of those basic tasks that you’ll find yourself doing quite often in Excel. And you’ll find Excel an excellent tool to sort by ascending or descending order in a column or by rows.  You can even do multiple sorting in a table like sorting by … Continue Reading →