Excel Spreadsheets and File Folders?

Question

Is there a way to create a spreadsheet by copy and pasting files into an Excel file or any other program that retains all the info e.g. name, size, type.?

Sorry I wasnt very clear with that. I was to copy file information from a normal desktop folder in Windows into a categorized environment such as Excel to view what files exist and what is in them.

Answer 1

Not sure what you want to do exactly, but you can copy spreadsheets from one workbook to another.

R-click on the tab for the sheet you want to copy and choose the "Move or Copy" option. From there you are give the option to put it anywhere you like, even a new workbook.

OR, from within Windows Explorer, you can Copy and Paste the entire file. This works for more than Excel files. If you are dealing with FIILENAME you get a file named "Copy of FILENAME", and you can rename it as you see fit.

Or (this is what you want) from a Command Prompt, you can type DIR > LIST.TXT. the ">" is called a pipe and it redirects the output from the DIR command to the file LIST.TXT (or any other name of your choosing). You get to a command prompt by going to Start Menu, click Run, type CMD..... Then you import LIST.TXT into Excel.

Answer 2

Click and copy click the file you from the tab just below the window and look for your own excel tab and paste them there.