Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Display only certain cells
I have an assignment to create a Timeline document with a calendar that
displays only the current month & the 2 months following. I started with a Word document, pasted into it a calendar I made in Excel, then adjusted the object boundaries to only display the 3 months. Is there a function that will cause the calendar to automatically display the current & 2 months following? I'm so lost! |
#2
|
|||
|
|||
Display only certain cells
How is your Calendar set up in Excel?
Could use conditional formatting and =month(now()) <=month(Now()) to black out other months Or if you use VBA could hide rows & columns using the above arguments in the Workbook_Open Event How complex do you need? Do you want onscreen / Print Zoom ??? "ringersoll" wrote: I have an assignment to create a Timeline document with a calendar that displays only the current month & the 2 months following. I started with a Word document, pasted into it a calendar I made in Excel, then adjusted the object boundaries to only display the 3 months. Is there a function that will cause the calendar to automatically display the current & 2 months following? I'm so lost! |
#3
|
|||
|
|||
Display only certain cells
I'm probably considered a beginner to intermediate user in Excel, with
Functions & VBA being a big weak spot, so please bear with me. The calendar is very simple - each day has a formula which references the cell before it (or the Saturday before) plus one. I have all the months lined up horizontally on the spreadsheet (I wish I could send it to you) - I initially did this so that when I double-click on it in the Word document, I could just scroll over until the correct 3 months were displayed, then click out of it. Also, I'm not sure what you mean by onscreen / Print Zoom. Thanks so much for your help! "Vacation's Over" wrote: How is your Calendar set up in Excel? Could use conditional formatting and =month(now()) <=month(Now()) to black out other months Or if you use VBA could hide rows & columns using the above arguments in the Workbook_Open Event How complex do you need? Do you want onscreen / Print Zoom ??? "ringersoll" wrote: I have an assignment to create a Timeline document with a calendar that displays only the current month & the 2 months following. I started with a Word document, pasted into it a calendar I made in Excel, then adjusted the object boundaries to only display the 3 months. Is there a function that will cause the calendar to automatically display the current & 2 months following? I'm so lost! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
Display empty cells | Excel Discussion (Misc queries) | |||
Display empty cells | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel |