Cant Free Excel columns and rows

Avatar

Please consider registering
Guest

Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_topic_old
Cant Free Excel columns and rows
Avatar
shobha
Member
Forum Posts: 83
Member Since:
February 7, 2010
sp_UserOfflineSmall Offline
1
May 6, 2021 - 1:03 pm
sp_Permalink sp_Print sp_EditHistory

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
Forum Posts: 67
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
2
May 7, 2021 - 7:45 pm
sp_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
Forum Posts: 83
Member Since:
February 7, 2010
sp_UserOfflineSmall Offline
3
May 14, 2021 - 1:02 pm
sp_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
Forum Posts: 83
Member Since:
February 7, 2010
sp_UserOfflineSmall Offline
4
May 14, 2021 - 1:17 pm
sp_Permalink sp_Print sp_EditHistory

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:
21 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Member Stats:

Guest Posters: 10

Members: 2626

Moderators: 7

Admins: 4

Forum Stats:

Groups: 8

Forums: 19

Topics: 1846

Posts: 13173

Administrators: Jim Hillier, Richard Pedersen, David Hartsock, Marc Thomas

Moderators: Carol Bratt, dandl, Jason Shuffield, Jim Canfield, Terry Hollett, Dick Evans, Sergey Grankin

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!