Look up information in a worksheet

Whenever you create a worksheet containing a list of distinct items, such as products offered by a company, ensure that at least one column has a unique value distinguishing each row (and the item it…

Print Worksheets

When you’re ready to print a worksheet, you can control how Excel prints it. You can choose the printer, print multiple copies, and select whether the copies are collated (all pages of a document…

Track and manage others changes

Tracking changes in Excel allows you to monitor who makes changes to a workbook, what changes are made, and when they occur. This feature is particularly useful when multiple users collaborate on a…

Manage Comments

Excel allows you and your colleagues to insert comments in workbook cells, providing additional insights beyond the cell data. When a comment is added to a cell, a flag appears in the upper-right…

Export workbook

Even though most businesses use Excel, there might be times when you need to distribute your data in a different file format. You can create a copy of a workbook for electronic distribution by saving…

Share workbooks

Sharing your Excel workbook allows you to collaborate with others. Here are the steps to share a file in Excel:

Format Pivot Tables

PivotTables are excellent tools for summarizing and analyzing large datasets, even those with over 10,000 rows. While PivotTables often result in compact summaries, it's important to enhance data…

Prepare worksheets for printing

When you are ready to print your workbook, you can adjust the workbook’s properties to ensure that your worksheets display all your information and that printing is centered on the page. In Excel, all…

Edit Pivot Tables

After creating a PivotTable, you can rename it, edit its summarization, and use its cell data in formulas. Excel assigns a default name like PivotTable1 when you create it. This name isn't descriptive…

Filter, show, and hide PivotTable data

PivotTables often summarize huge data sets in a relatively small worksheet. The more details you can capture and write to a table, the more flexibility you have in analyzing the data. As an example…

Create charts

To create a chart in Excel, you need to select the data you want to use and then click on the chart type you want to create. You can also use the Insert tab to create a chart. Click on the menu…

Analyze data dynamically by using PivotTables

In Excel worksheets, you can gather and present important data, but the standard worksheet configuration is not easily changeable. For example, consider a worksheet that records monthly sales figures…

Create shapes

You can augment your worksheets by adding objects such as geometric shapes, lines, flowchart, symbols, and banners. After you create a shape, you can use the controls on the Shape tab to change its…

Customize Chart Appearance

If you want to change a chart’s appearance, you can do so by using the Format tab on the Ribbon. Click on the chart you want to customize. This will display the Chart Tools tab on the Ribbon. Click on…

Sort Worksheet Data

When you sort data in a worksheet, you rearrange the rows based on the contents of cells in a specific column or set of columns. For example, you can sort a worksheet to identify your highest-revenue…

Define valid sets of values for ranges of cells

Ensuring the accuracy of data entered into your worksheets is crucial for creating efficient and easy-to-use spreadsheets. While it's impossible to catch every typographical or transcription error…

Link to data in other worksheets and workbooks

Copying and pasting data from one workbook to another is quick and easy, but it has a significant limitation: changes in the original cell are not reflected in the copied cell. In other words, copying…

Summarizing Filtered Data

Analyzing the most vital data is important, but there are limitations to summarizing filtered data using functions like SUM and AVERAGE. One limitation is that these functions don't adjust their…

Limit data that appears on your screen

Excel worksheets can store vast amounts of data, but you may not always need to work with all of it simultaneously. For instance, you might want to view your company's revenue figures for the first…

Change the appearance of data based on its value

A method to improve data interpretation is by using Excel to change the appearance of your data based on its value. This is achieved through conditional formats, which apply specific formatting when…

Make numbers easier to read

Changing the format of cells in your worksheet can significantly enhance data readability. This can be achieved by distinguishing data labels from the actual data and adding borders to clearly define…

Find and correct errors in calculations

Incorporating calculations into a worksheet helps you find valuable answers to questions about your data. However, errors can sometimes occur in your formulas. Excel provides tools to trace the source…

Summarize data that meets specific conditions

Formulas can also be used to display messages when specific conditions are met. These are known as conditional formulas. One common method to create a conditional formula in Excel is by using the IF…

Create formulas to calculate values

To write an Excel formula, you begin the cell’s contents with an equal (=) sign; Excel then knows that the expression following it should be interpreted as a calculation, not text. After the equal…

Name groups of data

When you work with large amounts of data, it’s often useful to identify groups of cells that contain related data. For example, you can create a worksheet in which columns of cells contain data of…

Define Excel tables

Excel makes it easy to manage data lists by allowing you to sort by column values, filter based on criteria, and create formulas to summarize visible cells. To create a table from an existing cell…

Find and replace data

Excel worksheets can hold over a million rows, making it impractical to scroll through each row manually. Instead, use the Find and Replace dialog box, which has two tabs—Find and Replace. The Find…

Move data within a workbook

To move to a cell, click on it to make it the active cell, which is outlined in green and shows its contents in the formula bar. To select multiple cells (a range), click and drag, then you can cut…

Correct and expand upon data

After you enter your data, you should take the time to check and correct it. You do need to verify visually that each piece of numeric data is correct, but you can make sure that your worksheet’s text…

Define styles

As you work in Excel, you’ll likely develop preferred formats for data labels, titles, and other elements. Instead of applying formatting attributes individually, you can use a cell style to apply…

Format cells

Excel worksheets can store and process large amounts of data, but managing multiple worksheets can make it difficult to recall the exact content based on their titles alone. Data labels provide…

Manage data by using Flash Fill

When you manage data in Excel, you will often find that you want to combine values from several cells into a single value. For example, you can have client's first name and last name in separated…

Enter and revise data

The simplest way to enter data is to click a cell and type a value. This method works very well when you’re entering a few pieces of data, but it is less than ideal when you’re entering long sequences…

Zoom in on a worksheet

You can change how Excel displays your worksheets; zoom in on worksheet data; add frequently used commands to the Quick Access Toolbar; hide, display, and reorder ribbon tabs; and create custom tabs…

Merge and unmerge cells

Modify worksheets

Modify worksheets

Modify workbooks

You can use Excel workbooks to track business activities, with each worksheet representing a part of that activity. To view a worksheet, just click its tab at the bottom of the page. You can also…

Modify workbooks

You can use Excel workbooks to track business activities, with each worksheet representing a part of that activity. To view a worksheet, just click its tab at the bottom of the page. You can also…

Create workbooks