Re: $$Excel-Macros$$ Short cut keys for unmerge cells in excel

2013-05-23 Thread Ali Abbas
thanks my dear, May Allah Bless On You. On May 23, 2013 10:57 AM, "Prabhu Pinky" wrote: > Hi, > > try the key combinations* Alt+H+M+U* to Unmerge and *Alt+H+M+M* to Merge > the cells. > > > Regards > Prabhu R > > On 23 May 2013 15:28, Ali Abbas wrote: > >> Dear All, any one know how can we un-me

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-23 Thread Chaya
Dear Experts, any Update on this ? Regards, Chaya The excel learner :-) On Wed, May 22, 2013 at 7:33 PM, Chaya wrote: > Thanks Abhishek sir. but it will be a long process. i have many more > files to insert as hyperlink. Can it be automated like -whatever the > file contain in the folder, i

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread David Grugeon
Is it just this file which is slow or are all excel files slow? Is this file slow if you run it on another computer? What is the file extension? Xls, xlsb, xlsm,xlsb. What version of windows? Including whether it is 32 or 64 bit? What version of office? Also 32 or 64 How much memory does the com

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread Prabhu Pinky
But my bad time..even I copied the data which contains formula and formats into new sheet. Same problem I face I copied the cell which contains only the data... Prabhu R On May 23, 2013 9:41 PM, "Bé Trần Văn" wrote: > Maybe because your spreadsheet data using multiple functions, or select >

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread Bé Trần Văn
Maybe because your spreadsheet data using multiple functions, or select and delete the blank column on the right, select and delete the blank line underneath the sheet containing the data, if not all slow sluggish, the ultimate solution is a new file, open 1, copy each sheet and select Paste Specia

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread Divaker Pandey
are using formula in sheet?, i hope there are refrences of some other files that may be closed. it may reason you file taking more time to calculate. On Thu, May 23, 2013 at 8:05 PM, Divaker Pandey wrote: > are using formula in sheet?, i hope there are refrences of some other > files. > > > O

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread Divaker Pandey
are using formula in sheet?, i hope there are refrences of some other files. On Thu, May 23, 2013 at 5:49 PM, P.VIJAYKUMAR wrote: > Respected Prabhu, > > You are saying that the sheet is companies sheet.Is is password protected > or are any user rights restricted to used and to modify or make a

Fwd: $$Excel-Macros$$ HELP REQUIRED - TOP 3 VALUES

2013-05-23 Thread Pravin Gunjal
*With Simple Formula.* -- Forwarded message -- From: Kuldeep Singh Date: Thu, May 23, 2013 at 2:35 PM Subject: Re: $$Excel-Macros$$ HELP REQUIRED - TOP 3 VALUES To: "excel-macros@googlegroups.com" Hi, PFA... Regards, Kuldeep Singh Assistant Manager Quality Game Zone India

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread P.VIJAYKUMAR
Respected Prabhu, You are saying that the sheet is companies sheet.Is is password protected or are any user rights restricted to used and to modify or make any changes to the file.Check also for version based compatibility issues because earlier version had lower data input and processing capabili

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread Prabhu Pinky
No david..that sheet contains no macros, even very less formula. Only the thing is some cells have formatted... Prabhu R On May 23, 2013 5:20 PM, "David Grugeon" wrote: > Also do you have macros which are run when changes are made to the sheets. > It may be possible to reorganise them so they r

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread David Grugeon
Also do you have macros which are run when changes are made to the sheets. It may be possible to reorganise them so they run faster or are not triggered so readily. Regards David Grugeon On 23 May 2013 21:47, David Grugeon wrote: > Try setting the calculation to Manual. Then see if Cut and

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread David Grugeon
Try setting the calculation to Manual. Then see if Cut and Paste still takes a lot of time. It could be that there are a lot of formulas having to be recalculated when there is a change to the worksheet. If this is identified as the cause you may be able to get a gain by redesigning hr worksheet

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread Prabhu Pinky
thanks vijay, lemme try this too. but my doubt is if already "Use all the processors on this computer" option is selected. then..? Regards, Prabhu R On 23 May 2013 16:48, P.VIJAYKUMAR wrote: > Respected Prabhu, > > Please go to excel options button and from there go to the advanced tab > an

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread P.VIJAYKUMAR
Respected Prabhu, Please go to excel options button and from there go to the advanced tab and under that go to the formulas section.The third point will contain how many processors are used for excel calculations.check the radio button to use all the processors for calculations.This may boost up

