How to manipulate data in Microsoft Excel

Within Microsoft Excel, there are various options to manipulate, change, and format cells to your liking. This article will guide you through the various ways you can do this.

Prerequisites

Microsoft Excel

Apply borders

Step 1

Click and drag to highlight the desired area you wish to apply the border styles to.

Step 2

In the font section of the top bar, click on the "" icon for border styles, and choose the border style you prefer.

Freeze panes

Step 1

Click and drag to highlight the desired area you wish

Step 2

In the top panel, go to "View" and select "Freeze Panes". This will keep the panes locked in place as you scroll through the document.

Change the width and height of rows and columns

Method 1

On a row or cell, click and drag on the border to increase or decrease the width or height.

Method 2

Step 1

Highlight a row or column

Step 2

Right-click and select "Row Height" or "Column Width"

Step 3

Enter the desired dimensions, and click "OK"

Wrap Text

Step 1

Highlight the cell(s) you wish to apply the setting to.

Step 2

With the cell(s) selected, either

Choose from the top ribbon "Wrap Text"

Right-click > Format Cells > Alignment > Wrap Text

Merge Cells

Step 1

Highlight the cells you wish to merge.

Step 2

From the top bar, click the "Merge and Center" Button

Printing

Step 1

To print the document, go to File > Print.

Step 2

To fit the document on one page, under "Settings", click "No Scaling" and choose "Fit Sheet on One Page" from the options.