Excel - Worksheets
Change Sheet Names
Changing sheet names is a good way
to save time, because you will have an idea of the information on
each worksheet without having to click back and forth between different
sheets.
 to
see a viewlet on Changing Sheet Names
Accessing Cells on Another Worksheet
By accessing cells on another worksheet
you are able to save a lot of time. If you need to use the
same piece of information more than once, especially when it is
the result of a particular formula, you will not have to make the
change to all of the other worksheets as well, once you have linked
the cells when one changes, the others will change.
to
watch a viewlet on Accessing Cells on Another Worksheet.
Obtaining text for A VBA Box from
another worksheet
Like accessing cells on another worksheet,
obtaining text from another VBA box will also save you a lot of
time if that information needs to be used in another worksheet.
to
watch a viewlet on Obtaining text From Another VBA Box.
Shared Workbook
Creating a Shared workbook is very
useful when working on group projects. Shared workbooks allow multiple
people to work on a file simultaneously.
to
see a viewlet on creating a Shared Workbook
Adding & Formatting Worksheet
Text
Sometimes it is a good idea to 'spice up' your worksheet text
a little. It may be necessary to change the style, colour,
or size when adding a chart or table or even just to highlight specific
data on the sheet.
to
see a viewlet on Adding & Formatting Worksheet Text.
Home
| Analyze Data | Worksheets
| Graphs | VBA
Boxes
|