Re: $$Excel-Macros$$ Short cut keys for unmerge cells in excel

2013-05-23 Thread Prabhu Pinky
Hi, try the key combinations* Alt+H+M+U* to Unmerge and *Alt+H+M+M* to Merge the cells. Regards Prabhu R On 23 May 2013 15:28, Ali Abbas wrote: > Dear All, any one know how can we un-merge cells in excel with short keys > Or have a any short keys for unmerge to cells > > -- > Are you =EXP(E:R

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread Prabhu Pinky
Hi Abhishek : thanks for the idea. i will try this one. David : i am unable attach the file, because it is violation in our office. On 23 May 2013 13:39, David Grugeon wrote: > Can't guess without seeing the file. Can you attach it? > > Regards > David Grugeon > > > > On 23 May 2013 16:49,

$$Excel-Macros$$ New Approach to Learn MS Excel Shortcuts at Job

2013-05-23 Thread Richa Shah
1. Need to Speed up Excel Tasks at Job? 2. Hard time remembering Excel Shortcuts? 3. Spending extra hours learning it? Now, Learn Excel MS Shortcuts while you work at - http://www.excelgoodies.com/exceltools/excelshortcuttutor/ Happy Excelling :) - Team Excelgoodies -- Are y

$$Excel-Macros$$ List of Diffcult formules

2013-05-23 Thread Suyog Kulkarni
Hello All, Pl refer attached list. In this way, I'm planning to make one list of difficult & complicated formulas. I'm planning to study about "plugin-Form Controls" also. I don't know about VBA much so concentrating on remaining features of Excel. Before starting preparation kindly advice ab

$$Excel-Macros$$ Short cut keys for unmerge cells in excel

2013-05-23 Thread Ali Abbas
Dear All, any one know how can we un-merge cells in excel with short keys Or have a any short keys for unmerge to cells -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discuss

Re: $$Excel-Macros$$ HELP REQUIRED - TOP 3 VALUES

2013-05-23 Thread Kuldeep Singh
Hi, PFA... Regards, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-9716615535 || naukrikuld...@gmail.com || *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* * * On Thu, May 23, 2013 at 2:23 PM, Prashant Pawle wrote: >

Re: $$Excel-Macros$$ Import Data From large size text file to Excel using VBA

2013-05-23 Thread Bé Trần Văn
2 Form to use as input Sheet. Done by: Choose Valiedation in Cell D3 of sheet NhapLieu, it will retrieve the data from sheet DataList. Click on the button "Enter data into the sheet Theodoi", to enter data into the next row of sheet Theodoi. 2013/5/23 vincentmca > Hi, > > i need to import dat

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread David Grugeon
Can't guess without seeing the file. Can you attach it? Regards David Grugeon On 23 May 2013 16:49, Prabhu Pinky wrote: > Hi experts, > I have one excel file. Size is below 1mb. Even though it is very slow > working in that file. If I do copy paste any single cell, it takes too much > time.

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread Abhishek Jain
Not sure if this is your case but: Press F5 > Special > Objects and if Excel finds anything, press Delete. Might help. On Thu, May 23, 2013 at 12:19 PM, Prabhu Pinky wrote: > Hi experts, > I have one excel file. Size is below 1mb. Even though it is very slow > working in that file. If I do copy

Re: $$Excel-Macros$$ Dynamic Graph Help

2013-05-23 Thread Shrinivas Shevde
Dear Abhishek you are right sir but I dont want to show the data it may be some where else and selection button will be on or near graph In short user will see only graph and option for selection. On Tue, May 21, 2013 at 4:22 PM, Abhishek Jain wrote: > Does this make any sense? > > > On Tue, May