q3 Lesson 1 Veiwing and Editing

VIEWING AND
EDITING
VIEWING THE WORKSHEET’
There are many ways that you can view

your worksheet. It is important to
know the different views so that you
will know what view to use to perform
your tasks easily and efficiently.
1. Normal View is the default view
showing the gridlines, toolbars, and menus.
You can access Normal view from the View
tab or from the view button at the bottom of
the window.
Normal View
Normal
2. Zoom allows you to increase or
reduce the view of the worksheet. Zoom
command can be accessed from the View tab,
Zoom group or by using the Zoom slider.
Click the + sign to increase and – sign to
decrease the view.
Zoom
3. Page Break Preview is a reduce
view showing where page breaks are located.
Page Break
4. Print Preview shows how the
worksheet will look on printed paper. You
can access the Print Preview on the File
menu.
Print
Print Preview
5. Page Layout allows you to view
the page layout of your document.
PageLayout PageLayout View

6. Split allows you to view top and left
most part of the screen while also viewing the
other parts of a large worksheet. You can
access the Split command on the Window
menu.
Split
Split Line
7. Minimize reduces the worksheet to a
button size icon at the bottom of the window.
Minimize
8. Restore shows the worksheet in a
reduced view that allows you to move the
worksheet by clicking and dragging the
pointer and resize the worksheet by
dragging the arrows.
With a restored window, you can work on a

worksheet and other programs at the same
time.
BACKSTAGE VIEW
Backstage view allows you to view all the

tools you need to open, save, print and work
on your worksheet all in one view. This view
shows the various commands and tabs so
you can easily find the tasks and options you
want to apply to your worksheet.
1. Click File menu to display the Backstage view.
2. Review the file’s properties.
3. Choose the tools you wil work with.
4. Click the File menu arrow to close the Backstage view.
BACKSTAGE VIEW
Info
File Properties
DELETING DATA AND CLEARING CELL CONTENTS
As you are building or modifying your
worksheet, you may find that you have to
change data or formula in a cell or you want
a cell to be empty. To erase the content of a
cell, go to the cell you want to erase then
press either Delete or the Clear on the
keyboard or press the Spacebar and press
Enter.
You can remove or delete cells, charts,
columns, rows, and worksheets from the
Edit tab commands on the Ribbon.
DELETING DATA AND CLEARING CELL
CONTENTS
1. Select the cell you want to delete, then on the Home tab, go to the Cell group
and click Delete drop down arrow.
2. Select from the drop-down menu the delete options such as Delete Cells, Delete
Sheet Rows, Delete Sheet Columns, Delete Sheet.
3. You can also highlight the group of cells the right click the mouse to show the
2. Select from the drop-down menu the delete options such as Delete Cells, Delete
Sheet Rows, Delete Sheet Columns, Delete Sheet.
3. You can also highlight the group of cells the right click the mouse to show the
Mini Toolbar and Context Menu. The Delete dialog box will appear. Select the
options from the menu and click OK.
4. You can also go to the Editing group, click the Clear button and select Clear
All, Clear Formats, Clear Contents, or Clear Comments.
USING THE UNDO AND
REDO BUTTONS
As you are entering data on the worksheet,
you may find that you have to cancel or
correct a mistake. The Undo function
allows you to reverse the command or
action. While the Redo function allows you
to restore a previous action.
1. To display the Undo and Redo buttons on the Quick Access
Toolbar, click the drop down arrow and check the Undo and Redo commands.
2. Click the Undo button to reverse a command and the Redo button to restore a
previous action.
USING CUT, COPY AND PASTE
You can cut and paste values, texts, formats,

formulas, worksheets, and graphic objects in
your worksheet or workbook. You can also
do so within Excel or between Excel and
another Windows application. The cut or
copied content will be temporarily stored in
a Clipboard.
1. Select or highlight the cell or range of cells you want to copy or cut.
2. Click the Home tab, go to the Clipboard group and click the Copy
or Cut button.
3. Go to the cell where you want to place your cut or copied data.
4. On the Clipboard group, click the Paste button.
You can also use Cut, Copy and Paste using
the Context Menu.
1. Select the cell or range of cells you want to

copy or cut.
2. Right click the mouse to show the Mini
toolbar and Context menu.
3. Click Cut or Copy command from the
menu.
4. Click on the cell where you want the data
to be placed and right click the mouse.
5. On the Context menu, click the Paste

command.
FINDING CELLS OR DATA
You can locate cells, data or values in a long worksheet.

1. Click the Home tab, go to the Editing group and click the Find and Select
button.
2. On the drop-down list, select Find.
3. Excel will search the entire worksheet for the data you are finding in the
worksheet.
You can use the Spelling tool to check the spelling of words used in your worksheet.
1. Select the worksheet area you want to spell-check.
SPELL CHECKING THE WORKSHEET
You can use the Spelling tool to check the spelling of words used in your worksheet.
1. Select the worksheet area you want to spell-check.
2. Click the Review tab, go to the Proofing group and click the spelling
button.
3. The Spelling Dialog box will show words that are not in the MS Dictionary and
2. will
Clickdisplay
the Review tab, gowhich
suggestions to theyouProofing
can use group and click the spelling
or ignore.
button. way to spell check is from the Quick Access Toolbar, click the spelling
4. Another
3. The Spelling Dialog box will show words that are not in the MS Dictionary and
will button
display suggestions which you can use or ignore.
4. Another way to spell check is from the Quick Access Toolbar, click the spelling
CONVERTING FILES TO PDF
Excel can save your work in PDF format. You
can save a copy in PDF format in many ways.
1. On the File menu, select Export and click

Create Adobe PDF. On the dialog box click
Convert to PDF.
2. On the File menu, select Save As and click
More Options. On the dialog box select PDF
on the Save as type.
3. On the File menu, select Print and click
the Printer. On the drop-down list, select
from the many PDF options.
4. Go to the Acrobat tab and select from the
many PDF options.
5. The quickest and newest way to create a
PDF is to use the Share button in the top
right corner of the application. Simply click
the Share button and select Send
Attachment, then PDF.
THANK YOU VERY
MUCH…

q3 Lesson 1 Veiwing and Editing

Uploaded by

Copyright:

Available Formats

q3 Lesson 1 Veiwing and Editing

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

q3 Lesson 1 Veiwing and Editing

Uploaded by

Copyright:

Available Formats

VIEWING AND

There are many ways that you can view

PageLayout PageLayout View

With a restored window, you can work on a

Backstage view allows you to view all the

You can cut and paste values, texts, formats,

1. Select the cell or range of cells you want to

5. On the Context menu, click the Paste

You can locate cells, data or values in a long worksheet.

1. On the File menu, select Export and click

You might also like