Question about Microsoft Excel for PC

1 Answer

Hi friends i have more branches file and i want to do make one file of my all branches report in execl i working in tally all expenses inculed how to do

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.


    An expert that has over 500 points.

  • Expert
  • 272 Answers
Re: hi friends

Have all worksheets open including the one that is to be the tally sheet.
On the tally sheet, select a cell that you want to link to one of the other sheets and press the equals signto begin the cell formula. Without pressing the enter key, click on the cell in the other worksheet that you want to show up in your tally sheet.
Press enter to complete. This will link that cell in the two worksheets together as long as the spreadsheets remain stored in the same places.

Posted on Dec 27, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer



Please follow below step

Step 1. Open Tally

Step 2. Open Report Which is you want Transfer in Excel.

Step 3. Press CTRL With E (Ctrl+e) from keyboad

Step 4. Select Sharped Sheet or Excel

Step 5. After type location for file save like this D:/your folder name/

Step 6. After You type file name with xls. like this sales.xls

thanking you


Dec 19, 2010 | Business & Productivity Software

3 Answers

Error in tally 7.2

What Operating System are using?

A safe solution would be to go to your Control Panel, from the Start Menu. From there, go to "Add/Remove Programs", and find your software application. See if there is a "repair" option next to it, and if so, run that.

Unless you have the original discs and product key for this software, please don't uninstall it - it will be difficult to get it back.

If this does not help, or you don't see a "repair" option, please post back with more information.

Apr 10, 2008 | Business & Productivity Software

1 Answer

How to connect tally with excel file? sir/madam i want to connect my tally erp 9 with my stock (excel file) i maintain the inventory in tally, when i make a bill on tally on that time it automatically...



in tally 9 ERP has a oprtion to export any date from tally to excel just open that page which u want to open in excel

then see on the top in tally page there is option for export file just folwothat u will able to export dot in to excel

Jun 26, 2010 | Peachtree Software Peachtree Complete...

2 Answers

How to automatically import data from tally to excel. Want to display auto imported data in sharepoint.

Import TALLY Data / Export TALLY Data
Tally allows users to Import data from other software's as well as Export data from Tally to other software's. Tally allows users to Import and Export in ASCII, SDF and XML formats. XML is now the most widely used format of exporting data in the world. Any transactions can be exported from Tally and imported in other software after suitably altering the current structures to accept Tally data structure. The reverse is also possible by writing a small TDL program to accept the data from other software's. The data that is to be imported into Tally can be in either XML or DBF format. Easy Tally data transfer or Tally data migration from Tally 4.5 & Tally 5.4 to Tally 6.3 , Tally 7.2 , etc.
Tally is now ODBC compliant. Hence, any program like MS-Excel, Oracle etc that is ODBC compliant can use data from Tally. Here, data connectivity is dynamic i.e. any new updation in Tally is reflected in other ODBC Compliant Software immediately. Now, with ODBC facility the user can extract data out of Tally and design his own report formats in other ODBC compliant software's.
Procedure :
Now, Load Company -> specify period -> minimize Tally -> Open a new Excel file -> select data -> select 'Get External Data' -> select New database query -> choose Data Source
Tally connects to data source and displays Tally Wizard query screen -> select the columns you would want to include in the query.
Once all the columns are selected, the user returns to excel and excel displays all the columns selected
Graphical Analysis of Tally Data
Sometimes, pictures can say better than figures. Tally also provides graphical (Bar graph) analysis of data. The user can do a graphical analysis reports like Sales register, Purchase register, Ledgers, Funds flow, Cash flow, Item registers etc. This helps the user in deeper analysis of data. In Tally, a graphical analysis can also show month wise graphs for the year in comparison with any other period. This will help the management in quickly locating the highs and lean periods in a financial year and hence be better prepared for difficult times.
Web Enabled
Tally ees 6.3 is now Web enabled. This will help the user in reducing his paper work further. Now, report in Tally can be e-mailed directly from Tally. It is not just reports, but even invoices and purchase orders can also be e-mailed directly from Tally. Hence, the user does not have to send printed invoice or purchase orders from Tally.
Procedure :
Select any report (e.g. Balance sheet) -> select Alt+M (E-mail) -> specify all details as required by Tally
Ability to Publish Reports and Documents on the Internet
Now, Tally allows users to upload reports on the web site directly from Tally. So companies that would want to publish reports on the web site can do so directly from Tally. Many companies would also like to publish their price list on their websites along with the product they deal with.
Procedure :
Select any report (Profit and Loss A/C) -> select Upload (Alt + O) -> specify all details as required by Tally.
Direct Internet Access
Tally now offers direct Internet access. A Tally user while working on Tally can directly log on to tally website get details of all the facilities offered by Tally. The user can also download the latest releases of Tally 6.3 as and when available. Tally website also offers a facility of Tally Chat. Any user can now chat with a Tally representative and get any information regarding Tally.
Procedure :
Start Tally -> now, from any screen select Web Browser (Alt+W). Tally now takes you to the Tally Web site.
Print Preview
Any user would ideally like to view format of reports / Invoices / Vouchers before printing the same. Tally now offers a facility of print preview. Now any report can be viewed before printing or before it is mailed. Once Tally shows the preview the user can either opt to print or mail the same.

Apr 15, 2010 | Microsoft Office Excel 2007

1 Answer

While using Execl , we are getting compatibility

.xls files opened in Excel 2007 is "always" in "Compatibility Mode" since default 2007 excel files have .xlsx extensions

Sep 16, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Quarterly reports are all tallied together

The balance sheet will always accumulate since that is a snapshot of the books at the time. The profit and loss reports would give a summary for the quarter.

Feb 13, 2009 | Intuit QuickBooks Pro 2008: Windows

5 Answers

Have a problem in tally 7.2

Dear Archana,

If you are using tally legal. Please check whether the date & time are correct. If correct then check the data folder file permission (readonly, hidden, system attributes) are removed. If not while starting tally press Ctrl + Alt + R for and select company which one is getting error. It will rewrites the data of that particular company. Then close tally and open again check it. If this doesn't work u should contact tally support with u r licence key and product id.

Thanks & Regards
Nanda Kishore

Nov 13, 2008 | Business & Productivity Software

4 Answers

How to Export trial Balance from Tally 9.2 version to Excel sheet

you select the trial balace--and press Alt+E or click export---then the export details screen came,

Language: Default(all language)
Format: Excel (spreadsheet)
Output file name: trial bal.xls (any name you select)

Excel (spreadsheet) formating: yes
other details you select and accept the screen. then minimise or close the Tally, you open the tally file name at my computer. at the time you can see the file trialbal.

Mar 20, 2008 | Business & Productivity Software

11 Answers

Error in tally 7.2

This is vishu

Solutions to these problems needs common sense rather than tallyexpertise. Lets understand some feature and working of tally. Tallyprovides a backup and restore utility which collects all files of tallycompany into one file named tbk500.001. This way of tally backup iseasier to restore as this one file can be kept save and easily can berestored instead of all files in that folder. If any of the file getsmissing or gets corrupted tally data wouldn't work.
when data gets corrupted while working on tally and we are unable toopen the company then data can simply rewritten. Come to Companyselection menu. Press "Ctrl + Alt + R". Now select the company for re writing. 90% chance is that you problem would be get solved.

Mail me Your response.

Dec 21, 2007 | Business & Productivity Software

Not finding what you are looking for?
Microsoft Excel for PC Logo

154 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides