Transcript MS-Excel XP Lesson 3 Print Preview 1. File menu, Print preview menu item 2.

MS-Excel XP
Lesson 3
Print Preview
1. File menu, Print preview menu item
2. Print preview window, close button
3. Pages are outlined by borders on worksheet
Print Area
1. Select cell range
2. File menu, Print area sub menu, Set print area
menu item
3. To clear print area;
File menu, Print area sub menu, clear print
area menu item
Page Setup
1. File menu, Page setup menu item
2. Page tab sheet Orientation, Adjusting
Percentage, Paper Size, Print Quality
3. Margins tab sheet top, left, bottom, right
margins, header, footer, center on page
horizontally and/or vertically
4. Header/ Footer tab sheet Header and Footer
5. Sheet tab sheet Print area, Print options,
Page Order
6. Ok button
Cut, Paste Values & Formulas
1.
2.
3.
4.
Select cell or cell range
Edit menu, Cut menu item (Ctrl+X)
Select cell or cell range to paste
Edit menu, Paste menu item (Ctrl+V)
Copy, Paste Values
1.
2.
3.
4.
Select cell or cell range
Edit menu, Copy menu item (Ctrl+XC)
Select cell or cell range to paste
Edit menu, Paste menu item (Ctrl+V)
Copy, Paste Formulas
1.
2.
3.
4.
5.
6.
7.
Select cell or cell range
Edit menu, Copy menu item (Ctrl+C)
Select cell or cell range to paste
Edit menu, Paste special menu item
Select values to paste values only
Select formula to paste formulas only
Click ok
Printing a Worksheet
1.
2.
3.
4.
Select worksheet
File menu, Print menu item
Select printer name
Click properties and select paper size and
orientation in page tab sheet, click ok
5. Select print range (all or pages from to values)
6. Select no of copies
7. Select print what option (active worksheet,
selection, entire workbook)
Undo
1. Edit menu, Undo… menu item
2. Undo button in standard tool bar’
3. Crtl+Z
Redo
1. Edit menu, Redo… menu item
2. Redo button in standard tool bar’
3. Crtl+Y
Undo
1. Edit menu, Undo… menu item
2. Undo button in standard tool bar’
3. Crtl+Z
Redo
1. Edit menu, Redo… menu item
2. Redo button in standard tool bar’
3. Crtl+Y
Goto
1. Edit menu, Goto menu item
2. Type cell address in reference filed
3. Click ok
Find
1. Edit menu, Find menu item
2. Type finding text or number
3. Click options and select match entire cell
contents
4. Click find next to fin next or find all
Replace
1. Edit menu, Replace menu item
2. Type finding text or number
3. Click options and select match entire cell
contents
4. Click find next, replace or replace all
Normal View & Page Break View
1. Select worksheet
2. View menu
3. Select normal view or page break view
Zoom
1.
2.
3.
4.
Select worksheet
View menu, Zoom menu item
Select magnification percentage
Click ok
Header and Footer
1.
2.
3.
4.
Select worksheet
View menu, Header and footer menu item
Select header and footer options
Click custom header or custom footer buttons
to insert or edit header and footer message
Full Screen
1. View menu, Full screen menu item
2. Close full screen menu item
Deleting Rows
1. Select row/s
2. Edit menu, delete menu item
3. Or Right click on row heading and click delete
Deleting Columns
1. Select column/s
2. Edit menu, Delete menu item
3. Or Right click and click delete
Inserting Rows
1.
2.
3.
4.
5.
Select row/s
Insert menu, Rows menu item
Or right click and click insert
New row/s inserted to top of selected row/s
Unable to insert new row/s when last row
contains data (65336)
Inserting Columns
1.
2.
3.
4.
Select column/s
Insert menu, Columns menu item
Or right click and click insert
New column/s inserted to left side of selected
column/s
5. Unable to insert new column/s when last
column contains data (IV)
Formatting Rows
1. Select row/s
2. Format menu, Rows sub menu
1.
2.
3.
4.
Height menu item, Select height, Click ok
Or Auto fit menu item
Hide menu item to hiding row/s
Unhide menu item to displaying row/s
Formatting Columns
1. Select column/s
2. Format menu, Columns sub menu
1.
2.
3.
4.
5.
Width menu item, Select width, Click ok
Or Auto fit selection menu item
Hide menu item to hiding column/s
Unhide menu item to displaying column/s
Standard width menu item to select standard
width for column
Hiding and Displaying Worksheets
1.
2.
3.
4.
Select worksheet
Format menu, sheet sub menu
Click hide menu item
To display, click unhide menu item, select
worksheet to unhide, click ok
Applying Background and Tab Color to
Worksheets
1. Select worksheet/s
2. Format menu, sheet sub menu
3. Click background and browse background
picture and click insert
4. Click delete background menu item to remove
background in worksheet
5. Format menu, sheet sub menu
6. Click tab color and select color and click ok
7. Select no color and click ok to remove a tab
color