Jonatan Silva

How to sign in Excel: insert a Signature Line, sign it with your name or an image, add an invisible digital signature, and remove a signature.

Learn how to add an Excel header and footer with a preset or your own text, such as page numbers, the date, the file name, or a company logo.

Realizing the edits that you’ve been making to a file are all wrong is frustrating. Here’s how to restore the previous version of an Excel file.

Learn how to co author in Excel: save your workbook to OneDrive or SharePoint, share it with your team, and work around the feature’s limitations.

Use the INDIRECT function Excel provides to turn text into a cell reference. See the syntax and examples with SUM, AVERAGE, ROW, and other sheets.

Need a Google Sheets link to another sheet? Here’s how to reference a cell, pull a range with IMPORTRANGE, or add a hyperlink to another file or tab.

Learn how AutoRecover works in Excel, where to find your Excel auto recovery file location on Windows and Mac, and how AutoSave and AutoBackup help.

Learn conditional formatting in Excel, from built-in highlight rules to writing an Excel conditional formatting formula with COUNTIF, AND, or another cell.

Learn how to use queries and connections in Excel with Power Query. Import data from one or more sheets, set refresh options, and remove a query.

There are a variety of methods to compare Excel files or sheets and identify differences. Here’s how to compare two Excel files or sheets.