Let's Talk Excel
Nine little known Excel facts in a quiz
  • February 13, 2015

    It’s Friday the 13th, so a perfect day for an Excel quiz 🙂

    VBA Code to list files from a folder containing a string
  • February 6, 2015

    The code bellow asks for a folder location, and then for a string. Then it searches through the files in that folder and returns a list of those, that contain the given string. At this point, it ...

    Save Each Excel Sheet To A Separate File
  • January 30, 2015

    This VBA code saves each Worksheet in the active Excel Workbook to a separate file and even lets you decide whether to keep the formulas on the sheets or change them to values. When you run the ...

    Open All Excel Files In A Folder
  • January 23, 2015

    This is a short but sweet VBA code that let’s you open all Excel files in a folder without having to select them all. The code asks you for a folder location and it does the rest :). At the ...

    Create a new Custom List from selected Cells
  • January 16, 2015

    Custom lists are very useful in Excel because they are a quick way to get multiple entries into cells and sort pivot tables in the desired manner. They are constantly used to get a sequence of ...

    Copy Excel Sheet Print Settings To all Sheets
  • January 9, 2015

    Imagine having many Sheets in a workbook. Now you would like all of them to print in a same way. Let’s say with the same header and footer. Many people do this by selecting all the sheets ...

    Sorting Sheets by name or tab color
  • January 2, 2015

    This is a functionality that is missing from Excel and can only be achieved by VBA code. Two such samples are listed below. The first will allow you to sort sheets alphabetically in Excel. The ...