Need some help in MS Excel

Asked By Lawrence J Harrell 0 points N/A Posted on - 07/11/2014

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.

• Status: Open
• Question Views: 818
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Sorg Whitaker 0 points N/A #193193

Need some help in MS Excel

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.

 

 

About Sorg Whitaker

Questions
0

Answers
48

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/11/2014
• Question Category: MS Excel