As a small business owner, you will often have to work with others on an Excel worksheet. For example, if you have hired a sales or marketing consultant, you can give them an interactive worksheet for ...
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 ...
Combine the navigational features of hyperlinks with the organizational capabilities of a table of contents, and you get a powerful new way to manage large Excel workbooks. You can create an Excel TOC ...
In the January column (page 82) a reader asked how to display 36 workbook tabs in Excel. We described several solutions, but reader Mary Jo Gruber, a CPA with a St. Louis public school district, ...
If you're not using these worksheet-related tricks, you're working harder than you have to! Susan Harkins shares five of her favorites. We all have features and commands that we use more than others.