ms-excel xp lesson 3. print preview 1.file menu, print preview menu item 2.print preview window,...
TRANSCRIPT
![Page 1: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/1.jpg)
MS-Excel XP
Lesson 3
![Page 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/2.jpg)
Print Preview
1. File menu, Print preview menu item
2. Print preview window, close button
3. Pages are outlined by borders on worksheet
Print Area1. 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 3: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/3.jpg)
Page Setup1. 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
![Page 4: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/4.jpg)
Cut, Paste Values & Formulas1. Select cell or cell range
2. Edit menu, Cut menu item (Ctrl+X)
3. Select cell or cell range to paste
4. Edit menu, Paste menu item (Ctrl+V)
Copy, Paste Values1. Select cell or cell range
2. Edit menu, Copy menu item (Ctrl+XC)
3. Select cell or cell range to paste
4. Edit menu, Paste menu item (Ctrl+V)
![Page 5: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/5.jpg)
Copy, Paste Formulas1. Select cell or cell range
2. Edit menu, Copy menu item (Ctrl+C)
3. Select cell or cell range to paste
4. Edit menu, Paste special menu item
5. Select values to paste values only
6. Select formula to paste formulas only
7. Click ok
![Page 6: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/6.jpg)
Printing a Worksheet1. Select worksheet
2. File menu, Print menu item
3. Select printer name
4. 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)
![Page 7: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/7.jpg)
Undo
1. Edit menu, Undo… menu item
2. Undo button in standard tool bar’
3. Crtl+Z
Redo1. Edit menu, Redo… menu item
2. Redo button in standard tool bar’
3. Crtl+Y
![Page 8: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/8.jpg)
Undo
1. Edit menu, Undo… menu item
2. Undo button in standard tool bar’
3. Crtl+ZRedo
1. Edit menu, Redo… menu item
2. Redo button in standard tool bar’
3. Crtl+YGoto
1. Edit menu, Goto menu item
2. Type cell address in reference filed
3. Click ok
![Page 9: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/9.jpg)
Find1. 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
Replace1. 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
![Page 10: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/10.jpg)
Normal View & Page Break View
1. Select worksheet
2. View menu
3. Select normal view or page break view
Zoom
1. Select worksheet
2. View menu, Zoom menu item
3. Select magnification percentage
4. Click ok
![Page 11: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/11.jpg)
Header and Footer
1. Select worksheet
2. View menu, Header and footer menu item
3. Select header and footer options
4. Click custom header or custom footer buttons to insert or edit header and footer message
Full Screen1. View menu, Full screen menu item
2. Close full screen menu item
![Page 12: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/12.jpg)
Deleting Rows
1. Select row/s
2. Edit menu, delete menu item
3. Or Right click on row heading and click delete
Deleting Columns1. Select column/s
2. Edit menu, Delete menu item
3. Or Right click and click delete
![Page 13: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/13.jpg)
Inserting Rows
1. Select row/s
2. Insert menu, Rows menu item
3. Or right click and click insert
4. New row/s inserted to top of selected row/s
5. Unable to insert new row/s when last row contains data (65336)
![Page 14: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/14.jpg)
Inserting Columns
1. Select column/s
2. Insert menu, Columns menu item
3. Or right click and click insert
4. New column/s inserted to left side of selected column/s
5. Unable to insert new column/s when last column contains data (IV)
![Page 15: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/15.jpg)
Formatting Rows
1. Select row/s
2. Format menu, Rows sub menu1. Height menu item, Select height, Click ok
2. Or Auto fit menu item
3. Hide menu item to hiding row/s
4. Unhide menu item to displaying row/s
![Page 16: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/16.jpg)
Formatting Columns
1. Select column/s
2. Format menu, Columns sub menu1. Width menu item, Select width, Click ok
2. Or Auto fit selection menu item
3. Hide menu item to hiding column/s
4. Unhide menu item to displaying column/s
5. Standard width menu item to select standard width for column
![Page 17: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/17.jpg)
Hiding and Displaying Worksheets
1. Select worksheet
2. Format menu, sheet sub menu
3. Click hide menu item
4. To display, click unhide menu item, select worksheet to unhide, click ok
![Page 18: 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](https://reader036.vdocuments.us/reader036/viewer/2022082610/56649d965503460f94a7f178/html5/thumbnails/18.jpg)
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