column headings

  1. J

    Map column headings with different spelling/naming then find/copy column from one sheet to another

    Hello, I am in a bit of a strange predicament, where the column headings on my system A generated report do not match the column headings that I NEED on my import sheet for system B. Also, the system A generated report has additional columns that I don't need. I have two worksheets... "2 -...
  2. Q

    Conditional format based on cell value in same column, different row

    I have several documents listed in a cross-reference chart, so I can tell when one document is referenced by another. I've place an X where they intersect. I can click on a document on the left side and highlight the entire row (or on a document along the top and highlight the entire column)...
  3. C

    Importing Data us Excel Data/From Other Sources/MS Query

    I'm using MS Query to create reports that can be refreshed (Data/From Other Sources/MS Query). Once the data is pulled into Excel (2007), the column headings are those of the Safari report that I am querying. I can update the SQL code with <select field name> as <new name> but this is...
  4. G

    Freeze both Row 1 & Row 2?

    Hi Mr. Excel, I use: Excel 2007, Windows XP, Internet Explorer. I would like to freeze both row 1 and row 2 and nothing below. When I select the top two rows(via the numbers to the left) and select "Freeze Panes" it freezes rows 1-11 instead of rows 1-2. Is there any way to fix this...

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