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...

Some videos you may like

This Week's Hot Topics