vishnu

Wednesday, May 6, 2015

How to convert multiple xlsx formats to xls formats or vice versa in Excel?

Supposing your co-worker have an older version of MS Excel as xls format, but your Excel format is xlsx (Excel 2007, 2010 or 2013), after sending the Excel files to him, his old version of Excel would not open these new formats unless he downloads a compatibility pack from Microsoft Office net. So before sending the files to him, you’d better convert the Excel files from xlsx format to xls format. How could you convert multiple xlsx formats to xls formats or vice versa at once in Excel?

Convert multiple xlsx formats to xls formats with Save As function one by one

Convert multiple xlsx formats to xls formats with Kutools for Excel at once

Convert multiple xlsx formats to xls formats with Save As function one by one

Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

Hint

How to be more efficient and save time when using Excel?

The Save As function in Excel can help you convert the workbook’s xlsx format to older xls format one by one.

1. Open your workbook that you want to convert its format.

2. Click File > Save As in Excel 2010 / 2013, and a Save As dialog will display, specify a folder to place the new format of the file, and then click Save as typedrop down list to choose Excel 97-2003 Workbook, see screenshot:

3. Then click Save button to close the dialog, and this Excel format has been converted from xlsx to xls.

Tip: If you are using Excel 2007, please click Office Button > Save As > Excel 97-2003 Workbook, see screenshot:

With this Save As function, you just only convert one Excel file at a time, if you have hundreds of Excel files need to be converted, this method is not a good choice.

Convert multiple xlsx formats to xls formats with Kutools for Excel at once

With this Kutools for Excel’s File Format Converter utility, you can convert multiple xlsx formats to xls formats or vise versa, it also can help you convert multiple workbooks to PDF files at one.

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

When you have installed Kutools for Excel, you can do as following steps:

1. Click Enterprise > Workbook Tools > File Format Converter, see screenshot:

2. And in the File Format Converter dialog, click the Type drop down list to choose the converter type you need, in this example, I select Excel 2007 or higher to Excel 97-2003. Then click

button to add the files or folders that you want to convert. See screenshot:

3. After adding the Excel files into the list box, click

button to specify the directory that you like to put these new format files. You can also save the new files into the source file directory. If you don’t want to keep the source files after conversion, please check Delete source files after conversion.

4. Then click OK to start converting, after finishing the conversion, a new workbook will be displayed to show the details of the conversion. See screenshot:

5. And all the Excel files format in the specified folder have been converted.

Notes:

1. With this utility, you can also convert multiple xls formats to xlsx formats by choosing the Excel 97-2003 to Excel 2007 or higher from the Type drop down list.

2. All of the files in your specified folder which includes the subfolders will be converted to the file format as you want as well.

To know more about this feature, please click File Format Converter.

Kutools for Excel

Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

More than 120 powerful advanced functions which designed for Excel:

Merge Cell/Rows/Columns without Losing Data.
Combine and Consolidate Multiple Sheets and Workbooks.
Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Friday, March 25, 2011

How to pay tds online

On time tax payment is important for every tax paying concern to avoid interest and penalties from income tax department. Online tds payment is compulsory for certain categories like

1. corporate assesses.

2. And for persons to whom section 44AB applicable.( compulsory tax audit isapplicable)

Tax should be paid to government within seven days from the last day of the month of deduction.TDS online payment made through tax information network of NSDL (National Securities Depository Ltd).NSDL is the first and largest depository in india,established in August 1996.NSDL is responsible for collecting tax on behalf of income tax department,by using tax information network , tax payer can fill up and submit challan through internet .

Internet banking facility in any one the stipulated bank is required for making online TDSpayment. Here is a tutorial on how to make e payment of tds online for those who are not aware of the systems.

Go to epayment section of Tax information network Select challan NO ./ITNS 281 under section TDS/TCS Now fill up the challan with correct TAN number and other details

After filling the challan click on proceed button , in the next screen you will be asked for verifying the the data .

Check and confirm the accuracy of the data entered in the challan then click on submit tobank button, you will be redirected internet banking site of your bankmentioned in thechallan.

Enter user name password and login to your bank account. And you will have a partially completed form with your TAN number and other details, now you should enter the tax details to be paid as shown in the below image.

Now click on payment button. You have successfully completed online TDS payment, now you will get cyber receipt of the payment made. Take a printout and as keep it safe.

No related posts.

Income tax rate for the financial year 2011-12

You all must have known about the new income tax rate after union budget 2011. We are posting income tax rate for the financial year 2011-12 and for the assessment year 2012-2013 for your reference.This time a new tax catogary has been added for the benefit of individual whos is 80 or above.

Income tax rate for individual ,Hindu undivided family or association of persons or body of individuals ,

	Income tax slab	Rate of income tax
1	Income up to Rs 180000	Nil
2	Rs 180000 to 500000	10 % of the amount after Rs 180000
3	Rs 500000 to Rs 800000	Rs 32000+20 % on the amount after Rs 500000
4	800000 and above	Rs 92000+30 % on the amont after Rs 800000

Every individual being a women resident in india and below the age of sixy years at any time during the previous year

	Income tax slab	Rate of income tax
1	Income up to Rs 190000	Nil
2	Rs 190000 to 500000	10 % of the amount after Rs 190000
3	Rs 500000 to Rs 800000	Rs 31000+20 % on the amount after Rs 500000
4	800000 and above	Rs 91000+30 % on the amont after Rs 800000

Every individual being resident in india , who is of the age of sixty years or more but less than eighty years

	Income tax slab	Rate of income tax
1	Income up to Rs 250000	Nil
2	Rs 250000 to 500000	10 % of the amount after Rs 250000
3	Rs 500000 to Rs 800000	Rs 25000+20 % on the amount after Rs 500000
4	800000 and above	Rs 85000+30 % on the amont after Rs 800000

Individual , being a resident in india , who is of the age of eighty years or more at any time during previous year

more but less than eighty years

	Income tax slab	Rate of income tax
1	Income up to Rs 500000	Nil
3	Rs 500000 to Rs 800000	20 % on the amount after Rs 500000
4	800000 and above	Rs 60000+30 % on the amont after Rs 800000

Income tax of Co-operative society for the financial year 2011-12

	Income tax slab	Rate of income tax
1	Income up Rs 10000	10% of total income
3	Above Rs 10000 to up to Rs 20000	Rs 1000+ 20 % of income above 10000
4	20000 and above	Rs 3000+ 30 % of income above 20000

Income tax rate of partnership firm for the financial year 2011-12

	Income tax slab	Rate of income tax
1	On total income	30% on total income

Income tax rate of Local authority for the financial year 2011-12

	Income tax slab	Rate of income tax
1	On total income	30% on total income

Income tax rate for companies for the financial year 2011-12

	Income tax slab	Rate of income tax
1	In case of domestic company	30% on total income
2	Case of a company other than a domestic company- i. on so much of the total income as consist of- (a)royalties received from government or an indian concern in pursuance of an agreement made by it with the government or the indian concern after 31^st day of march . 1961 but before the 1 st day of april 1976 or (b)fees for rendering technical servicesreceived from government or an indian concern in pursuance of an agreement made by it with the governenment or the indian concern after the 29^th day of february 1964 but before the 1^st day of april 1976 And where such agreement has , in either case, been approved by central government ii. on the balance , if any , of the total income	50 % 40%