The Developer tab holds macros, the VBA editor, form controls and add-ins, but it’s hidden when Excel is installed. Turn it on once and it stays. WindowsFile → Options → Customize Ribbon MacExcel → Preferences → Ribbon & Toolbar Time30 seconds Windows Right-click any ribbon tab and choose Customize the Ribbon (or File → Options … Read more
A very hidden sheet doesn't appear in the Unhide list. You can only hide or show it from the VBA editor, which makes it useful for lookup tables and calculations you don't want users to change by accident. HiddenRight-click tab → Hide; shows in Unhide Very hiddenVBA editor → Visible = 2; not in Unhide … Read more
Excel has three random functions: RAND for decimals between 0 and 1, RANDBETWEEN for whole numbers in a range, and RANDARRAY for a whole grid at once. With them you can make random decimals, dates, picks from a list and numbers that never repeat. Decimal 0 to 1=RAND() Whole number=RANDBETWEEN(1,100) A grid (365)=RANDARRAY(5,3) RAND: a … Read more