Mar 14, 2024 · Hi, I have 8 columns of data each with a header name (Row 1) For each row of data I need a formula that will return the header name if there is a value in that column. Each row of data …

Mar 16, 2006 · I have always sorted a column in Excel by clicking on one cell in the column to highlight it and then clicking on the A-Z or Z-A icons. Now the column headings are sorted along with the other …

Dec 29, 2005 · I have an excdel workbook, containing a number of worksheets. They each have headers and footers set up, but the headers all need to have a border around them. Is this possible?

May 15, 2006 · Re: Can you put a formula in a header? Rather than pulling a static cell value into a Header, I need to pull a different cell value into the header that changes with each page.

Feb 16, 2006 · The Header/Footer width does not adjust when I widen the page width. The Header/Footer appears to default to a 1" margin, even though I adjusted my document width to be …

Nov 1, 2016 · header/footer sizing issues when saving excel 2011 sheet to .pdf By marks2020 in forum Excel General Replies: 0 Last Post: 10-15-2014, 01:26 PM

Feb 18, 2005 · Anyone know how to stop the header from repeating on every page? I didn't think that "rows to repeat at top" was applicable and there is no checkbox that I can find under the Header tab. …

Jun 29, 2006 · I´m trying to save a custom made header & footer because I´m useing it in multiple worksheets and it is repeating the whole time. Can somebody tell me, how I could save my header & …

Jan 13, 2016 · Re: Column Headings Disappear when Scrolling There is nothing to turn off that "feature" built into Excel. If the table headers are not in the first row, Excel's column headers remain visible but …

May 31, 2006 · Can I copy headers and footers from one worksheet to another in a workbook without copying the entire sheet?