Comments on: How to alphabetize tabs in Excel

There is only one method to rearrange worksheets in Excel - drag them to the desired position on the sheet tab bar. When it comes to alphabetizing tabs in a large Excel file, this may be a long and erroneous way. This tutorial shows a couple of time-saving alternatives. Continue reading →

Table of contents

Comments page 2. Total comments: 26

  1. I created a table with the letter "G" in certain cells (one column).
    I'm trying to get a sum of the number of cells with the letter "G".
    Also needing a sum of the cells with the letter "G" that are green in color.

    I have tried several samples I found at your website; ablebits.com with no success.

    Thank you.

    1. Kimosabe:
      Here's how to count the cells that contain "G":
      =COUNTIF(A3:A35,"G") where the G cells are in the range A3 to A35.
      To count the formatted cells you'll need to look at the above discussion and get the VBA solution.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)