Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock two rows
I want to be able to lock two rows in my spreadsheet. However here is the
hard part, I want to be able to add columns to that worksheet just not to those two rows. So lock rows 8 and 9, then add a column to the worksheet but the column is not added to rows 8 and 9. Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock two rows
What you describe cannot be done. The number of columns and rows on a worksheet cannot be changed. However, you can insert cells. Try ... selecting B1:B7, right-clicking and choosing "Insert" from the popup menu, then choosing "shift cells right" from the dialog box. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Needs Help" wrote in message I want to be able to lock two rows in my spreadsheet. However here is the hard part, I want to be able to add columns to that worksheet just not to those two rows. So lock rows 8 and 9, then add a column to the worksheet but the column is not added to rows 8 and 9. Please help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock two rows
Cannot be done.
First of all you cannot lock two rows together, although you Freeze rows 1 and 2 so they remain on screen as you scroll down. Second of all a column encompasses all rows of of a sheet. Re-think your needs. Gord Dibben MS Excel MVP On Thu, 31 Jan 2008 09:09:03 -0800, Needs Help wrote: I want to be able to lock two rows in my spreadsheet. However here is the hard part, I want to be able to add columns to that worksheet just not to those two rows. So lock rows 8 and 9, then add a column to the worksheet but the column is not added to rows 8 and 9. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock column size for some rows and resize for other rows. | Excel Discussion (Misc queries) | |||
Can I lock rows? | Setting up and Configuration of Excel | |||
Is there a way to lock two or more rows together? | Excel Worksheet Functions | |||
How do I lock rows together? | New Users to Excel | |||
Lock Rows | Excel Discussion (Misc queries) |