• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Compile error on opening excel macro file of 97-2003 in Windows 11

    Hi, I do not know macros. There was a excel macro sheet sent for my use. On opening it, I receive compile error. On clicking ok, button, on opening the excel sheet, there are value, name NA errors all thro the workbook. It was a workbook with macros version 97-2003. Elsewhere in the discussion...
  2. J

    How to create a heriditary chart by using excel please

    Hi, If it all what you cannot change is the parents and relatives and their relations in this world. I really lack the details on the heriditary details of a family member and his sons daughters , son in law and daughter in law. As we pass on and grow old, we could not remember the heriditary...
  3. J

    Is there any excel trick that would easily solve Rubic cube

    Hi, Is there a simple way to solve the Rubic cube. I know it has edge pieces, and centre pieces and 3 rows and their move are restricted to spin and rotate. Is there a way, excel way, to how to solve the scrambled cube...
  4. J

    Is there any excel function or tip, to auto separate the entries in cell in ms excel 2007

    Hi, When i format a cell with time or date, i have to format the cell and also has to type manually the / / or -- format for date or : for time. Is there any tip, or function in excel where in it is possible to auto separate the entries according to chosen format. For eg. when i...
  5. J

    Is there a way to show updated rows of an excel sheet in the top rows, from original position

    Hi, i am having a excel sheet in which i and my staff will be updating. This is a regular worksheet, having names and some data. I will be updating the data to selected rows,this week, some other rows in next week and so on. It gets updated...
  6. J

    Where to mark questions as Solved so that search google users may benefit

    When a question is solved, if it is marked as solved then any search engine user, if searching may find it very useful as SOLVED one. Normally user search for excel and other questions, by including solved as a starting string in the question. for eg Solved How to change the...
  7. J

    how to change the colour of border lines in excel 2007

    The question is about bordering in excel. I could change the font colour , but could not change a colour line of the border in excel 2007. How to do that . I am having excel ribbon
  8. J

    how to use if function in an range in excel to get the result in excel

    Hi, i know how to use if function for general equations. But how to write formula to say, to find a particular number, and if those are present in all of them, i want to have the if function to get a result. if for example, if a1 to a6 contain 200, then i should get 150 in a7. in a...
  9. J

    how to change the colour of border of a table copied from ms excel to ms word

    I have copied one table having automatic border , black colour, to a word as a table and then i typed on it and saved that table as word file. I could just select the total words to change its colours of my choice. But while selecting all, everything font colour changed all over the doucment...
  10. J

    can i set an alarm (audio, or pop alert) in excel 2007

    if suppose some due date is available in a cell or cells in a worksheet/s, is it possible to have a kind of above alert, when the date and time passes, like gmail alert thro gmail notifier. I read in a thread that it could be done with linking to outlook. But outlook, by default, if used swallow...
  11. J

    how to view sheet hidden by view coding in excel

    http://chandoo.org/wp/2009/01/22/hide-excel-worksheet-tab/ is the article concerned. In this article, you have given the excel ideas to hide sheet from viewing using excel menu commands. I want to know, how to view the sheet again using the excel menu. I had made sheet2 to be hidden by your...
Back
Top