Microsoft Excel for PC - Answered Questions & Fixed issues


use nitropdf to convert it back. download here

Microsoft Excel... | Answered on Nov 25, 2019 | 112 views


Use Excel Repair Toolbox is efficient corrupt XLSX file repair software, suitable for all data recovery activities, applied to Microsoft Excel documents.

For more: https://www.xlsxrepairtoolbox.com/

Microsoft Excel... | Answered on Oct 19, 2019 | 411 views


Here is the best answer for you all guys
check this
Missed call numbers for All Indian bank balance check in India.

Microsoft Excel... | Answered on Aug 26, 2019 | 100 views


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

Microsoft Excel... | Answered on Mar 18, 2019 | 690 views


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.

Microsoft Excel... | Answered on Dec 15, 2018 | 405 views


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

Microsoft Excel... | Answered on May 08, 2018 | 251 views


=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

Microsoft Excel... | Answered on May 02, 2018 | 5,099 views


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

Microsoft Excel... | Answered on Apr 07, 2018 | 204 views


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.

Microsoft Excel... | Answered on Feb 16, 2018 | 145 views


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.

Microsoft Excel... | Answered on Sep 16, 2017 | 383 views


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

Microsoft Excel... | Answered on Sep 16, 2017 | 158 views


Please provide exact problem statement in terms of dataset.


For more clarification please mail on ali_zulfikar@yahoo.com with screenshots.

Microsoft Excel... | Answered on Sep 16, 2017 | 119 views


Select and copy formula after "=" sign then in target Cell type "=" then paste formula and press enter.

For more clarification please mail on ali_zulfikar@yahoo.com with screenshots.

Microsoft Excel... | Answered on Sep 16, 2017 | 122 views


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.
excel3-yi4l5i2224qkwob0czw2k0fe-5-0.png For more clarification please mail on ali_zulfikar@yahoo.com with screenshots.

Microsoft Excel... | Answered on Sep 16, 2017 | 119 views


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 ali_zulfikar@yahoo.com with screenshots.

Microsoft Excel... | Answered on Sep 16, 2017 | 149 views


Don't put anything in blank pages, not even a space, now select the pages those you want to print and print selection.
It must help you out

It will locate all error containing cells, now rectify the error save it reopen in excel to see if problem is solved.

Microsoft Excel... | Answered on Sep 16, 2017 | 137 views


it should be date and time created from that number or current system date and time ?
Please clarify ...

Microsoft Excel... | Answered on Sep 16, 2017 | 143 views


first start excel and click on formula tab -->Calculation options -->Manual
excel1-yi4l5i2224qkwob0czw2k0fe-5-0.pngNow open file, if asks for update formulae, say no.
Now select entire sheet, select formulas tab--> Error Checking -->Trace Error.
excel2-yi4l5i2224qkwob0czw2k0fe-5-2.png It will locate all error containing cells, now rectify the error save it reopen in excel to see if problem is solved.

Microsoft Excel... | Answered on Sep 16, 2017 | 162 views


If the extension of the corrupted file is not xls or xlsx), have you tried renaming it with the xls or xlsx extension and opening with excel? Have you tried opening with Google Docs Spreadsheet?

Microsoft Excel... | Answered on Mar 02, 2017 | 203 views


it sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.

Microsoft Excel... | Answered on Dec 02, 2016 | 290 views

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

670 questions posted

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...