Search results
Results From The WOW.Com Content Network
Learn how to use the new simplified sharing feature in Excel. Now it's easier to share your spreadsheet with others on SharePoint, OneDrive, or OneDrive for Business.
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly—in a matter of seconds. And with certain versions of Excel, you'll see other people's selections in different colors.
You can use the Move or Copy Sheet command to move or copy entire worksheets (also known as sheets), to other locations in the same or a different workbook. You can use the Cut and Copy commands to move or copy a portion of the data to other worksheets or workbooks.
A workbook link (previously called an external reference) is a way to combine data from other workbooks or other sheets in the same workbook. You might want to use them to: Link workbooks from several departments and then integrate pertinent data into a summary workbook.
To quickly find and remove data and information:: In Document Inspector, select or clear the options (as described below) to remove or save. Select Inspect. Review the inspection results, and select Remove All on any items to delete. For caveats and info on removing information, see Use the Document Inspector.
See files others have shared with you. Sometimes you need to find a file someone has shared with you. Files can be shared using the sharing dialog, attaching a file or sharable link in email, sending a link in Teams, or other experiences.
If a workbook contains a Visual Basic for Applications (VBA) macro that you would like to use elsewhere, you can copy the module that contains that macro to another open workbook by using the Visual Basic Editor (VBE).
Because Error Checking in Excel can identify text-formatted dates with two-digit years, you can use the automatic correction options to convert them to date-formatted dates. You can use the DATEVALUE function to convert most other types of text dates to dates.
Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a sparkline near its data for greatest impact.
Excel formatting and features that are not transferred to other file formats. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016. The .xlsx workbook format preserves all worksheet and chart data, formatting, and other features available in earlier Excel versions, and the Macro-Enabled Workbook format (.xlsm) preserves macros and macro ...
If you want to change the default editing language to check the spelling, see Change the language Office uses in its menus and proofing tools. If you need to add text that is in a language other than the one you normally use, Office can check spelling and grammar of that text for you.