Formatting with Microsoft Excel 2002

Short Description
A Tutorial for Excel. 2002 for Windows. INFORMATION SYSTEMS SERVICES. Formatting with Microsoft Excel 2002. U N I V E R S I T Y O F L E E D S. EDITION: 2.0 …

Website: www.leeds.ac.uk | Filesize: 433kb

Content
TUT48
A Tutorial for Excel 2002 for Windows
INFORMATION SYSTEMS SERVICES
Formatting with Microsoft Excel 2002
UNIVERSITY OF LEEDS
EDITION: 2.0
DATE: August 2004
AUTHOR: Information Systems ServicesContents
1.0 Introduction……………………………………………………………………..1
1.1 About Spreadsheets…………………………………………………………….1
1.2 Aim of this Document…………………………………………………………1
1.3 Prerequisites……………………………………………………………………..1
Task 2 Row Heights and Column Widths……………………………………………3
Task 3 Alignment of Cells………………………………………………………………..4
Task 4 Number Formatting……………………………………………………………..5
Task 5 Formatting Cell Borders………………………………………………………..8
Task 6 Conditional Formatting…………………………………………………………9
Task 7 Defining Number Formats……………………………………………………11
Task 8 Finishing Excel………………………………………………………………….11
Appendix…………………………………………………………………………………12
Format Conventions
In this document the following format conventions are used:
Commands that you must type in are shown in bold Times New Roman font.
WIN31
Menu items are given in a bold, Times New Roman font.
Windows Applications
Keys that you press are enclosed in angle brackets.

Feedback
If you notice any mistakes in this document please contact the Information Officer. Email should be sent to the address info-officer@leeds.ac.uk
Copyright
This document is copyright University of Leeds. Permission to use material in this document should be obtained from the Information Officer (email should be sent to the address info-officer@leeds.ac.uk)
2…