Results 1 to 4 of 4

Thread: Removing data from Microsoft Excel 2003 by setting criteria

  1. #1
    Join Date
    Feb 2012
    Posts
    98

    Removing data from Microsoft Excel 2003 by setting criteria

    I am a warehouse manager and I need to keep records of stock available and stock that has to be cleared. I use Microsoft Excel 2003 to maintain the records. I am creating a new sheet for clearance of goods in warehouse. My question is about creating columns where once a specific field is detected with value as 0, it will automatically delete itself. Can anybody tell me a way to do it?

  2. #2
    Join Date
    Aug 2011
    Posts
    566

    Re: Removing data from Microsoft Excel 2003 by setting criteria

    In the Tools menu, click on Options and then on View tab. Now you will get option to take action when 0 is detected. First option will be to mark the column which has zero and other one to clear the fields when 0 is detected. You can choose according o your comfort. Another method is to hide the column with zero in it manually. To do it, select the fields that you want to hide. Now in Format tab, click on Numbers tab. In the category, click on Custom and type in ‘0;-0;;@’.

  3. #3
    Join Date
    Jun 2011
    Posts
    635

    Re: Removing data from Microsoft Excel 2003 by setting criteria

    The method that you are asking is called conditional formatting. You can give certain condition for a specific action or event to take place. To do it, follow the following steps,
    1) Select the cell containing 0 and click on format.
    2) Get in to conditional formatting.
    3) On left side, you will find a box saying, ‘Cell value is’. Insert 0 here.
    4) In the box next to it, click on Equal to.
    5) Click on Format and give Color as ‘White’.

  4. #4
    Join Date
    May 2011
    Posts
    410

    Re: Removing data from Microsoft Excel 2003 by setting criteria

    If you are using PivotTables report then again you can do this in different manner. On PivotTable toolbar, click on PivotTable and there you will find Table Options. In table option, change error display. For error value, mark the checkbox under Format options. There type the value you want to replace the error. Then describe error as 0.

Similar Threads

  1. Replies: 4
    Last Post: 04-01-2014, 10:47 AM
  2. Extracting data from Microsoft Project 2010 to Microsoft Excel
    By Lennon Norris in forum Microsoft Project
    Replies: 6
    Last Post: 03-03-2012, 04:35 PM
  3. Replies: 6
    Last Post: 17-02-2012, 01:18 PM
  4. code for data entry in excel 2003
    By manikantan in forum Windows Software
    Replies: 2
    Last Post: 17-12-2009, 10:54 AM
  5. Microsoft Office Excel 2003
    By collioure_bee in forum Windows Software
    Replies: 2
    Last Post: 12-10-2009, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,628,180.65931 seconds with 17 queries