Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-02-2012, 11:27 AM
NMuser NMuser is offline Split Gantt view like an Excel spreadsheet Windows 7 64bit Split Gantt view like an Excel spreadsheet Office 2007
Novice
Split Gantt view like an Excel spreadsheet
 
Join Date: Aug 2012
Posts: 2
NMuser is on a distinguished road
Default Split Gantt view like an Excel spreadsheet


We have a project plan that contains about 2,000 rows. It would be very helpful to split the Gantt view horizontally, similar to how a spreadsheet in Excel or a document in Word can be split. Our goal is to see two different sections of the Gantt spreadsheet at the same time. Is there a way to do this? Thanks.
Reply With Quote
  #2  
Old 08-02-2012, 12:37 PM
JulieS JulieS is offline Split Gantt view like an Excel spreadsheet Windows 7 64bit Split Gantt view like an Excel spreadsheet Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You can split your screen (Windows > Split for 2007) but it won't accomplish what I think you are looking for. In Project, when you split your screen, you see detailed information in the lower pane relating to what task you have selected in the upper pane.

However, all is not lost. Open a second window of the same file (Window, new Window) and then arrange the windows.

I hope this helps.

Julie
Reply With Quote
  #3  
Old 08-20-2012, 11:14 AM
NMuser NMuser is offline Split Gantt view like an Excel spreadsheet Windows 7 64bit Split Gantt view like an Excel spreadsheet Office 2007
Novice
Split Gantt view like an Excel spreadsheet
 
Join Date: Aug 2012
Posts: 2
NMuser is on a distinguished road
Default

Thank you for the suggestions, Julie. After some experimenting, we found the following approach to be almost what we needed.

1. Select any column in Gantt view (indicator column is least intrusive to us)
2. Window, Split
3. Click anywhere in lower window
4. View, Gantt Chart

Notes:
1. Each window can be scrolled independent of the other.
2. As long as one column is selected in the upper window, all rows appear in lower one.
3. Changes made in either window are reflected in the other.

Hope others find this useful.
Reply With Quote
  #4  
Old 08-21-2012, 04:30 AM
JulieS JulieS is offline Split Gantt view like an Excel spreadsheet Windows 7 64bit Split Gantt view like an Excel spreadsheet Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Thank you for posting detailed information about what works for your scenario. I'm sure others will also find it helpful.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Split Gantt view like an Excel spreadsheet Push data automatically from Acess or Excel to create a Gantt chart in Project GST2212 Project 3 07-06-2012 12:52 PM
Excel 2010 Format cells to use as Gantt or Plan Kizzie Excel 0 12-13-2011 02:31 AM
Split Gantt view like an Excel spreadsheet Inserting excel spreadsheet into word doc educpara58 Excel 2 07-28-2011 01:22 AM
Split Gantt view like an Excel spreadsheet Gantt Chart: MS Project vs. Excel Nance Project 2 12-09-2008 01:59 PM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft