Viewing articles tagged 'Workbook'

Insert or delete cells, rows, and columns

Insert or delete a column To insert a column, select the column, select Home > Insert...
Analyse and format

Automatically fill a column with Flash Fill For example, automatically fill a First Name...
Apply data validation to cells

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

Share your workbook with others Select  Share on the ribbon. Or, select File > Share....
Copy cell formatting with the Format Painter

Select the shape, text, picture, or worksheet cell with the formatting you want to copy....
Create a list of sequential dates

Use the Fill Handle Select the cell that contains the first date. Drag the fill handle...
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

Excel makes it easy to crunch numbers. With Excel, you can streamline data entry with AutoFill....
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. Remove duplicate values When you remove...
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

Hide columns Select one or more columns, and then press Ctrl to select additional...
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....
Learn more

Excel help and training Excel training Excel help What's new in Office 365 Excel for Mac...
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

  You can manually adjust the column width or row height or automatically resize columns and...
Save your workbook to OneDrive

Save your workbook to OneDrive Save a workbook to OneDrive to access it from different devices...
Select cell contents in Excel

Select one or more cells Click on a cell to select it. Or use the keyboard to navigate...
Set up your mobile apps

Get to your files from anywhere - at work, at home, or on the go. Set up the Office apps...
Use Excel as your calculator

Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas...