Remove or extend the macro scoll bar for fuller view!

[Kishan3000]

Hi All,

I really need some help with a template which I download from the Microsoft website, I want to remove the scroll bar on the sheet so that I can show the gantt chart in a wider view, or maybe widnen the view which is shown - really struggling!

templates.office.com/en-US/Agile-Gantt-chart-TM55723235

Thanks

[Keebellah]

You can do this under Options
Google 'Excel show hide scrollbars' and you'll get all the information you need

[Kishan3000]

Not the excel scroll bar, the embedded one which is in the template - eather remove it or expand the view as it only scrolls to cell BM

[Keebellah]

You can just delete it.
Select it and right click Cut
But why, it helps scroll the gantt chart.

[Kishan3000]

Sorry I'm not explaining myself properly, what I want to do is to expand the view so I can see more of the gantt chart - at the moment it only shows to row BM - however as the timelines are longer and I want to show the whole end to end time lines on a presentation, then I would like to zoom in and out to present, rather than scrolling accorss.

So is there a way to expand the view more than cell BM, or is there away to not have the scroller so then it shows everything?

Apologies for confusion

[Keebellah]

Just copy and paste.

I'm sure you can manage from here.
Common sense and a little imagination

Happy coding

[AliGW]

I think you are confusing common sense with a basic understanding of how Excel works. For someone to have the latter, they need to learn. Learning comes from being appropriately guided, so let's hope that the OP understands what you have done in the attachment. If they don't, then be prepared to explain it to them in specific detail.

It really has nothing to do with imagination. Please remember that what those of us who've been using Excel for years take for granted may be a complete mystery to novices.

[Keebellah]

Okay, reading the way the question was posted and it's content and first answer I assumed (maybe incorrectly) that the OP has more than average knowledge of Excel.
I'll wacht my words in the future
Thanks Ali

[AliGW]

It's quite a complex template - beginners often start with templates that are fine until they decide they want to change them!

[Kishan3000]

Thank you so much and I'm here to learn so please do tell me how it was done so hopefully I can do it myself and maybe help someone else in the future - again thank you, everyone,

[Keebellah]

I just copied the columns to the right the number of columns required as well as the scroll bar, just click it and expand it.
There is no technique in there, just look at the formulas, I do not know another way to explain it.

[butthead69]

Not helpful. All this accomplished was to make the scroll bar wider... This did not in any way enable the view of the full timeline.

OP was pretty clear and this is the same issue I am having. The need is to display all cells for the entirety of the project timeframe without the need to scroll. Ex: I would like the months of April-July to be displayed. I don't want any other month to exist and I want to be able to see the full timeline of April-July at once with no scrolling needed. How can this be accomplished?

[Keebellah]

@butthead69: as the office version at your location to help you

[AliGW]

@butthead69

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread