Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Frozen rows
I have created a workbook that has three frozen rows at the top of the page.
Is there a way to start numbering the rows below those 3 first. I.E. XDate XJim Glass huts XSales record ---------- 1 2 3 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Frozen rows
For appearance sake..............................
You can enter =ROW(-3) in A4 then copy down. Then uncheck ToolsOptionsViewRow and Column Headers. BUT for the sake of formulas, A4 is still A4 no matter that it says 1. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 18:20:00 -0800, Old_skills_lost wrote: I have created a workbook that has three frozen rows at the top of the page. Is there a way to start numbering the rows below those 3 first. I.E. XDate XJim Glass huts XSales record ---------- 1 2 3 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Frozen rows
I'm lost, I tried the formula but it gives me an error in formula.
-- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. "Gord Dibben" wrote: For appearance sake.............................. You can enter =ROW(-3) in A4 then copy down. Then uncheck ToolsOptionsViewRow and Column Headers. BUT for the sake of formulas, A4 is still A4 no matter that it says 1. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 18:20:00 -0800, Old_skills_lost wrote: I have created a workbook that has three frozen rows at the top of the page. Is there a way to start numbering the rows below those 3 first. I.E. XDate XJim Glass huts XSales record ---------- 1 2 3 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Frozen rows
I think Gord may have meant to write this...
=ROW()-3 Rick "Learning Excel" wrote in message ... I'm lost, I tried the formula but it gives me an error in formula. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. "Gord Dibben" wrote: For appearance sake.............................. You can enter =ROW(-3) in A4 then copy down. Then uncheck ToolsOptionsViewRow and Column Headers. BUT for the sake of formulas, A4 is still A4 no matter that it says 1. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 18:20:00 -0800, Old_skills_lost wrote: I have created a workbook that has three frozen rows at the top of the page. Is there a way to start numbering the rows below those 3 first. I.E. XDate XJim Glass huts XSales record ---------- 1 2 3 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Frozen rows
YES! Thanks for the correction, it works!
-- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. "Rick Rothstein (MVP - VB)" wrote: I think Gord may have meant to write this... =ROW()-3 Rick "Learning Excel" wrote in message ... I'm lost, I tried the formula but it gives me an error in formula. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. "Gord Dibben" wrote: For appearance sake.............................. You can enter =ROW(-3) in A4 then copy down. Then uncheck ToolsOptionsViewRow and Column Headers. BUT for the sake of formulas, A4 is still A4 no matter that it says 1. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 18:20:00 -0800, Old_skills_lost wrote: I have created a workbook that has three frozen rows at the top of the page. Is there a way to start numbering the rows below those 3 first. I.E. XDate XJim Glass huts XSales record ---------- 1 2 3 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Frozen rows
That's what Gord meant<g
Thanks Rick On Thu, 17 Jan 2008 23:04:45 -0500, "Rick Rothstein \(MVP - VB\)" wrote: I think Gord may have meant to write this... =ROW()-3 Rick "Learning Excel" wrote in message ... I'm lost, I tried the formula but it gives me an error in formula. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. "Gord Dibben" wrote: For appearance sake.............................. You can enter =ROW(-3) in A4 then copy down. Then uncheck ToolsOptionsViewRow and Column Headers. BUT for the sake of formulas, A4 is still A4 no matter that it says 1. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 18:20:00 -0800, Old_skills_lost wrote: I have created a workbook that has three frozen rows at the top of the page. Is there a way to start numbering the rows below those 3 first. I.E. XDate XJim Glass huts XSales record ---------- 1 2 3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
frozen panes | Excel Discussion (Misc queries) | |||
EXCEL SORT - How do I prevent 'frozen' rows from sorting? | Excel Discussion (Misc queries) | |||
Frozen is cell | Excel Discussion (Misc queries) | |||
The top six rows are "frozen" and do not move when I scroll down.. | Excel Worksheet Functions | |||
Printing Frozen Rows | Excel Discussion (Misc queries) |