Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
While linking to other work sheets
Hello,
I am creating an EXCEL sheet where in each of 4 sheets in that corresponds to data in sheet1 of a 4 seperate work sheets. I am able to link the other sheets and getting the data from the other work sheets also..But where ever there is a blank cell is there , i am getting a zero. I don't want to appear un necessary zeros in my consolidated work sheet. I tried to use the option from TOOLs --options--view and removed the check against zero values.. This way we can't see the zero values but it occupies the space. so the memory of the sheet is getting increased as i am going to map for more number of cells.. So pls let me know the otherway of avoiding zeros while linking to all the cells of a different work sheet to another sheet of work sheet. Thanks and Regards, Raja Shekar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking one work book to another.... | Excel Worksheet Functions | |||
work sheet linking | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) |