Spreadsheet Grid:
This is where all your numbers, data, charts & drawings will
go. Each Excel file can contain several sheets. But the spreadsheet grid shows
few rows & columns of active spreadsheet. To see more rows or columns you can
use the scroll bars to the left or at bottom. If you want to access other sheets,
just click on the sheet name (or use the shortcut CTRL+Page Up or CTRL+Page
Down).
•
Status bar:
This tells us what is going on with Excel at any time. You can tell if
Excel is doing a calculation or calculating using a formula, creating a pivot report
or recording a macro by just looking at the status bar. The status bar also shows
quick summaries of selected cells (count, sum, average, minimum or maximum
values). You can change this by right clicking on it and choosing which summaries
to show.
Manual for Laboratory Practices
91
Creating a New Worksheet
Three new, blank sheets always open when you start Microsoft Excel. But suppose that you
want start another new worksheet while you are working on another worksheet, or you closed
already opened worksheet and want to start a new worksheet. Here are the steps to create a
new worksheet:
Step (1) :
Right Click the
Sheet Name
and select
Insert
option.
Figure 10. New Excel Window with Three New Sheets
Step (2) :
Now you’ll see the Insert dialog with select Worksheet option as
selected from the general tab. Click Ok button
Introduction To Computer Science
92
Figure 11. Insert Sheet Dialog
Now you should have your blank sheet as shown below ready to start typing your text.
Figure 12. Newly Inserted Sheet
You can use a shortcut to create a blank sheet anytime. Try using Shift+F11 keys and you will
see a new blank sheet similar to above sheet is opened.
|
