header cell

  1. A

    Dynamic Header with multiple possibilities

    I have a file which can have anywhere between 5 and 500 rows to print. On the top of each page there should be a header but depending on the data below it the header will change thus I cant use the generic header function. I have some coding in that will hide rows if they have no data in them...
  2. K

    [Layout conondrum] How to make a single cell void when freezing the first row?

    Hi fellow Excel users, I have only recently begun dabbling in the way of freezing cells in excel. I have this conondrum which is accordingly... and here I wish I could share some pictures with you, but only being able to share picture HYPERLINKS limits my availability. The conondrum is that I...
  3. C

    Excel Table with Formulae in Header Cells?

    Hi Everyone, Sorry if this is a bit of a silly question but I'm a bit of a Noob when it comes to Excel Pivot tables etc, so please bear with me! I am trying to create a pivot table based on the data from 3 sets of data. To do this, I am first of all trying to create tables around my data...
  4. P

    Link Header to a cell

    Hello, Is there a way to have a header be populated by the value in a cell? For example, I want the header to reflect the value of cell A1. I've been trying some things but haven't had any luck. Thanks.
  5. Z

    Conditional Formatting Based on Column by Which List Is Sorted

    I have a worksheet that contains information in 5 Columns (B:F), I would like to conditionally format the header row to highlight the cell by which the data is currently being filtered (e.g., if the data is filtered by the header row of ColumnB, I would like the header cell in ColumnB to be...

Watch MrExcel Video

This Week's Hot Topics

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
Top