Hello, I need to put in some excel spreadsheets for training purposes and I want the trainee to be able to swipe through the spreadsheet as desired to review all the columns and content available. I currently have it loaded as graphics that when they swipe it moves to the next slide layer. I am just curious if anyone else has built in an excel spreadsheet using a horizonatal scroll function or other built in? They will have to be able to view it on their mobile device (iPad).
I'm doing this effect in a project now. I got my idea from Michael Hinze.
Take a screenshot of the document. Scroll down once. Repeat until you have screenshot the entire area. After that, you paste the first screen shot on your slide, and then you paste the other screenshots as states within the original screen shot. After that, you link the states with a slider, and format the slider to look like a scroll bar.
You can click on these links to view his working example and his blog post explaining how he did it.
Hi Preston, Thank you for taking the time to provide me that information. I appreciate it! I have done this in the past with a vertical scroll feature but could never find a way to scroll horizontally, the way you would have to manuever right to left through a long excel report.. hope it works! :)
If you are only scrolling horizontally, the principle should be the same, just put your slider across the bottom of your slide instead of on the side. If you are scrolling vertically and horizontally... things could get difficult. At that point, I would probably drop the scroll idea, and maybe come up with an alternative navigation function in a light box. Maybe something like this:
Each arrow would take me to a different slide with a different "tile" of the spreadsheet visible. You could go as granular as you want with the navigations (one column per click, three columns per click, or one "tile" per click), depending on how much work you want to do on it. You could also get creative with frozen panes if you need to see row or column labels at all times.
3 Replies
I'm doing this effect in a project now. I got my idea from Michael Hinze.
Take a screenshot of the document. Scroll down once. Repeat until you have screenshot the entire area. After that, you paste the first screen shot on your slide, and then you paste the other screenshots as states within the original screen shot. After that, you link the states with a slider, and format the slider to look like a scroll bar.
You can click on these links to view his working example and his blog post explaining how he did it.
Hope this helps!
Hi Preston, Thank you for taking the time to provide me that information. I appreciate it! I have done this in the past with a vertical scroll feature but could never find a way to scroll horizontally, the way you would have to manuever right to left through a long excel report.. hope it works! :)
You're very welcome!
If you are only scrolling horizontally, the principle should be the same, just put your slider across the bottom of your slide instead of on the side. If you are scrolling vertically and horizontally... things could get difficult. At that point, I would probably drop the scroll idea, and maybe come up with an alternative navigation function in a light box. Maybe something like this:
Each arrow would take me to a different slide with a different "tile" of the spreadsheet visible. You could go as granular as you want with the navigations (one column per click, three columns per click, or one "tile" per click), depending on how much work you want to do on it. You could also get creative with frozen panes if you need to see row or column labels at all times.
This discussion is closed. You can start a new discussion or contact Articulate Support.