Free-training-tutorial.com





Relaxing Mindfulness
Beautiful Games

Excel Basics Formulas & Functions Special Features
Format Cells Sum, Average, Countif Functions Excel Charts (Graphs)
Worksheets Quick Functions Excel Sort
Edit Cells The IF Statement Excel Filter
Rows and Columns VLOOKUP Function Conditional Formatting
Find and Replace Sumif Function Pivot Table
The Fill Handle Excel Formulas Create a Drop Down List
Excel Keyboard Shortcuts First Aid

Working with Worksheets

Learn how to add new worksheets beyond the existing three, and how to rename them with meaningful names.
Also watch a video teaching how to insert data into a few of them simultaneously.
Adding a new worksheet
Renaming worksheets
Working on multiple worksheets simultaneously

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 view it you must simply click the tab. (The initial names in a new file are: “Sheet1”, “Sheet2” and “Sheet3”).

The 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 they relate to departments 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 of them, you can “group” them and format them as one, and afterwards ungroup them and work on each one separately.