Avatar
Log In
Please consider registering
Guest
Search
Advanced Search
Forum Scope


Match



Forum Options



Min search length: 3 characters / Max search length: 84 characters
Search
Register
Register Lost password?
sp_topic_old
Cant Free Excel columns and rows
RSS
Avatar
shobha
92 Posts
(Offline)
1
May 6, 2021 - 1:03 pm
Print

Hi People
I have MS Home and Student 2016.
Win 10 Home Single language.

In excell I am unable to freeze column And Rows. There is option for only one.
In previous version I could do both.
But in this forget both, i cant do even one. What to do?
Thanks in advance.

Shobha [center]

Avatar
Carol Bratt
67 Posts
(Offline)
2
May 7, 2021 - 7:45 pm
Print

Hi Shobha,

To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes. You will want your pointer to be below the row(s) you want to freeze and to the right of any column(s) you want to freeze.

Avatar
shobha
92 Posts
(Offline)
3
May 14, 2021 - 1:02 pm
Print

Thanks carol, thats what I was used to. But in this version it Just is NOT working! Anywhichway.
Dont know what to do.

Avatar
shobha
92 Posts
(Offline)
4
May 14, 2021 - 1:17 pm
Print

Ok, After posting , asked Google aunty. It seems the sheet protection was on so couldnt freeze. after unprotecting it is working as usual.

Whew! They do make it complicated rather than making simple in newer versions!

Thanks everyone for pondering!

Forum Timezone: America/Indiana/Indianapolis
All RSSShow Stats
Administrators:
Jim Hillier
Richard Pedersen
David Hartsock
Moderators:
Carol Bratt
dandl
Jason Shuffield
Jim Canfield
Terry Hollett
Stuart Berg
John Durso
Top Posters:
Chad Johnson: 867
Mindblower: 666
carbonterry2: 356
Flying Dutchman: 278
grr: 211
Newest Members:
blutsband
cyberguy
JudeLandry
benjaminlouis680309
drogers97439
Forum Stats:
Groups: 8
Forums: 20
Topics: 1942
Posts: 13520

 

Member Stats:
Guest Posters: 11
Members: 3179
Moderators: 7
Admins: 3
Most Users Ever Online: 2303
Currently Online: jacksalvator
Guest(s) 39
Currently Browsing this Page:
1 Guest(s)
Scroll to Top

WHY NOT SUBSCRIBE TO OUR NEWSLETTER?

Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!