title: creating a scrollable table in Excel with colors
body: <p>First off I want to go ahead and apologize, since i am not an experienced Excel user. I've tried searching but couldn't find the right answers.
  I've been trying to create a scrollable table in Excel and i found the following link/video </p>
  
  <p><a href="http://www.exceltraining101.com/2013/06/create-a-scrolling-table/" rel="nofollow">http://www.exceltraining101.com/2013/06/create-a-scrolling-table/</a></p>
  
  <p>which uses the OFFSET function to create the table. It was easy to follow the steps and i created a similar table. (Since my "Data" sheet contains 200 rows of data, i won't go into details)</p>
  
  <p>Some data on my sheet have colors or color fills but they don't appear in this scrollable list i created. I actually expected that, since the "colors" are not "data" to be transferred.</p>
  
  <p>Is there a way to transfer the data with their colors in the scrollable table using the above method (see link)? Any other suggestions on creating a scrollable table are welcome. Thank you! </p>