Dim ws As Worksheet Dim i As Long Dim bGrid As Boolean Dim bPanes As Boolean Dim iSplitRow As Long Dim iSplitCol As Long Dim iActive As Long Application.ScreenUpdating False Store the active sheet iActive ActiveSheet.Index Create new window ActiveWindow.NewWindow Loop through worksheets of original workbook and apply grid line settings to each sheet.

In these instances, it can be much easier to look at the two (or more) sheets side by side.

Its a fairly easy habit to pick up and will save you lots of time and frustration in the long run.

The new window will have a dash and the number 2 (then 3, 4, 5 and so on as you continue to open new windows).

Any change you make to the workbook in one window will be reflected in the other.

You can then quickly flip between windows by using the Alt Tab.

If you have multiple windows open on your computer, you may have to select which window you want to view on the left.

I encourage you to check it out and see how you can improve your productivity game with split screens.

This is especially helpful if you need to compare line by line, looking for differences in similar sets of data.

You can do this by clicking the button directly above Synchronous Scrolling.

This is the case whether you are using the up and down arrows on your keyboard, the scroll bar in either of the windows, or the roller wheel on your mouse.

This will just close the additional window, and NOT close the file.

The -2 will disappear after the file name and you will be left with only one window open for the file.

You will only be prompted to save when you close the last remaining window for the file.

The new window does not retain the settings for gridlines or freeze panes.

This means all Excel fileswindows are opened in the same application window.

One question. How do I prevent Excel from turning on Grid lines in the new windows (I turn off grid lines to make it cleaner looking for my users.) Its really annoying and if I forget and leave one of the new windows as the last one before saveclose the grid lines are on and I have to go through and turn them all off again.

The window settings get reset to their defaults when a new window is created.

Im not exactly sure why its a window level property instead of a worksheet property.

So you could potentially use this instead of the New Window button.

You could add it to your Personal Macro Workbook and create a keyboard shortcut or put a button in the ribbon.

Dim ws As Worksheet Dim i As Long Dim bGrid As Boolean Dim iActive As Long Application.ScreenUpdating False Store the active sheet iActive ActiveSheet.Index Create new window ActiveWindow.NewWindow Loop through worksheets of original workbook and apply grid line settings to each sheet.

It could probably also be made more efficient by storing the gridline property values in an array, then looping through the other windows.

I think it could be pretty labor intensive if your workbook has a lot of worksheets.

How To Look For Doubles In Excel Mac