文章

Insert or delete cells, rows, and columns

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Add a watermark in Excel

Microsoft Excel doesn’t come with a built-in watermark button. But you can use an image, like a...
Align or rotate text in a cell

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Analyse and format

Automatically fill a column with Flash Fill Need help setting this up? If you'd rather...
Apply data validation to cells

You can use data validation to restrict the type of data or the values that users enter into a...
Available number formats

In Excel, you can format numbers in cells for things like currency, percentages, decimals,...
Change the format of a cell

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Collaborate

Share your workbook with others Need help setting this up? If you'd rather not deal with the...
Conditional formatting

  Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Copy cell formatting with the Format Painter

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Create a list of sequential dates

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Create a new workbook

A workbook is a file that contains one or more worksheets to help you organise data. You can...
Create a workbook

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Fill data automatically in worksheet cells

Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in...
Filter for unique values or remove duplicate values

In Excel Online, you can remove duplicate values. Need help setting this up? If you'd rather...
Find or replace text and numbers on a worksheet

Use the Find and Replace features in Excel to search for something in your workbook, such as a...
Freeze panes to lock rows and columns

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to...
Hide or show rows or columns

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Import or export text (.txt or .csv) files

There are two ways to import data from a text file with Excel: you can open it in Excel, or you...
Insert or delete a worksheet

In Excel, you can easily insert, rename, and delete worksheets in your workbook. Need help...
Learn more

Excel help and training Need help setting this up? If you'd rather not deal with the...
Merge and unmerge cells

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Microsoft Excel — Core Features Guide for Microsoft 365 Users

Microsoft Excel — Core Features Guide for Microsoft 365 Users This guide covers Microsoft Excel...
Move or copy cells and cell contents

Use Cut, Copy, and Paste to move or copy cell contents. Or copy specific contents or attributes...
Move or copy worksheets or worksheet data

You can move or copy a worksheet in the same workbook to organize your workbook exactly how...
Print a worksheet or workbook

You can print entire or partial worksheets and workbooks, one at a time, or several at once....
Resize a table, column, or row

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Save your workbook to OneDrive

Save your workbook to OneDrive Need help setting this up? If you'd rather not deal with the...
Select cell contents in Excel

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Set up your mobile apps

Get to your files from anywhere - at work, at home, or on the go. Need help setting...
Split text into different columns with the Convert Text to Columns Wizard

Need help setting this up? If you'd rather not deal with the technical side, we can fully set...
Use Excel as your calculator

Instead of using a calculator, use Microsoft Excel to do the math! Need help setting this up?...