Luis | search
Click here to view Luis news from 60+ newspapers.
Bookmark or Share- Worksheet compatibility issues - Microsoft SupportBefore you save an Excel workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or incorrect functionality. Excel's Compatibility Checker can help you identify potential issues.
- Assign a macro to a Form or a Control button - Microsoft SupportYou can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. Both these buttons are also known as a push button, which can be set up to automate the printing of a worksheet, filtering data, or calculating numbers.
- Formula compatibility issues in Excel - Microsoft SupportWhat to do In the Compatibility Checker, click Find to locate cells that contain array formulas that refer to another worksheet, and then make the necessary changes to avoid #VALUE! errors. Some formulas contain arrays with more elements than are supported by the selected file format.
- Unhide the first column or row in a worksheet - Microsoft SupportTo select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER. On the Home tab, in the Editing group, click Find & Select, and then click Go To. In the Reference box, type A1, and then click OK. On the Home tab, in the Cells group, click Format.
- Video: Embed and link to files - Microsoft SupportHow to take an Office document or object and link or embed it into another document.
More
