Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel Spreadsheet (Excel 2010 version) with lots of data. There are around 20 columns and thousands of rows. Now the column widths are big so the columns don't fit on the screen and I have to scroll right to see the additional columns.

Is there a way that I can design a custom view where some columns can be on the top and some on the middle and bottom of the visible screen, so I can see all the data without scrolling?

I know Excel has a built in Form which helps to view, add , edit data but if there are many columns then we have to scroll down, right? Also in the standard Form the columns are given one below the other- we cannot 'place' then in a customised position e.g. place last name to the right side of first name ?

Screenshot of my requirements

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.