Excel - Show top three rows when scrolling

I thought I knew how to do this but it did not work.

I went to Page setup, Sheet and typed in $1:$3 but it did not work.
What am I doing wrong?

Thanks in advance.
Doug

  Dave Peterson replied to Doug Mc

It sounds like you set the rows to repeat at top when the worksheet is printed.

If you want to always see rows 1:3 on the display, then...

Select A1 (just so it is visible)
select A4
Window|freeze panes

Everything above the activecell and to the left of the activecell will be
frozen.




--

Dave Peterson

  Doug Mc replied to Dave Peterson

Worked like a champ Dave.
Thanks,
Doug

Print Page Totals Excel On each page printed I want to sum a column on that page and print that total on the bottom of that page, probably in the footer (ie a total amount for a data entry balancing process performed elsewhere). Each page has its own total it's not a running total. I've tried variations of test' is a named column label: Public Sub Worksheet_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.RightFooter = "Page Amount = " & Sum([test]) End Sub It doesn't like the Sum function in this event specify the range that you want to sum that is ' visible on this particular printed page dblSum = Application.WorksheetFunction.Sum( rngTest ) ActiveSheet.PageSetup.RightFooter = "Page Amount = " & dblSum Regards, Bill Thanks Bill. - - Doug F. A followup. If I have this code

is equal to a row of cells? Basically, I want the first row of my worksheet to be at the top of every page I print of a 50 page sheet. Any help would be greatly appreciated. Thanks Adam Bush Excel Miscellaneous Discussions Excel 2003 1) Page (1) Worksheet (1) Adambush4242 (1) In xl2003: File | Page setup | Sheet tab | Rows to repeat at top: point and click at row 1 or type 1:1 in that box. This isn't the page header, though. This is essentially the field headers. - - Dave Peterson Dave, Thanks you very much that is exactly what I am looking for. Adam Bush keywords

Print Word Object in Excel Excel Friends: I have a three page Word object embedded in Excel. Only the first page prints. I believe this to be a limitation of OLE as implemented in Office. Can workaround? I have multiple worksheets that contain financial data and / or analysis. I have a worksheet containing the Word object that contains explanatory notes, etc., to the analyses. My desire is a common header and footer (generated by Excel). The problem is that only the first page of the Word object prints instead of the entire embedded document. TIA = Mac = Excel Miscellaneous Discussions Excel (1) Split your document into 3 different one page documents and have 3 embedded documents??? - - Dave Peterson Dave: Thanks so much for your response. I actually do that now, but the text changes enough Have you considered just copy | pasting all the word document's text into an Instruction worksheet- -just keep the text in excel? - - Dave Peterson Dave: Have you ever pasted a document

sheet name change Excel Hi all. I've got a macro that copies a worksheet from a template workbook, and provides a name of my choosing. More frequently of late, the macro is changing the name of an existing hidden worksheet to match the name that I choose, instead of the newly added worksheet. I know that because I'd check the name to ensure it didn't exist Editable: = True Set TmpltWB = ActiveWorkbook WkBkName = InputBox(prompt: = "enter workbook name of where to copy worksheet", Title: = "Copy worksheet to existing workbook") If Len(WkBkName) = 0 Then Exit Sub WkBkName1 = WkBkName & ".xlsx" Workbooks(WkBkName1 Sheets(ShtCnt) NewNm = InputBox(prompt: = "What is the sheet number you want to call this worksheet?", Title: = "New Abstract Worksheet Name") Sheets(Sheets.Count).Name = NewNm TmpltWB.Activate TmpltWB.Close SaveChanges: = False 'make some additions to this which will copy the headers of the last abstract worksheet. 'the goal being to copy the Decreed owner's name and the successor if any