A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template. By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain. You can also add and remove worksheets as needed.

Excel makes it easy to crunch numbers. With Excel, you can streamline data entry with AutoFill. Then, get chart recommendations based on your data, and create them with one click.

若要将其关闭，请将设置切换为“关闭”。 关闭 Microsoft Defender 防火墙可能会使设备（以及网络，如果有）更容易受到未经授权的访问。

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.. Use the Excel Formula Coach to figure out a monthly loan payment. At the same time, you'll learn how to use the PMT function in a formula. Syntax. PMT(rate, nper, pv, [fv], [type])

Compress the file. When you compress, or zip, your file, it decreases its size, and it might decrease it enough to fit within the Outlook size limits for attachments.The following articles describe how to compress and extract files for different Windows operating systems.

Notes: To set an automatic reply for contacts outside your company, select Outside My Organization > Auto-reply to people outside my organization, type in a message, and select OK.. The OK button may be missing because of certain screen solution and scaling settings. To resolve this issue, you can adjust the screen resolution and scaling settings, or use a large monitor.

Surface Pro 7 features Work your way. Transform Surface Pro 7 from a tablet to a laptop with the Kickstand and Surface Signature Type Cover. Use the USB-C and USB-A ports to connect to displays, docking stations, and your accessories.

Microsoft 365 is our cloud-powered productivity platform. With a subscription to Microsoft 365, you can get: The latest productivity apps, such as Microsoft Teams, Word, Excel, PowerPoint, Outlook, OneDrive, and so much more.

Using clipboard. When you copy content on your PC, it’s automatically copied to your clipboard for you to paste. You can paste multiple items from your clipboard history, and you can also pin the items you tend to use all the time and sync your clipboard history to the cloud.