Need some help in MS Excel

Asked By 0 points N/A Posted on -
qa-featured

Hi buddies,

I am working with MS Excel 2013 and having a couple of issues

I have many sheets in the excel document and would like to sort all those alphabetically. How can I possibly do that?

I am having date/time columns in all spreadsheets. I have to split the date/time into two separate columns. One column to date and another column with time.

Can somebody please help me resolve this? Thanks in advance for your help.

SHARE
Answered By 0 points N/A #193193

Need some help in MS Excel

qa-featured
Hello Lawrence!
 
Your issues can be addressed by these two methods: 1) Macro program, 2) Kutools for Excel. However, macro is a kind of programming so I will recommend the use of Kutools. Kutools for Excel's Sort Sheets tool can help achieve your desire in sorting. But it is only free in 30 days. Download it here
 
Using Kutools, do the following:
 
1. Go to Enterprise > Worksheet Tools > Sort Sheets (see picture below).
 
 
2. Select the kind of sorting you want in the Sort Sheets prompt.
 

 
3. After resolving the order of sorting, press OK button. This will sort all worksheets.
 
 

Login/Register to Answer

Related Questions