Windows 10: Copy Column Headings in Excel from Sheet 1 to Sheet 2 - How?

Discus and support Copy Column Headings in Excel from Sheet 1 to Sheet 2 - How? in Windows 10 Support to solve the problem; I have Microsoft Office 2016 Excel on Windows 10. I want to copy “Column Headings only in Excel” from Sheet 1 to Sheet 2. I do not want to copy data... Discussion in 'Windows 10 Support' started by Jerry8A, Nov 23, 2019.

  1. Jerry8A Win User

    Copy Column Headings in Excel from Sheet 1 to Sheet 2 - How?


    I have Microsoft Office 2016 Excel on Windows 10.

    I want to copy “Column Headings only in Excel” from Sheet 1 to Sheet 2. I do not want to copy data from Sheet 1.
    I tried some Google searches and had trouble following and understanding some of the steps.

    In one of the search links I tried, a note said in effect, the column spacing in Sheet 1 did not match Sheet 2 spacing and would not allow me to proceed. So, maybe this can’t be done. I’m sure there were probably other issues, as well.

    If what I want to do is possible, please don’t hesitate to make it “simple” in your response.

    Thanks,
    Jerry

    :)
     
    Jerry8A, Nov 23, 2019
    #1
  2. Hannu Win User

    Excel - date range column heading

    Either of these

    • COLUMNS($A$1:A1)-1
    • ROWS($A$1:A1)-1

    ... will give you an increasing number for either COLUMNS or ROWS. The dual reference to A1 could be anywhere (e.g. on the current sheet) as long as it doesn't step out of the sheet when you copy the formula.

    I believe the rest of the formula is pretty "standard".
     
    Hannu, Nov 23, 2019
    #2
  3. EXCEL SHEET IN MAP XML FILE DELETE IN EXCEL SHEET

    EXCEL SHEET IN MAP XML FILE SO EXCEL SHEET WORKING NO PROPERLY SO I HAVE DELETE XML MAP IN EXCEL SHEET
     
    AbrishKhan, Nov 23, 2019
    #3
  4. Rajesh S Win User

    Copy Column Headings in Excel from Sheet 1 to Sheet 2 - How?

    Better overview of different sheets in Microsoft Excel

    I would like to suggest you a simple method to create Hyperlink of Sheet Name for easy navigation.


    Copy Column Headings in Excel from Sheet 1 to Sheet 2 - How? Tzy3c.png


    How it works:

    • Press Ctrl+K to open the Insert Hyperlink dialog box.
    • Click the Place in This Document button.
    • Then link to the sheet, select Sheet name from Cell Reference & press OK.
    • In Type the Cell reference write the Cell address which you want to
      attach with Sheet's Hyperlink.

    Note,

    • Repeat Step 1 to 3 for other Sheets.
    • Using this method you can create Sheet's Name list in desire order.
     
    Rajesh S, Nov 23, 2019
    #4
Thema:

Copy Column Headings in Excel from Sheet 1 to Sheet 2 - How?

Loading...
  1. Copy Column Headings in Excel from Sheet 1 to Sheet 2 - How? - Similar Threads - Copy Column Headings

  2. Excel sheet is automatically open

    in Windows 10 Customization
    Excel sheet is automatically open: Why Excel sheet is automatically pop-up many sheets when I turn on my PC https://answers.microsoft.com/en-us/windows/forum/all/excel-sheet-is-automatically-open/998d27e4-30b4-46a4-a225-0c8361ec18c6
  3. can we copy the task usage and resource usage sheet to excel directly ?

    in Windows 10 BSOD Crashes and Debugging
    can we copy the task usage and resource usage sheet to excel directly ?: can we copy the task usage and resource usage sheet to excel directly https://answers.microsoft.com/en-us/windows/forum/all/can-we-copy-the-task-usage-and-resource-usage/29f38fbe-6137-4786-b08d-085719555c3d
  4. Excel shortcut to open to specific sheet

    in Microsoft Office and 365
    Excel shortcut to open to specific sheet: I have a shortcut to open Excel to a file: "C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE" c:\all\Workbooks\General.xlsm". Is there a way to specify the sheet? I tried adding the sheet name to the end of the shortcut but I get an error comment. 135993
  5. Office 2010 Excel: two sheets

    in Microsoft Office and 365
    Office 2010 Excel: two sheets: I have Office 2010 and I know there is some trick to do this, but I cannot find it anywhere. I have two monitors and at work I have the same setup. Person who use to work there I heard said it was a hack that they added to my system so I don't know what that is. Here is what...
  6. window 10 repair noe errow message excell sheets

    in Windows 10 Customization
    window 10 repair noe errow message excell sheets: using excell spread sheets I keep getting message repair now https://answers.microsoft.com/en-us/windows/forum/all/window-10-repair-noe-errow-message-excell-sheets/cd200b8f-51ca-4676-b148-b3beb19946d7
  7. Updated computer with Excel sheet opened and now the excel sheet is deleted.

    in Windows 10 Installation and Upgrade
    Updated computer with Excel sheet opened and now the excel sheet is deleted.: I updated my computer on Friday and I believe I left an excel sheet I was working on open when I set it to "update and shut down". Now, on Monday, I tried to open the document. it opened, I saved it, and then the whole document went white and the mouse showed it was loading....
  8. Restore Excel file sheet

    in Windows 10 Network and Sharing
    Restore Excel file sheet: Working in an Excel file I mistakenly deleted a "sheet" is it possible to restore it? I've looked in the Recycle Bin, I've tried "restore previous version." https://answers.microsoft.com/en-us/windows/forum/all/restore-excel-file-sheet/7f8a11d4-0a49-45df-8396-c0d21791c1bc"
  9. Contact sheets - print

    in Windows 10 Network and Sharing
    Contact sheets - print: I noticed numerous people asking about printing contact sheets of photos - photos are sideways, etc. Yes, they are sideways or they are not in the correct alphabetical order - someone decided to start with the first one at the bottom of the page and work upwards....
  10. Invoices and spread sheet

    in Windows 10 Installation and Upgrade
    Invoices and spread sheet: With your program there are template of invoices and spread sheets. I would like to use them. How do I create multiple invoices for my customers? Then get the total to go on the spread sheets that are in this program?...