Keeping leading zeros and large numbers - Microsoft Support
Excel automatically removes leading zeros, and converts large numbers to scientific notation, like 1.23E+15, in order to allow formulas and math operations to work on them. This article deals with how to keep your data in its original format, which Excel treats as text. Convert numbers to text when you import text data.
Format an Excel table - Microsoft Support
Export an Excel table to SharePoint. Convert an Excel table to a range. Filter data in a range or table. Format an Excel table by applying different table styles or colors.
Change macro security settings in Excel - Microsoft Support
In Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a workbook. For example, you might allow macros to run based on whether they are digitally signed by a trusted developer.
RAND function - Microsoft Support
To generate a random real number between a and b, use: =RAND ()* (b-a)+a. If you want to use RAND to generate a random number but don't want the numbers to change every time the cell is calculated, you can enter =RAND () in the formula bar, and then press F9 to change the formula to a random number.
Load the Analysis ToolPak in Excel - Microsoft Support
Perform statistical and engineering analysis with the Analysis ToolPak. The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.
COUNTA function - Microsoft Support
This article describes the formula syntax and usage of the COUNTA function in Microsoft Excel. Description. The COUNTA function counts the number of cells that are not empty in a range. Syntax. COUNTA (value1, [value2], ...) The COUNTA function syntax has the following arguments: value1 Required.
Microsoft 365 Quick Starts - Microsoft Support
Training: Get started quickly on all of your favorite Microsoft 365 apps with our popular Quick Start guides.
Issue: An _xlfn. prefix is displayed in front of a formula
Resolution. Remove the unsupported functions, or if possible, replace the unsupported functions with supported functions. Note: These functions are available if you have a Microsoft 365 subscription.
Clear the clipboard - Microsoft Support
The Clipboard task pane appears on the left side of your spreadsheet and shows all clips in the clipboard. To clear the entire clipboard, click the Clear All button. To delete an individual clip, hover next to the clip, click the arrow to the right of the clip, and click Delete.
Set or clear a print area on a worksheet - Microsoft Support
When you print a worksheet after defining a print area, only the print area is printed. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet. A worksheet can have multiple print areas. Each print area will print as a …
Insert a screenshot or screen clipping - Microsoft Support
Use the Windows Snipping Tool to capture screen shots. Crop a picture. Add clip art to your file. Add full or partial screenshots to your document without leaving your app.