$$Excel-Macros$$ Need help for filter

Hello Group members, If I have a data in a row wise, will use auto filter option. But If I have data in coloum wise if I need to filter (horizental), how do this. suppose if have column no. 1,2,3..100, if I want to see only 2,4,8 like this.. If I go on hiding the col. ll tak more time. Is the

$$Excel-Macros$$ What is array??

Hello all, Pls explain me what do mean by array in excel?? Thanks. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit

$$Excel-Macros$$ Pls help me..

Hi all,, I have attached the file, and explained the proble there only. I wanted to pick amount from another table by formula. I tried with vlookup i didnt get answer. Pls help me. Regards, Ram. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials a

$$Excel-Macros$$ How to lock the cells.

Hello all, Could you pls explain me how to lock cells in the below scenario: - How to lock single cell - How to lock range of cells - how to hide the formula only for formula based cells. Regards, Ram. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutori