How fits 4 lottery workbook

Excel: Fix windows, split and arrange windows

The split and arrange windows functions allow you to view several workbooks at the same time. Freeze the first row or column. Synchronous scrolling. On the site you can find out how it all works.

Commands and their function

# Change window

Change window

  • This function enables you to switch quickly between all active workbooks. Provided that the required folders are not hidden.
  • Go to the tab "view„.
  • In the group "window"The command"Change window“Click.
  • Click the icon to view active workbooks.
  • Select one of the workbooks.
  • Alternatively: Select another workbook in the task bar.

#New window

New window

  • The current workbook opens in a second, third, etc. window. (A mirror image or a copy of the portfolio is created).
  • From the heading in the header you can see which of the folders is currently being processed. (e.g. 1 - 2 - Excel)
  • This copy enables different areas of a workbook to be edited without having to scroll back and forth. You just switch between these folders.
  • When one of the folders is closed, there is no storage. (The reason is: At least one other variant of this workbook is still active).
  • However, it is still necessary to switch between the workbooks in order to edit them. With the following commands the active folders can be displayed on the screen at the same time.

# Hide window

Hide window

  • The “Hide Window” command hides the current workbook in the background, but does not close it.
  • Even if you forget this hidden folder and you are about to close Excel, the message "Save / Do not save„.
  • When the workbook in the hidden state is saved, it will also be saved when the program is opened later in the hidden state open. Don't panic, it's still there.
  • Register "view“ >> „Fade in“Click to make the folder visible.

#Show window

Show window

  • Should the function "Fade in“Be clickable, then it means that one or more workbooks are hidden.
  • When you click this button, a window opens with the currently hidden workbooks.
  • Select any folder and click "OK" to confirm.

# Arrange windows

Arrange all windows

  • Show open windows on the screen at the same time.
  • By clicking on this button, you can determine how the open workbooks are to be divided on the screen. Diagonal, horizontal, etc.
  • Set the check mark in the lower area of ​​the selection window if only the active folder including the mirror images should be displayed.
  • Active folder means: The folder that is currently being processed.
  • By Double click in the header area a workbook or Maximize the workbooks are restored to their normal size.
  • If more work space is required, the menu ribbon can be folded in using the arrow on the right-hand side. To expand, click on the arrow in the header area and select action.
  • (The display of more than two folders becomes confusing and is more interesting for large screens).

#Share window

Split window

  • Each worksheet can be divided into further areas.
  • The place to be shared is determined by clicking on a cell. The upper left corner of this cell defines the subpoint.
  • With the mouse, the sections can be further adjusted as required. To do this, move the pointer to any dividing edge until it becomes the move pointer, then click, hold the key and determine a new position.

#Show windows side by side

Show windows side by side

  • The function can be activated with the command "Arrange all“Be assimilated.
  • Again, open workbooks are split up on the screen. At the same time the "Synchronous scrolling"Activated, which can also be deactivated at any time if necessary.
  • After the function "View side by side"Has been activated, click the"Arrange all“Click to determine how the open workbooks should be divided on the screen.
  • Button "View side by sideClick “to cancel the order, or through Double click in the header area or. Maximize the workbooks are restored to their normal size.

#Synchronous scrolling

Synchronous scrolling

  • The function enables simultaneous scrolling of different worksheets in order to be able to compare them better.
  • The worksheets must first be positioned next to each other.
  • The command "View side by side"Activates the command"Synchronous scrolling“Automatically.
  • With the command "Arrange all“The division of the worksheets can be determined on the screen
  • The function can be deactivated at any time by clicking on it again.

#Reset window position

Reset window position

  • The previous arrangement of the workbooks is retained by vertical, overlapping or subdivided, back to the standard horizontal view changed.
  • Even if the size of the workbooks has been changed in the meantime, it will be reset to the default size.

#Customize the taskbar

Customize the taskbar for multiple windows

  • Taskbar " with the "right mouse buttonClick “. (The task bar is usually located at the bottom of the screen. This is also where the open folders are displayed.)
  • Settings"And in the context menu to the sub-item"Group the buttons on the taskbar“Scroll. There you can determine how the windows should be displayed in the system tray.
  • Preferably "always group" choose. In this case, a thumbnail of the open workbooks is always displayed when you move the pointer over it.

# Show multiple workbooks

Display multiple workbooks on the screen

Another way to edit several workbooks at the same time is to split the active workbooks into a reduced view on the screen.

  • Workbook "Zoom out“Or click on the folder name in the upper area, Hold mouse button and move (The window is reduced).
  • Grab the reduced folder with the mouse (In the area of ​​the folder description) and move it to any edge or corner of the screen until Windows displays a visual suggestion.
  • When the position fits, release the mouse button.

This procedure can be repeated for other workbooks. Now you can jump back and forth between the folders without having to minimize or maximize the windows.


Fix rows, columns, areas

# Freeze window # Freeze window # Unfasten

Freeze / unblock window

  • A worksheet can be divided into areas so that you can keep an eye on part of the sheet while scrolling.
  • The place to be shared is determined by clicking on a cell. The upper left corner of this cell defines the subpoint.
  • Now the sections of the worksheet can be edited independently of each other.
  • Clicking on this symbol again cancels the fixation.

# Freeze first line

Fix the top line

The command can be used to fix the first line of the worksheet. This is useful for tables where the headings must always be visible.

  • The drop-down arrow next to "Fix the windowClick “.
  • Fix the top line" choose.
  • The first line is frozen.
  • To cancel the drop-down arrow next to "Fix the window" and "Remove the fixation“Click.

# Fix first column

Fix the first column

  • The drop-down arrow next to "Fix the windowClick “.
  • Fix the first column" choose.
  • The first column is frozen.
  • To cancel the drop-down arrow next to "Fix the window" and "Remove the fixation“Click.