+ Reply to Thread
Results 1 to 5 of 5

Excel 2013 no column headers

  1. #1
    Registered User
    Join Date
    11-28-2013
    Location
    Banana Republic
    MS-Off Ver
    Excel 2020
    Posts
    4

    Unhappy Excel 2013 no column headers

    Hi,

    My and a work college needed to combine our separate excel worksheets into a single document.

    Office 2013 didn't have a function to "import sheet from file" so we used open office to import my .xlsx worksheets.

    After we finished importing we exported the final workbook as .xls (so I could open it).

    After opening the workbook on my pc (excel 2013) i notice some of the sheets no longer have column headers, but the row headings still exists.
    (No ABCD, only 1234)

    Also I am unable to use features such as "Freeze Pane"

    I suspect this was caused by importing and exporting through open office?

    I tried solving this by googling but it was unsuccessful.

    I thought I would post this issue with the forum because it doesn't seem to have a solution.
    Thanks
    Last edited by excellisimo; 11-30-2013 at 04:15 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Excel 2013 no column headers

    Use Save As in excel - change the format to .xls - it should open in Open Office no problem. No cutting pasting

  3. #3
    Registered User
    Join Date
    11-28-2013
    Location
    Banana Republic
    MS-Off Ver
    Excel 2020
    Posts
    4

    Re: Excel 2013 no column headers

    thanks for your reply to my thread.


    However I am lost as to why I want to take my data back to open office?

    I am using excel 2013 on my pc?

  4. #4
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Excel 2013 no column headers

    I thought that was your goal, must have misread the question.

  5. #5
    Registered User
    Join Date
    11-28-2013
    Location
    Banana Republic
    MS-Off Ver
    Excel 2020
    Posts
    4

    Re: Excel 2013 no column headers

    I see now that my first post might be a bit confusing, edited

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel 2013 and autocad 2013 LT
    By drailed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2013, 03:05 PM
  2. Link Excel 2013 to Word 2013
    By drosen99 in forum Word Formatting & General
    Replies: 20
    Last Post: 02-26-2013, 08:20 PM
  3. Replies: 2
    Last Post: 05-09-2012, 01:30 PM
  4. Excel - returning column headers in a seperate column
    By ExcelConfused in forum Excel General
    Replies: 1
    Last Post: 03-28-2006, 09:55 AM
  5. Excel column headers
    By Tara in forum Excel General
    Replies: 1
    Last Post: 01-02-2006, 08:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1