Avatar
Please consider registering
guest
sp_LogInOut Log Insp_Registration Register
Register | Lost password?
sp_Search Search
Advanced Search
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
Go to Bottom
sp_Feed Topic RSSsp_topic_old
Cant Free Excel columns and rows
Avatar
shobha
Member
Members
May 6, 2021 - 1:03 pm
Member Since: February 7, 2010
Forum Posts: 92
sp_UserOfflineSmall Offline
Go to Top
1sp_EditHistory sp_Permalink sp_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
Mod
Moderators
May 7, 2021 - 7:45 pm
Member Since: August 11, 2011
Forum Posts: 67
sp_UserWebsite
sp_UserOfflineSmall Offline
Go to Top
2sp_Permalink sp_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
Member
Members
May 14, 2021 - 1:02 pm
Member Since: February 7, 2010
Forum Posts: 92
sp_UserOfflineSmall Offline
Go to Top
3sp_Permalink sp_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
Member
Members
May 14, 2021 - 1:17 pm
Member Since: February 7, 2010
Forum Posts: 92
sp_UserOfflineSmall Offline
Go to Top
4sp_EditHistory sp_Permalink sp_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!

sp_Feed All RSS
Go to top
Forum Timezone: America/Indiana/Indianapolis
Most Users Ever Online: 2303
Currently Online:
Guest(s) 185
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Chad Johnson: 867
Mindblower: 688
carbonterry2: 356
Flying Dutchman: 278
grr: 211
Member Stats:
Guest Posters: 11
Members: 3239
Moderators: 7
Admins: 3
Forum Stats:
Groups: 8
Forums: 20
Topics: 1962
Posts: 13593
Newest Members:
lgold1p, dasekta9@gmail.com, tdhunt@live.com, cp5cp8, EndaDeRoade
Moderators: Carol Bratt: 67, dandl: 740, Jason Shuffield: 1, Jim Canfield: 8, Terry Hollett: 0, Stuart Berg: 0, John Durso: 0
Administrators: Jim Hillier: 2710, Richard Pedersen: 221, David Hartsock: 1117
Scroll to Top