Windows 10: You used the Autofill Handle to fill the series in a column, but Excel just copied the...

Discus and support You used the Autofill Handle to fill the series in a column, but Excel just copied the... in Windows 10 Network and Sharing to solve the problem; You used the Autofill Handle to fill the series in a column, but Excel just copied the number all the way down. What probably went wrong?... Discussion in 'Windows 10 Network and Sharing' started by Rhea Mae Eder, Oct 12, 2020.

  1. RHEA MAE EDER
    Rhea Mae Eder Win User

    You used the Autofill Handle to fill the series in a column, but Excel just copied the...


    You used the Autofill Handle to fill the series in a column, but Excel just copied the number all the way down. What probably went wrong?

    :)
     
    Rhea Mae Eder, Oct 12, 2020
    #1
  2. BENKENOBI007
    BenKenobi007 Win User

    Convert one column into a new column every 10 rows in Excel

    I have a set of 110 numbers in Excel. I want to split this into 11 columns of 10 rows each.

    So, for column:

    I want the output to be:

    What I've tried so far

    1. Assigned =A11 in B1, =A21 in C1, =A31 in D1 and then used the autofill. However, this gives the formula =D11 in E1 and hence doesn't work.
    2. Using Text to Columns wizard. This only provides for splitting of data for delimiter and there is now way of splitting based on number of rows.

    The most similar question I've found is here where the goal is the opposite of mine (combining multiple columns into a single one).

    This and this solve a similar problem but they copy the data row wise.

    This question attempts the same problem in R.

    I know this can be solved using a library like pandas, but I think there should be an easy way of doing it in Excel too.
     
    BenKenobi007, Oct 12, 2020
    #2
  3. BUZZZQWERT
    buzzzqwert Win User
    Excel column width

    Is there an easy way to change the column width on Excel using WP7? I copy files over from my PC where the data fits inside the column width but when I open on WP7 I see "xxxxxxxxx" in the column meaning the data won't fit. I've tried moving columns with
    my fingernail after enlarging the spreadsheet but can't get it to do anything. Is the only approach to make the columns wider on the PC version first?
     
    buzzzqwert, Oct 12, 2020
    #3
  4. JERRY8A
    Jerry8A Win User

    You used the Autofill Handle to fill the series in a column, but Excel just copied the...

    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, Oct 12, 2020
    #4
Thema:

You used the Autofill Handle to fill the series in a column, but Excel just copied the...

Loading...

  1. You used the Autofill Handle to fill the series in a column, but Excel just copied the... - Similar Threads - used Autofill Handle

  2. SharePoint List - fill column headers?

    in Windows 10 Gaming
    SharePoint List - fill column headers?: Hi. I have a SharePoint list with multiple columns, and different people are responsible for different columns. To make it easy, I want to fill the 3 column headers orange, two column headers yellow, 4 column headers blue and 5 column headers green. I have used PowerApps to...

  3. SharePoint List - fill column headers?

    in Windows 10 Software and Apps
    SharePoint List - fill column headers?: Hi. I have a SharePoint list with multiple columns, and different people are responsible for different columns. To make it easy, I want to fill the 3 column headers orange, two column headers yellow, 4 column headers blue and 5 column headers green. I have used PowerApps to...

  4. Excel: how to sort columns

    in Microsoft Office and 365
    Excel: how to sort columns: [img] Hi I I understand why those columns are sorted the way they are, but I cant sort them the way I want. ie - I would like CS_S all the way left, CS_E is in column 3, etc. I have tried a bunch of diff options under data>sort, but regardless of what I try, I cant get...

  5. I WANT TO COPY A FORMULA IN A COLUMN TO THE "ANSWER" IN A SECOND COLUMN.

    in Windows 10 Customization
    I WANT TO COPY A FORMULA IN A COLUMN TO THE "ANSWER" IN A SECOND COLUMN.: I WANT TO COPY A FORMULA IN A COLUMN TO THE "ANSWER"IN A SECOND COLUMN. https://answers.microsoft.com/en-us/windows/forum/all/i-want-to-copy-a-formula-in-a-column-to-the-answer/2fd20eec-3b3f-42e5-8ee9-372fe71ccdba

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

    in Windows 10 Support
    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...

  7. Excel 2103 adding digits to column

    in Microsoft Office and 365
    Excel 2103 adding digits to column: Hi guys can I ask for a little advice please I have an excel 2013 spreadsheet formatted as a table I have attached a screenshot to explain better As you can see I have a rows of dates in the header row IE 12th 13th 14th and so on to the left of the yellow column but when I...

  8. Can you just get Excel?

    in Microsoft Office and 365
    Can you just get Excel?: Can you just get Excel for Windows 10 without all the other stuff that comes with Office? 128121

  9. Excel Using control to copy data

    in Microsoft Office and 365
    Excel Using control to copy data: Hi ,,I want to copy =e7,=e9,=e11,, you know what I mean, select a cell, press Ctrl and select down a part of a column, but each cell says =e7,=e8,=e9,=e10,,,what I want is =e7,=e9,=e11,=e13,,can someone tell me how please instead of me having to type in each cell. 120274

  10. Read from Excel specific columns

    in Microsoft Office and 365
    Read from Excel specific columns: Hallo, seit kurzer Zeit bewege auch ich mich durch das "Matlab-Universum". Demgemäß freue ich mich über jeden kleinen Schritt, der mir gelingt. Nun habe ich jedoch eine Aufgabe erhalten, welche - so denke ich - mein bisheriges Können bei weitem übersteigt. Folgender...