Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video I explain how to fix the issue with Gridline and Freeze Panes settings not applying to New Windows in Excel. This solution uses a VBA macro to quickly create the new window, apply the settings, and put the windows in split screen view.

Download the Excel file that contains the macro: https://www.excelcampus.com/tips/new-window-gridlines-freeze-panes/

The settings for the gridlines and freeze panes can be lost if you save the file in the new window. So the macro helps prevent this issue that can cause a lot of frustration and re-work.

The macro can be added to your Personal Macro Workbook (PMW). Checkout my video series on how to create your Personal Macro Workbook.

https://www.youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzMw4NE0oFy5sI0_

In that playlist I also have a video on how to create macro buttons in the Ribbon and Quick Access Toolbar, so you can quickly run the macros from any open file. Here is a direct link to that video.

https://youtu.be/dmdolFcS-fI

You can also create a custom keyboard shortcut to run the macros. Here is a link to a video that explains how to set it up.

https://www.youtube.com/watch?v=w_d6HzylJ3Q

The macro performs the following steps, which will save you a lot of time if you are using the New Window feature frequently.

1. Creates the New Window.

2. Loops through all sheets in the new window and applies all of the following settings from the original window: Gridlines, Freeze Panes, and Headings. The macro identifies the cell (row/column) that the freeze panes are applied to and applies it the same way to the new window.

3. Activates the original sheet in the original and new window. The sheets must be activated in the loop to apply the window level settings.

4. Arrange the windows in vertical side-by-side split screen view. This uses the Arrange method (Arrange All button).

5. Scroll to the active tab in the workbook so you can view it. The split screen can cause the active sheet tab to be out of view. So this prevents you from having to scroll to find it.
00:00 Introduction
00:11 Gridlines & Freeze Panes Disappear in a New Window
03:35 The New Window Macro
04:16 The New Window Macro VBA Code