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]
Carol Bratt
Mod
Moderators
Forum Posts: 67
Member Since: August 11, 2011
Offline
2
May 7, 2021 - 7:45 pm
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.
shobha
Member
Members
Forum Posts: 94
Member Since: February 8, 2010
Offline
3
May 14, 2021 - 1:02 pm
Thanks carol, thats what I was used to. But in this version it Just is NOT working! Anywhichway.
Dont know what to do.
shobha
Member
Members
Forum Posts: 94
Member Since: February 8, 2010
Offline
4
May 14, 2021 - 1:17 pm
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
Most Users Ever Online: 2303
Currently Online: Arthurbeck, rvdtutors
Guest(s) 34
Currently Browsing this Page: 1 Guest(s)
Top Posters:
Chad Johnson: 867
Mindblower: 701
carbonterry2: 356
Flying Dutchman: 278
grr: 211
Newest Members:
sunny01
snave53
daleoS
annaeat
BjourneX
Forum Stats:
Groups: 8
Forums: 20
Topics: 1974
Posts: 13651
Member Stats:
Guest Posters: 11
Members: 3256
Moderators: 7
Admins: 3
Administrators: Jim Hillier, Richard Pedersen, David Hartsock
Moderators: Carol Bratt, dandl, Jason Shuffield, Jim Canfield, Terry Hollett, Stuart Berg, John Durso