Announcement

Collapse
No announcement yet.

Excel tips

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel tips

    I'm working on a costume database and I have an Abbreviations Key section that I would like to stay in the same place as I scroll down the list. Is there a way to keep the section in place for while I scroll through the rest of the page?

  • #2
    Easiest way is to go to the Window menu and select Split, then move it around as needed. You can also use the Freeze Panes option in the same menu for similar results. You can adjust the split or freeze lines by centering the mouse over the marker line and click-dragging it to where it works for you.
    The Rich keep getting richer because they keep doing what it was that made them rich. Ditto the Poor.
    "Hy kan tell dey is schmot qvestions, dey is makink my head hurt."
    Hoc spatio locantur.

    Comment


    • #3
      Thanks for the tip. It sort of helps with the column titles, but not the rest of the key. I'm trying to keep A & B 1-25 in place while columns C and on scroll. It's complicated. Maybe I should just redo my whole costume log. Bleh.

      Comment

      Working...
      X