 More
than one Excel file can be open at a time in the
Excel Application.
These files are displayed within 'windows' and therefore
to move between them, arrange them, hide them, etc. It
stands to reason you will use the 'Window' menu.There
is a subtle distinction in 'windows' and that is the
technicality that Excel itself has windows. These are
the files, (workbooks) you have opened and the Workbook
itself also contains 'windows'. Excel
(Application) windows are set up by
File>Open..., whereas
Workbook windows are set up on this menu by the 'New
Window' option. The latter can be considered as 'views'
of the same workbook. This allows you to look at
different sheets in the workbook at the same time, etc.
At the bottom of the menu will always be the list of
'windows', both Excel (Application) and Workbook, that
are open currently. If you look in this list you will
either see application (Excel) windows, which look like
ordinary file names, or Workbook windows which have the
file name repeated and appended with :1 or :2, etc. (See
example below). Changes made to this type of window are
made at file level, that is any change you make in
Book1:1 is also made in Book1:2, as they are the same
file. To exit a window to get back to a single
view of the file simply close one of the windows using
the window control button
and save the file.
The 'active window', (the one selected. Even if two
windows are shown side by side, only one is active), is
the one with a tick next to it.
As a rule in Office, (and most windows), programs, any
menu options with three ellipses (...) after the menu
option, will be followed by another dialog, any options
with a
►, will be followed by a sub-menu if
you hover over the
►.
The menu options on
the image to the left are live hyperlinks and will help
you navigate to the relevant page or you can use the
links on the far left.
In the linked pages you will find
detailed explanations of the option, together with a
code snippet on how the menu option may be implemented
in VBA (Visual Basic for Applications), any lines in
these snippets starting with a single apostrophe(') are comment lines to assist you
and explain what is being done and if pasted into
a module will appear green with no notice being taken of
them when the code is run. (To
implement and explain
VBA you would do best to read
the pages on this subject first).
Top
|
