20 Most Recent
Microsoft Excel for PC - Page 10 Questions & Answers
How to use the new
Hi,
Please follow the below link for your problem.
http://www.tallysolutions.com/website/CHM/TallyERP9/04_ADVANCED_FEATURES_IN_TALLY/01_Advanced_Accounting_Features_in_Tally/Multi-Currency/Creating_a_Currency.htm
thanking you
davevipul197
Not Enough Memory to run Microsoft Office Excel.
Excel running on a 32 bit PC and using a 32 bit operating system can only address 2 Gb of RAM. If your machine has a 64 bit processor (these were being shipped over 5 years ago) it will be possible to install a 64 bit operating system such as Windows XP 64 bit or Windows 7 64 bit. It has been claimed that an Excel 2010 spreadsheet, running on a 64 bit machine and using Windows 7 64 bit, was able to load and use a database with 100 million records.
If you are unable to do this then I suggest that you examine what your machine is running at the same time as your spreadsheet and if any part of the spreadsheet can be off-loaded. By the latter I mean can any of it transferred to another Excel file?
Are you using any links on your spreadsheet, if so can the links be converted into data, e.g. a link to a lookuptable could be converted to data (copy, paste-special, value) and this remove a significant amount of processing load.
Pls help to write an
This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.
Thanks
Tim
Excel lookup - match index array
The best solution may be to re-define the named columns, or to add new names to multi-column arrays, then use the VLOOKUP function.
Note that the "indexed" named cells must be sorted by the index column.
Test (this is a 2 year old question)... Please ignore ths following. The plus symbol does not display.
Upper key plus symbol displays:
Right plus symbol on number pad displays:
[Shift] Right plus symbol on number pad displays:
[Alt] [4] [3] displays:
slash/slash/plus displays: //
slash/plus/slash displays: / /
Plus Plus Plus displays:
upper Plus Plus Plus displays:
Shift Right plus plus plus displays:
end of plus test.. thanks.
What is the importance of right align button in
broken0196,
The right-align format is best for viewing numbers.
It is especially easier to read 'accounting' numbers where the decimals line up.
Generally, left-justifed is best for non-number alpha characters/words.
Center-justify is best (maybe) for column headings, etc.
I hope this helps you.
I WOULD LIKE TO CHANGE
amjbritto,
There are two ways to do this, depending on what extent you want to protect the spreadsheet.
Windows Read-Only method:
- Save and Close the Excel file.
- Using Windows Explorer, locate the Excel file in its folder.
- Right-click on the file name
- Click on "Properties" at the bottom of the drop-down window.
- Check the [x] Read-Only box and [OK]
- * DONE *
Excel "Protect" Method:
- Open the Excel spreadsheet that you want to protect
- On the top menu, select [Tools]
- Click [Protection] on the drop-down menu
- Select [Protect Workbook]
- Check [x]Structure and [x]Windows
- Enter a password if you wish, but remember it!
- Click [OK]
- Save and close the spreadsheet and test the protection.
- *DONE *
Thanks for using
FixYa.
How to download an excel to my PC?
Hi,
IF you want to use Excel on your PC, what you can do is install Microsoft Office 2010 trial version from
here: then click the download a trial version. or there are other programs that are free like the Open office program that you can get
here.
Hope this helps your issue, and thank you for using Fixya, you recommendation is highly appreciated for the free support.
Cant get the Indian rupee
there is a popular solution for those who have been locked out by excel spreadsheet. For this solution, what you need is a password recovery tool,Google Excel Password Recovery 5.0 for password recovery. Download and install the software.
With Excel Password Recovery 5.0, you can open you excel spreadsheet without data lost.
How do I get the calculate button to work on my
Normally excel should automaticallly update the values on the spreadsheet. However, in certain cases when it doesn't work, you can use the manual update key which is the "F9" key on the keyboard.
Hope this answer your question.
How to insert the rupee symbal in excel
Let me add with a brief details on how to download, how to install and how to type Indian Rupee Symbol:
Click here to download INR Rupee font, download this, extract the font file (once you open the zip file, you'll see a file name "Rupee"), copy it and paste it in the Fonts folder of the Control Panel of your computer.
Open a word processing program like Ms-word (in your case, Excel) and select the font as "Rupee" from the drop down lists, now press
on the keyboard.
You'll see the Rupee symbol :
Good luck.
Thanks for using
FixYa.
I am not getting any
At the top right ribon where you have Minimize, Maximize and Close bottons, just below it you will find a v like botton. Click on this v and your menu will appear again.
Find length of right triangle given one angle an
Formulas relating to right angled triangles are:
Sine = perpendicular divided by hypotenuse
Cosine = base divided by hypotenuse
Tangent = perpendicular divided by base
Sine Tangent and Cosine functions are all available in Excel
Not finding what you are looking for?