Excel file is locked for editing - Microsoft Support
You are trying to open an Excel file and you get a message about the file being locked. Sometimes the file is locked by another user, and other times the "another user" is actually …
Prepare your Excel data source for a Word mail merge - Microsoft …
You've built a list of contacts and other data that you want to use for a Word mail merge. If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail …
Multiply and divide numbers in Excel - Microsoft Support
There are several ways to multiply numbers. To do this task, use the * (asterisk) arithmetic operator. For example, if you type =5*10 in a cell, the cell displays the result, 50. Suppose you …
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 …
FLOOR.MATH function - Microsoft Support
This article describes the formula syntax and usage of the FLOOR.MATH function in Microsoft Excel. Round a number down to the nearest integer or to the nearest multiple of significance. …
TRIM function - Microsoft Support
This article describes the formula syntax and usage of the TRIM function in Microsoft Excel. Removes all spaces from text except for single spaces between words. Use TRIM on text that …
COUNTIF function - Microsoft Support
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its …
DEC2BIN function - Microsoft Support
This article describes the formula syntax and usage of the DEC2BIN function in Microsoft Excel. Converts a decimal number to binary. DEC2BIN (number, [places]) The DEC2BIN function …