Scribd
Upload
23 views7 pages

Excel Weekly Planner Template

This document provides instructions for using an Excel weekly planner template. It contains 4 sections - the first outlines the different sheets in the template, including a setup sheet to enter settings, a week plan sheet protected with formulas, and an admin sheet with dropdown lists. The second section shows the weekly planner setup options. The third section displays the formatting options for line spacing in the to-do list. The last section provides links to additional Excel resources from the template publisher.

Uploaded by

danikamahnic
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
23 views7 pages

Excel Weekly Planner Template

This document provides instructions for using an Excel weekly planner template. It contains 4 sections - the first outlines the different sheets in the template, including a setup sheet to enter settings, a week plan sheet protected with formulas, and an admin sheet with dropdown lists. The second section shows the weekly planner setup options. The third section displays the formatting options for line spacing in the to-do list. The last section provides links to additional Excel resources from the template publisher.

Uploaded by

danikamahnic
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Instruction Page

Excel Weekly Planner Template

Related tutorials
Conditional Formatting Examples
Drop Down List with Data Validation

Notes
1 Setup sheet -- Enter the week's start date, and other settings
2 WeekPlan Sheet
Sheet is protected, with NO password
Many cells contain formulas, and those cells are locked
Rows 2:3 are hidden - they contain date format info
Formulas in the Date headings use that info to calculate & format the dates
Columns K:L are hidden - they contain To Do List line formulas
Conditional formatting in the To Do List uses that info to show lines
3 Admin sheet -- tables used for drop downs on the Setup sheet
4 Cell Styles
To modify a Cell Style, on the Home tab, click Cell Styles
• Right-click on a style, and click Modify
• Click Format, then make changes
• Click OK twice, to save changes
Weekly Planner Setup

Start Date 8/14/2022 Sunday

Weekdays Sun

Day Section 1 To Do Today


2 Appts Today If blank, dividing line is removed
3 Notes Today If blank, dividing line is removed

To Do Lines Triple Spaced

Week Note Try something new! (You can leave this blank)
18 chars
this blank)
Aug 14 Aug 15 Aug 16 Aug 17 Aug 18 Aug 19 Aug 20
Sun Mon Tue Wed Thu Fri Sat
To Do Today To Do Today To Do Today To Do Today To Do Today To Do Today To Do Today

Try something new


Week To Do List

Appts Today Appts Today Appts Today Appts Today Appts Today Appts Today Appts Today

Notes Today Notes Today Notes Today Notes Today Notes Today Notes Today Notes Today

[Link] Copyright © Contextures Inc. 01/23/2024


Line Spacing Weekday Format

Triple Spaced 3 Sun ddd

Lines LineID WD_Format WD_Code


None 0 Sun ddd
Single Spaced 1 Sunday dddd
Double Spaced 2
Triple Spaced 3
Contextures Sites & News
Contextures Excel Tips Website
Contextures Excel Blog
Excel Pivot Tables Blog
Contextures Excel Newsletter

Excel Products
Contextures Recommends

[Link] 01/23/2024
Hundreds of tutorials, tips and sample files
Excel tutorials and tips, with comments and questions
Pivot table tutorials and tips, with comments and questions
Get emails with Excel tips, links, and news

Excel tools and training, recommended by Debra

[Link] 01/23/2024

You might also like