1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Freeze panes not freezing just selection

Hi everyone,

I'm trying to freeze the first four columns in a sheet (status, last name, first name, client number) and no matter what I do, either the fourth column doesn't freeze or it freezes the next two (so 6 total columns) too. I have highlighted just the four I wanted and clicked "freeze panes" and it just keeps going back and forth between freezing only the first three or freezing the first 6. Does anyone know what I'm doing wrong or what might be going on?

Thank you!

EDIT: I fixed this myself. I selected the column to the right of the last one I wanted to freeze and clicked freeze panes rather than following the suggestions I saw on microsoft's website about selecting the columns that I wanted to freeze and clicking freeze panes. Editing the flair but leaving this up in case someone else has this problem!

submitted by /u/tashykat
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#freeze panes
#columns
#status
#last name
#first name
#client number
#selection
#highlighted
#editing
#microsoft
#website
#solution
#issue
#total columns
#click
#right column