20 Most Recent
Microsoft Excel for PC Questions & Answers
How many formulas we can use at a time in Excel
That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.
Forgot password
i have problem of to open file because of forgot file password to open
Sir,
use nitropdf. its best software to handle pdf convert. download
here
How to repair and recover corrupt MS excel file?
Excel file can be repaired manually if it is less corrupted but Open and Repair program doesn't work if highly damaged due to corruptions. I searched for solutions to repair corrupt Excel file and found one solution which is full of information and provides a guaranteed solution. I am sharing this solution with all the users -Excel Repair Toolbox. Follow the exact steps given in this programm and you will be able to access the data.
Download Microsoft Excel Repair tool
What is excel
Hi,
Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.
Regards,
Shrey
How to use vlookup in openoffice using different sheets
=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)
The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula
Minimize Data Entry
I will suggest you to create small application in .net for ths which will add some value and process your data;If you want to use Excel only make a master sheet with details and use it in other excel sheets
HOW TO HYPERLINK THE FORMULAS IN PRESENT SHEET1 OF
1. You can do it by-inserting a hyperlink and from the "insert hyperlink" window, select "place in this document" from the "Link to" pane. Then you can select desired destination sheet
2. First from unlock all cells from the format-protection menu.
then lock only those cells which you want to restrict access to the users.
then if you are using Office 2007, from the "review" tab select "protect sheet" then uncheck "Select locked cells" check box.
click ok then you are done.
Pls give solun of rupee
First download foradian currency font and install in windows
then configure currency format in Tally to Indian and select Indian Rupee symbol from the list.
How to protract a single row in excel 2007
1. First Select entire sheet -->Right click on any cell -->Cell formatting --> Protection -->Uncheck Lock
2. Now Select the desired row -->Right click -->cell formatting -->Protection -->Check Lock cell
3. Click review tab -->Select Protect Sheet --> Give Password twice
If function with array
Here is an example:-
We have to calculate result on the basis of marks.
1. Select answer range and click in formula bar
2. Type following formula
=if(d5:D9>=40,"Passed","Failed")
3. Now Press CTRL+SHIFT+Enter key
4. Observe the result in answer range and formula in formula bar, notice { } braces come automatically when we press CTRL+SHIFT+Enter key for an array.
For more clarification please mail on
[email protected] with screenshots.
What is the easiest way to link several formulas from seperate worksheets?
pen both the sheets in the same window as:-
1. View Tab-->New Window --> Arrange All --> tiled
2. Open first sheet in first window and second in second window
3. now create formula simply by clicking in corresponding sheets and selecting cells.
Alternatively you can use following format of addressing:-
1. SheetName!CellAddress (Same Workbook)
2. [WorkbookName]SheetName!CellAddress (Different Workbooks)
For more clarification please mail on
[email protected] with screenshots.
Not finding what you are looking for?