If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lock a row at top for titles of columns?
Is there a way to lock the top row that contains the description of columns
|
#2
|
|||
|
|||
Thank you
"CyberTaz" wrote: Hi bart- Make sure you are in Normal View (_not_ in Print Preview) & go to FilePage Setup. On the Sheet page specify what Row(s) to repeat at top. HTH |:) "bart dotzman" wrote: Is there a way to lock the top row that contains the description of columns |
#3
|
|||
|
|||
Hi bart-
Make sure you are in Normal View (_not_ in Print Preview) & go to FilePage Setup. On the Sheet page specify what Row(s) to repeat at top. HTH |:) "bart dotzman" wrote: Is there a way to lock the top row that contains the description of columns |
#4
|
|||
|
|||
Lock a row at top for titles of columns?
I do not have a printer installed, nor want to nor will ever have. I use
Excel as a database then send my creation via email. I would like my title row to not be numbered at all (or maybe "A") So that the row numbers accurately reflecr the number of entries - one loses track when getting to say, row #87, and one forgets to subtract 1. |
#5
|
|||
|
|||
Lock a row at top for titles of columns?
Freeze row 1 by selecting A2 and WindowFreeze Panes.
Insert a column left of your data and in A2 enter =ROW()-1 Drag down as far as you wish. ToolsOptionsView. Uncheck "Row and column headers" I think you have to have a printer installed. Excel bases its settings on the default printer. Gord Dibben MS Excel MVP On Sat, 23 Aug 2008 08:58:00 -0700, Canopus wrote: I do not have a printer installed, nor want to nor will ever have. I use Excel as a database then send my creation via email. I would like my title row to not be numbered at all (or maybe "A") So that the row numbers accurately reflecr the number of entries - one loses track when getting to say, row #87, and one forgets to subtract 1. |
#6
|
|||
|
|||
Lock a row at top for titles of columns?
But.....................
That won't change the actual real row address, just the display. Gord On Sat, 23 Aug 2008 11:02:43 -0700, Gord Dibben gorddibbATshawDOTca wrote: Freeze row 1 by selecting A2 and WindowFreeze Panes. Insert a column left of your data and in A2 enter =ROW()-1 Drag down as far as you wish. ToolsOptionsView. Uncheck "Row and column headers" I think you have to have a printer installed. Excel bases its settings on the default printer. Gord Dibben MS Excel MVP On Sat, 23 Aug 2008 08:58:00 -0700, Canopus wrote: I do not have a printer installed, nor want to nor will ever have. I use Excel as a database then send my creation via email. I would like my title row to not be numbered at all (or maybe "A") So that the row numbers accurately reflecr the number of entries - one loses track when getting to say, row #87, and one forgets to subtract 1. |
#7
|
|||
|
|||
Lock a row at top for titles of columns?
On the Sheet page - I have tried to tell it to freeze row 1 but If I type in
a 1 then it says "reference not valid" If I type a1; IV1 it says formula contains errors - so how do I tell it to keep row 1 at the top? "CyberTaz" wrote: Hi bart- Make sure you are in Normal View (_not_ in Print Preview) & go to FilePage Setup. On the Sheet page specify what Row(s) to repeat at top. HTH |:) "bart dotzman" wrote: Is there a way to lock the top row that contains the description of columns |
#8
|
|||
|
|||
Lock a row at top for titles of columns?
Use $1:$1 or just select it by clicking on that funny looking sheet icon to
the right of the little box and it will take you to the sheet, then click on row 1 in the row header -- Regards, Peo Sjoblom "Felicity11" wrote in message ... On the Sheet page - I have tried to tell it to freeze row 1 but If I type in a 1 then it says "reference not valid" If I type a1; IV1 it says formula contains errors - so how do I tell it to keep row 1 at the top? "CyberTaz" wrote: Hi bart- Make sure you are in Normal View (_not_ in Print Preview) & go to FilePage Setup. On the Sheet page specify what Row(s) to repeat at top. HTH |:) "bart dotzman" wrote: Is there a way to lock the top row that contains the description of columns |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
LOCK columns | Rebecca | New Users | 2 | February 26th, 2005 05:03 PM |
Want to combine columns and horizontal lines in complex chart - Can it be Done?! | James Hobart | Charts and Charting | 3 | February 18th, 2005 02:23 AM |
Summing only values in visible columns, not in hidden columns | BW | General Discussion | 1 | November 2nd, 2004 06:23 PM |
Columns 'line between' problem | Jim | Page Layout | 4 | June 10th, 2004 04:15 AM |