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. I originally posted this to the community page, but when I reviewed my last Excel question, I saw that it had been moved to the Software Development page, I decided to post it here instead. I am not sure how to delete it from the other page, but I will try. If I am not successful, I appologise if this will appear to be posted twice.
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, 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.
Question 1) I think this can be solved with a macro.
Question 2) Did you look in the Options--> Languages section?
You might also find something on sorting on google.
Hope it helps a bit.
What ddanbe says. For #2 you need to change the language to Norwegian so it will deal with the extra letters, accents, and such.
I got the column headings appear on multiple pages, but even after I have added the Norwegian Language to the Editing language and exited out of Excel and went back in, the sort is not appearing in the proper order. (The Norwegian letters are appeg right after their similar English letters. I did a Google search and it says something about using the Danish language because there is a bug in the Windows 7 operating system, but can not find that one to be able to add. Does anyone have any suggestions? I almost forgot, but thought I would add a link to the web site answer I found to the sorting issue.
Here it is.....Click Here
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.