Using Freeze Pains for Excel Budget Template
Excel Campus - Jon Excel Campus - Jon
569K subscribers
7,379 views
0

 Published On Oct 13, 2022

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

This video is the fourth episode in the Budget Makeover series, where we take a simple budget template and make it more useful and attractive. The series will teach you how to create a budget that has dropdowns, locked cells, formulas, and an interactive dashboard with pivot tables and pivot charts.

In the first three videos, we learned how to lock cells to protect them from being accidentally changed, how to remove duplicate entries in a data list, and how to create a dropdown list.
This fourth video in the series details how to freeze panes so that headers rows and columns are always visible as you navigate a spreadsheet.

If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/tips/budg...


Related Videos:

Budget Makeover - Ep. 1 - How to Lock Cells for Editing in Excel:    • Excel Budget Template Series: How to ...  
Gridlines & Freeze Panes Disappear in New Excel Window:    • Gridlines & Freeze Panes Disappear in...  

EXCEL TIPS & TRICKS:    • Tips & Shortcuts  

#MsExcel #ExcelCampus
00:00 Introduction
01:20 Visibility
03:48 Unfreeze Panes

show more

Share/Embed