TRANSLATE function - Microsoft Support
The TRANSLATE () function allows you to translate text from one language to another in Microsoft Excel by using Microsoft Translation Services. Syntax. The syntax for the TRANSLATE () function is as follows: =TRANSLATE (text, [source language], [target language]) The function has the following arguments: text: The text to translate.
Apply shading to alternate rows or columns in a worksheet
This article shows you how to automatically apply shading to every other row or column in a worksheet. Newer versions Web. There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or, you can apply a predefined Excel table style to your data.
Convert numbers stored as text to numbers in Excel
In this example, column E contains the text stored as numbers. Column F is the new column. In one of the cells of the new column, type =VALUE () and inside the parentheses, type a cell reference that contains text stored as numbers. In this example it's cell E23.
Manage workbook links - Microsoft Support
You can decide whether the links in this workbook are refreshed when opening the file according to the user's setting, not refreshed when opening the file, or refreshed automatically without prompting the user. This option affects all users of the workbook.
Use Microsoft Query to retrieve external data
By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that you want to analyze in Excel. You can also refresh your Excel reports and summaries automatically from the original source database whenever the database is updated with new information.
Automatically run a macro when opening a workbook
You might want a macro you recorded to run automatically when you open a specific workbook. The following procedure uses an example to show you how that works. You may also want to run macros automatically when Excel starts. Newer Windows versions Newer Mac versions.
Create a relationship between tables in Excel - Microsoft Support
Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
Save a workbook as a template - Microsoft Support
Open the workbook you want to use as a template. Click File > Export. Under Export, click Change File Type. In the Workbook File Types box, double-click Template. In the File name box, type the name you want to use for the template. Click Save, and then close the template.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
TEXTSPLIT function - Microsoft Support
Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function.
Refresh an external data connection in Excel - Microsoft Support
Block or unblock external content in Office documents. You can connect your Excel workbook to an external data source, such as a SQL Server database, an OLAP cube, or even another Excel workbook. This connection can appear in your workbook as a …