Category: Excel VBA

grouped sheets warning 3

Warning For Grouped Sheets

If you select more than one sheet in a workbook, and start typing or formatting, that data  or formatting will be entered in all the selected sheets, not just the active sheet. That’s a...

superscript in cell 5

Change Characters to Superscript

Do you ever use the Subscript or Superscript fonts formats in Excel? Maybe you’re reporting on chemical usage, and you need to enter CO2 as one of the row headings. In Word, you can...

headers on combo box 0

Headers on Excel Combo Boxes

You can use combo boxes to show a drop down list, either in a UserForm, or on a worksheet. Sometimes a list is easy to understand, like this one, which shows a part number...