Format Cells and Ranges

Practice Labs Module
Time
51 minutes
Difficulty
Intermediate

The "Format Cells and Ranges" module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises: Format Cells and Ranges, Using Special Paste Options, Pasting Links.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Overview

Introduction

The Format Cells and Ranges module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises:

  • Format Cells and Ranges
  • Using Special Paste Options
  • Pasting Links

Lab time: It will take approximately 1 hour to complete this lab.

Exercise 1 - Formatting Cells and Ranges

As you can combine text, numbers and different type of data in Excel, you can use its formatting features to come up with a presentable workbook.

In this exercise, you will merge and unmerge cells, rotate then align cell data, copy/paste formatting to other cells using Format painter, wrap text in a cell or group of cells, apply appropriate number formatting, create custom styles and remove a cell style from.

Exercise 2 - Using Special Paste Options

When you copy and paste, Excel pastes all parts of what you copied: the contents of the cell (as a formula, if it's a formula), along with any formatting that had been applied to the copied cell. This is often useful, but sometimes you'll want just the values and not the formula (for a report, for example). Or you might get some formatting just the way you want it on one range, and then want to copy the same formatting, but not the contents, to another range.

Excel offers paste options that let you do those things and more.

Exercise 3 - Pasting Links

A link is really just a reference to another location. In a sense, every cell or range reference in every formula is a link. But you can refer to cells on other worksheets or workbooks, and those references are a bit more complex, because they have to include the name of the workbook, worksheet, or both. By pasting a link, you can avoid having to get that reference syntax right yourself.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.