How to manipulate data in Microsoft Excel
Contents:
Apply borders
Step 1: Highlight cells
Click and drag to highlight the desired area you wish to apply the border styles to.
Step 2: Apply borders
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: Highlight cells
Click and drag to highlight the desired area you wish
Step 2: Freeze panes
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: Click and drag the edges of a row or column
On a row or cell, click and drag on the border to increase or decrease the width or height.
Method 2: Choose dimensions from options
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 cells
Highlight the cell(s) you wish to apply the setting to.
Step 2: Wrap Text
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 cells
Highlight the cells you wish to merge.
Step 2: Click the "Merge and Center" button
From the top bar, click the "Merge and Center" Button
Printing
Step 1: Select "Print"
To print the document, go to File > Print.
Step 2: Fit sheet on one page
To fit the document on one page, under "Settings", click "No Scaling" and choose "Fit Sheet on One Page" from the options.
