Use Microsoft 365 View > Navigation to find, rename, or hide sheets in one place, keeping large workbooks tidy and easier to manage.
Once the final version of your Excel workbook or Microsoft 365’s version of Excel Workbook is complete you might want to stop or turn off the workbook sharing in Excel to avert any unwanted changes.
Nothing kills an online Excel presentation faster than sensitive data leaks or disorienting navigation. Here's my pre-flight checklist that ensures my interface is clean, my delivery is seamless, and ...
Nearly every Microsoft Excel workbook I own—especially those I share with others—contains a hidden backend worksheet. It's essentially the engine room of my workbook and helps me keep my spreadsheets ...
The author of a Microsoft Excel 2010 workbook represents the owner of the document. When someone views the workbook properties through the Document Properties or Info panels, the author is one of the ...
Microsoft Excel lets you add two types of buttons to a worksheet: option buttons and toggle buttons. Option buttons, also referred to as radio buttons, let you choose one item from a list. Toggle ...
A macro to unhide all hidden sheets in an Excel workbook Your email has been sent Unhiding Excel sheets is easy, but can be tedious. Use this simple macro to unhide all hidden sheets in an Excel ...
Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...