Windows 10: Help! Printing multiple Excel files in sorted orders

Help! I have to print 30-50 excel files on weekly basis and its currently printing in random orders. For example, I have files saved in the name of A1, A2, A3, A4, A5, A6. I have the files in descending order. When I highlight all files under the folder and right click to pint. It is printing random orders.It would be very helpful if I can print multiple files in sorted orders, so I don't have to manually sort them. I tried to change the printer setting by printer properties and changing settings under advanced = spooled print documents. Tried with selecting start printing after last page is s

:)

 

Excel printing

Hi Joseph,

Thank you for posting your query in Microsoft Community.

Does this issue only occur with Excel file or nay other files?

Try to copy the excel file to the other drive and check if it is working?

Run Print Troubleshooter

The built-in Printer Troubleshooter can automatically detect and fix most of the incorrect settings and errors that could cause issues while printing. I would suggest you to run this troubleshooter to check if there is any issue with the sound. Refer
top these steps:

• Click on Troubleshooting and select the
  view all option on the left pane.
  
• Click on Printer troubleshooter and follow the online instructions.

If this doesn’t help. Try to repair the Microsoft Office Application.

Do let us know if you have any other queries pertaining to Windows in the future. We will be happy to help.

Thank you.

 

Sort Order of Files in OneDrive

How do I change the sort order that my files appear in OneDrive when I perform an Open file in Office WORD or EXCEL? When I run File Explorer, I can change the sort order of my files in OneDrive to sort by date. But when I view the files when trying
to do an open in WORD, or EXCEL, the files defaults to sort alphabetically. I'm running Windows 10 and Office 2013.

 

Random order of Excel File Listing

Hello Kitty,

There are a lot of possible causes why there's a change to the field in an Excel spreadsheet that you are experiencing. This may be due to the update of Windows 10 or corrupted system file. In order for us to assist you better, we'd like to ask the following:

• What's the license of your Excel? Are you using Office 365 for business?
• Can you tell us the troubleshooting steps have you tried so far?
• What's the update that was installed on your computer?
  

We are looking forward to your reply.