# Excel Help-Freezing a section
**URL:** https://forums.speedlife.net/t/excel-help-freezing-a-section/61785
**Category:** NYSpeed Off Topic
**Created:** [January 23, 2009, 10:06am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785 "2009-01-23T10:06:16Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)
#### Post date: [January 23, 2009, 10:06am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/1 "2009-01-23T10:06:16Z")
So I know how to freeze panes, but all I need is to freeze off a section (it contains a macroed button I need for the rest of the sheet). Is there anyway to freeze just a specific section, column A and row 12 and up.
thanks
---
### Author:  [@MOBOOST4U](https://forums.speedlife.net/u/MOBOOST4U)
#### Post date: [January 23, 2009, 10:11am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/2 "2009-01-23T10:11:13Z")
It can be done … I just forgot how lol
GL
---
### Author:  [@newman](https://forums.speedlife.net/u/newman)
#### Post date: [January 23, 2009, 10:16am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/3 "2009-01-23T10:16:00Z")
Do you want to make it a data entry type form?
If so, in cell format, any cell you want to be able to edit under “security” uncheck lock.
then go to tools\>protection\>protect sheet
---
### Author:  [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)
#### Post date: [January 23, 2009, 10:25am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/4 "2009-01-23T10:25:59Z")
I actually need the rest of the sheet to be edited, but to keep this small section in place so at any given time in the worksheet I am able to use my sort macro.
Heres my next issue. I want to have a comment sections in this sheet, but I want to be able to limit how far the comment goes so It will break and go on to another line if its too long (making it easy for copy paste into a word doc or email and look like a normal sentence). Is it possible to limit the text and break to go onto another line?
---
### Author:  [@tpgsr](https://forums.speedlife.net/u/tpgsr)
#### Post date: [January 23, 2009, 10:40am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/5 "2009-01-23T10:40:53Z")
just assign the macro to a key sequence and not to a button.
---
### Author:  [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)
#### Post date: [January 23, 2009, 10:53am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/6 "2009-01-23T10:53:10Z")
The people using this file may be pretty computer illiterate, hence trying to make it simple with buttons to do the work for them. I also have text that I use for a drop down menu and it would be nice if I could keep that in a locked location as well. I may just have to use the key bind
---
### Author:  [@tpgsr](https://forums.speedlife.net/u/tpgsr)
#### Post date: [January 23, 2009, 10:54am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/7 "2009-01-23T10:54:29Z")
Can you just move your controls into a “task bar” at the top of the sheet, and lock it there using VBA?
---
### Author:  [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)
#### Post date: [January 23, 2009, 11:08am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/8 "2009-01-23T11:08:11Z")
Also a possiblity, but imagine this is being sent out and used by a bunch of 55+ year old women. If I could make this huge “SORT” button, It would be awesome and all I need is to lock it off in the corner
---
### Author:  [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)
#### Post date: [January 23, 2009, 11:52am UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/9 "2009-01-23T11:52:07Z")
fuck it, I just changed the format of the page and move it all at the top where I froze those panes, thanks anyway.
---
### Author:  [@Treads4Heads](https://forums.speedlife.net/u/Treads4Heads)
#### Post date: [January 23, 2009, 2:05pm UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/10 "2009-01-23T14:05:24Z")
Ok I lied. After its all said n done I dont like the way it looks when sent via email. Is there anyway I can have a space or row put in between each line anwyay?
---
### Author:  [@Jack](https://forums.speedlife.net/u/Jack)
#### Post date: [January 23, 2009, 4:22pm UTC](https://forums.speedlife.net/t/excel-help-freezing-a-section/61785/11 "2009-01-23T16:22:49Z")
I work with a bunch of 55+yr old women. There is no finish line. Ever.