Member Avatar for AQWst
AQWst -2 Light Poster

Hello--
I have two Microsoft Excel questions that I am not sure if I should post them separately or if it is okay that I post them both here. Also, I was not sure where to post them, so if someone sees this and can answer my questions or route this to the proper area, it would be greatly appreciated.
My two questions are as follows:
1) I have a workbook of several spreadsheets, each having their own unique Header, column headings and cell data. How is the best way to get the column headings to repeat on multiple pages of each spreadsheet? Do they have to be included in the header or is there another way to do it?
2) I am compiling a list of Norwegian Lighthouses. I want to be able to create a workbook with this list sorted many different ways. Included with this will be a sort by the name of the lighthouse. Because of the extra letters in the Norwegian alphabet, of Ӕ, ӕ, Ø, ø, Å, and å I can not get the lighthouses with these letters to sort properly. (I am using a version of Microsot Excel of 2010, the United States edition, and am not sure if there is something I need to add to get the sort to work properly). Is there some trick I can do to include these letters to be able to sort them correctly?
Thank you very much.

Edited by pritaeas because: Moved
  • 1 Contributor
  • 0 Replies
  • 184 Views

Dani AI

Generated

Brief answers for both questions (for ):

To repeat column headings on printed pages: use Print Titles rather than the Header. Open the worksheet, go to Page Layout → Print Titles (Page Setup) → Sheet tab → set “Rows to repeat at top” (for example type $1:$1 or select the header row). That will print the actual worksheet row(s) at the top of every printed page and keeps alignment with columns. To keep headings visible while you work on the sheet, use View → Freeze Panes → Freeze Top Row (or select the cell below/right of the area you want frozen and choose Freeze Panes). (support.microsoft.com)

Sorting Norwegian letters (Æ/æ, Ø/ø, Å/å): Excel’s sort follows the computer’s locale/collation, so the cleanest fix is to set Windows’ Region/Formats to a Norwegian locale and then re-sort — that gives the proper Norwegian order (A–Z, Æ, Ø, Å). If you cannot change system settings (or the file will be used on machines with different locales), add a helper “sort key” column and sort by that. Example small workflow:

  1. Insert a new column next to your lighthouse names.
  2. Put this formula in the first helper cell and copy down:
    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A2),"æ","{"),"ø","|"),"å","}")
  3. Sort your sheet on that helper column ascending. The {, |, } characters sort after z, producing the Norwegian sequence Æ < Ø < Å. Test on a copy and adjust if you use the old “Aa” spelling for Å. (support.microsoft.com)

Notes and cautions: changing the OS locale affects date/currency formats system‑wide; use the helper column if you need portability. If many sheets need the same printed header, set Print Titles on each sheet (or use a small VBA macro on a copy). Always verify with Print Preview and test sorts on a copy before applying to production data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.