top row

  1. M

    Page number "1/3" in C7 that repeats top of each page in a sheet, Excel VBA

    I have a workbook with several sheets. On every sheet i repet row 1 to 13 on each page. In cell C7 i want page number and total number of pages in the format of "1/3". I have found this VBA code to do part of the problem placed this part in a module Sub PageNumber(MyRange As String)...
  2. K

    Can't scroll to Row 1 in a WorkSheet

    In a workbook with several sheets, I can't scroll up to row 1 in one particular worksheet. Can only go to row 2. Other sheets behave normally. Any suggestions? Split and freeze Panes are not activated. Thanks.
  3. R

    Match two cells in a different table - bring back top value

    I need a formula for this example Cell - Value A29 - FY14-2 - match if this value is in the first column then B29 - FY14-3 - and match if this value is in either second, third, fourth and etc.... Match the two cells to the below table and bring me back the value of the top row = answer would...
  4. P

    Hyperlink results to display on top row

    I;m new to this site and this is my first post. I'm an average user of Excel. The problem is stated below. I;ve 2 sheets created in a single spreadsheet - 1st one has checklist items with number reference and each of these number references has been hyperlinked to another sheet (named cells) (...
  5. Jeffrey Mahoney

    Gift for the Community (Select Any Part of a Range)

    The Function below allows you to return a smaller section of a range provided. Returnable ranges are: - a cell - a range - a row - a column - multiple rows or columns - last row or column - multiple rows at the bottom - multiple columns on the right All I ask is that you LIKE this or post you...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top