Announcement

Collapse
No announcement yet.

Excel columns repeated in same sheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel columns repeated in same sheet

    Hi

    Does anyone know what is happening with this Excel sheet?

    One of our finance staff asked how this had happened but I have never seen this before.

    Initially I thought it was a Freeze Panes config but the entire sheet is being repeated on the right and the area enclosed by the red ellipse can be dragged so that the position of the division between the two can be adjusted left or right.

    Searching for 'excel columns duplicated' or 'repeated' just brings up gazillions of links to repeating column headers or using Freeze Panes.

    Can anyone enlighten me, please?



    Thanks!
    A recent poll suggests that 6 out of 7 dwarfs are not happy

  • #2
    Re: Excel columns repeated in same sheet

    It is not frozen panes but there are horizontal and vertical splitter bars which allow viewing different parts of the window side by side.
    Just drag the bar you identified in your picture to the margin (cant remember if left or right) and it will revert to a single view
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: Excel columns repeated in same sheet

      Haha! Thanks, Ossian! I knew it would be easy but as it was an Accounts file I was not going to mess with it.

      I see now where I went wrong - when I use the splitter I always freeze it which converts the 'bar' into a 'line', hence why I did not recognise it.

      Thanks again
      A recent poll suggests that 6 out of 7 dwarfs are not happy

      Comment

      Working...
      X