How to display the file name of a worksheet without using a macro in Excel for Mac This article describes how to create a formula that displays the file name of a worksheet in a cell. For example, for a file with the path :Users:local:Desktop, the formula returns :Users:local:Desktop:( )Sheet1 where is the name of your hard disk and...
Find command doesn't work across Excel for Mac worksheets in group When you use the Find dialog box to locate specific information, Microsoft Excel for Mac only finds occurrences of the value on the active worksheet (even if you have selected multiple worksheets that contain this information). If the information is...
Resolving conflicts unhides previously hidden worksheet in Excel for Mac In Microsoft Excel, when you save a shared workbook and resolve conflicts in the workbook, worksheets that previously were hidden may become visible. This problem will occur if a conflict occurs on a hidden worksheet. If a conflict occurs on a...