Developer: If you write code or create forms and applications for Excel, this is your tab. It also includes macro handling, so power users might also want to visit here every once in a while.

The code name is the sheet’s default name , which Excel assigns when you create it — Sheet1, Sheet2, and so on. Changing the sheet’s name, as displayed on the sheet’s tab, does not change ...

Excel macros use Visual Basic code to perform functions unavailable through the program's graphical controls. For example, macros can extract data from a sheet, perform string operations on them ...

When in an Excel sheet, click the Developer tab, click Macros in the Code group, choose the procedure in the resulting dialog shown in Figure A, and then click Run. Figure A The bare bones VBA code ...

Excel is packed with features spreadsheet ninjas should know, but for a visual reference, save or download one or all of these cheat sheets: 8 Great Tools to Make You an Excel Expert (includes how ...