You can manage a large number of spreadsheets in Excel. You can make them unique on the basis of Tab colour, name. Different spreadsheets can be used for different kind of uses, purposes, and tasks.
You can edit spreadsheet in the following manner.
Add new spreadsheet: Just click the plus button on spreadsheet at the bottom next
to last sheet of the Excel file, new file will be created next to the last
sheet,
OR press Shift + F11 new sheet will be created just before the
current sheet.
Rearrangement of spreadsheets: Hold the sheet Tab and drag it to its new place where you want it
to place.
Right click on the spreadsheet and you can do many tasks as given following.
Insert: You
can insert Worksheet, Chart, and Macro etc.
Delete a
spreadsheet:
Right-click the sheet Tab and click Delete option. Your current sheet will be deleted.
Rename a spreadsheet: Double-click the sheet Tab OR Right click
on
the tab and type the New Name.
Move or
copy a spreadsheet: Right-click
the sheet tab and select Move or Copy. You can Move (means sheet will be
deleted from the current place) or you can Copy then its original will
remain on the current place but its copy will be created.
Protect a
spreadsheet:
Right-click the sheet Tab and under Protect Sheet, add a
Password and select your options.
Colour a
spreadsheet Tab:
Right-click on the sheet Tab and under Tab “Color”, just click to apply
new colour, in the below picture, I have selected Red colour for the Tab.
Hide a
spreadsheet:
Right click on the Sheet Tab; click on the “Hide” tab, then this sheet
will be hidden.
Unhide a spreadsheet: Right click on the Sheet Tab; click on the “Unhide” tab, then the list of hidden sheet/s will be available then select the sheet (you want to unhide) and click on OK.
No comments:
Post a Comment