Use index sheets to quickly navigate in an Excel workbook Your email has been sent Navigating through dozens of sheet name tabs in Microsoft Excel to find the one you need can be quite time consuming.

Microsoft Excel lets you swiftly create a variety of useful records to log sales calls, service calls and other kinds of call information you need to run your business. In just a few minutes, you can ...

Microsoft Excel's VLookup formula permits you to search large spreadsheets for specific data, one of Excel's lookup and reference functions. You can use VLookup between sheets within an Excel workbook ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive ...