Windows 10: lock first row of shred file excel

Discus and support lock first row of shred file excel in Windows 10 Gaming to solve the problem; Hi all, I need to lock not freeze the first row or some specific cell in shared excel... Discussion in 'Windows 10 Gaming' started by Artur Mystrovsky, Aug 3, 2022.

  1. ARTUR MYSTROVSKY
    Artur Mystrovsky Win User

    lock first row of shred file excel


    Hi all, I need to lock not freeze the first row or some specific cell in shared excel

    :)
     
    Artur Mystrovsky, Aug 3, 2022
    #1
  2. JACK-C
    Jack-C Win User

    cannot shred folder

    Windows 10 will let me delete a folder on boot drive C: but will not let me shred the folder with several of the file shredder programs. I can shred all individual files. Also If I copy the folder to my D drive, I can shred the folder, but not from the C
    (boot) drive. The C drive is solid state, the D drive is SATA, if that makes any difference.

    Does Windows lock folders on the boot drive? Can I unlock specific folders so that they may be shredded if I choose?

    Many thanks for suggestions.

    Jack
     
    Jack-C, Aug 3, 2022
    #2
  3. WORD MAN
    Word Man Win User
    Entering row in Excel - error

    How many rows of the spreadsheet are you using? If every row has something in it, then you can't have any more rows. My version of Excel has 1,048,576 rows in a spreadsheet and I've never filled one.

    If you go to the last row you think you are using and delete every row below that (if there are any), you should then be able to insert rows at the top.

    Which version of Excel are you in? I think Excel 2003 and earlier only had 65536 rows available.
     
    Word Man, Aug 3, 2022
    #3
  4. TCOLLAR
    tcollar Win User

    lock first row of shred file excel

    Combine multiple CSV files by column, not by row

    I have ~100 CSV files that I want to combine into one single Excel spreadsheet (everything in one tab, not in separate tabs). These CSV files are identical in format: each contains 4,000 rows and 2 columns with header, about 60 KB in size.

    All solutions I've found so far append the next CSV at the end of the last row of the active tab. I haven't seen one that can append new CSVs to the columns immediate to the right of last column.

    Here're some examples.

    1. DOS copy method: copy *.csv merge.txt
    2. This solution. (VBA script.)
    3. Using Excel's Data>New Query>From File>From Folder (Excel 2013) .

    There are also examples with Windows Powershell scripts to merge CSV files on the internet.

    All of the above create a single Excel spreadsheet with about 400,000 rows of data, which is useless to me.

    I'd appreciate suggestions to solve this problem. Thanks!

    Edit. An easy solution is found: using r's cbind() to combine the data in a data frame and then write it to a csv. The entire process took ~3 seconds. Right tool for the job!

    Thanks to everyone for contributing. Cheers,

    --tcollar
     
    tcollar, Aug 3, 2022
    #4
Thema:

lock first row of shred file excel

Loading...

  1. lock first row of shred file excel - Similar Threads - lock row shred

  2. Issues with a locked excel file that keeps staying locked.

    in Windows 10 Gaming
    Issues with a locked excel file that keeps staying locked.: I have an issue where there is an excel sheet that keeps getting locked. I've forced closed it through computer management and reboot the server and all workstations that access to that file. It's happening on multiple workstations and with different users. I've also saved a...

  3. Issues with a locked excel file that keeps staying locked.

    in Windows 10 Software and Apps
    Issues with a locked excel file that keeps staying locked.: I have an issue where there is an excel sheet that keeps getting locked. I've forced closed it through computer management and reboot the server and all workstations that access to that file. It's happening on multiple workstations and with different users. I've also saved a...

  4. lock first row of shred file excel

    in Windows 10 Software and Apps
    lock first row of shred file excel: Hi all, I need to lock not freeze the first row or some specific cell in shared excel https://answers.microsoft.com/en-us/windows/forum/all/lock-first-row-of-shred-file-excel/bd16ed1e-37be-4597-b948-03295aee8419

  5. Secure File Deletion / Shredding

    in AntiVirus, Firewalls and System Security
    Secure File Deletion / Shredding: Understand Windows 10 Users still have no access to a 'Built-in' i.e. Native 'File Shredder' for securely disposing of financial or other sensitive files that might otherwise be recovered by a an IT Savvy Rogue, if a Laptop is lost or stolen.I will not install a 3rd Party...

  6. Output Excel value from undefined row?

    in Windows 10 Software and Apps
    Output Excel value from undefined row?: Hello, I have the following problem: I want Excel to display a value from column "C" ,say 1; this is no problem. For this I use this: = IF(COUNT IF(C21:C70;1)=1;"Yes";"No"). How do I get it now that from a cell which is in column B next to the 1 is also displayed where the 1...

  7. Free space shredding

    in Windows 10 Performance & Maintenance
    Free space shredding: Hey everyone, So i was using the iobit file shredder software to shred the empty space of my d drive but had to cancel it prematurely. During this process it froze and I tried to cancel the process. Now my harddrive is super slow and I have over a million 0kb files created...

  8. How to recover Shredded Files?

    in Windows 10 Installation and Upgrade
    How to recover Shredded Files?: How do I recover shredded files on a partition kindly help https://answers.microsoft.com/en-us/windows/forum/all/how-to-recover-shredded-files/d676821c-f41d-4ccc-aba7-e4ad221108ed

  9. Excel spaces between rows

    in Microsoft Office and 365
    Excel spaces between rows: Hi,, I have a col that is the result of an if function. =IF(H105="a",B105,"") Which results in a col of names in col O if there is an "a" in col H. But if it is not an "a" it is a space, how can I do it so that all the spaces are removed and I end up with a col of names with...

  10. Entering row in Excel - error

    in Microsoft Office and 365
    Entering row in Excel - error: [img] Hello all, So I'm trying to put together a table in Excel which i managed to do, however I need insert 3 lines at the top of the table(above the head of the tabel), but Excel won't allow it. Is anybody familiar with this sort of error? I've been browsing online...