Excel Basics Calculations Special Features
Format Cells Sum, Average, Countif Functions Charts (Graphs)
Worksheets Quick Functions Sort Data
Edit Cells The IF Statement Filter Data
Rows and Columns VLOOKUP Function Conditional Formatting
Find and Replace Sumif Function Excel Pivot Tables
The Fill Handle Excel Formulas Create a Drop Down List
Excel Keyboard Shortcuts First Aid
Excel Training
Microsoft Word Training
Excel Book
About
Questions & Answers
Guestbook
A Full Excel Course

Maths Games
Place Value
Games for Rounding

microsoft word training

Working with Worksheets

Adding a new worksheet
Renaming worksheets
Working on multiple worksheets
       simultaneously

You are welcome to have a look at my Free Math Games.


A worksheet in Excel is simply a big table, in which you can freely enter your data.

When you start working with a new file (named: a “Workbook”), it contains 3 new worksheets (this is similar to a situation where a Word document will be opened with 3 pages).

To reach a certain page in a Word document you must scroll the document up or down; in Excel it is more simple: every worksheet has a small tab with its name, and to reach it you must simply click the tab. (The initial names of the worksheets in a new file are: “Sheet1”, “Sheet2” and “Sheet3”).

Worksheet names can be easily changed, according to your need. For example, if every worksheet relates to a certain month, you can name them “January”, “February” and “March”. If every worksheet relates to a department in a company, you can name them “Sales”, “Administration”, and “Management”.
You can of course add more worksheets to a file, or delete existing ones.

Occasionally there is a need to have many worksheets with the same format, while they differ only in the data they contain (Or in other words - they have the same template). Therefore, instead of copying and pasting the formatting between all worksheets, you can “group” them and format them as one, and afterwards ungroup them and work on every worksheet separately.




Website Statistics