I wish to count the number of cells in a col or row that have a value > 0. How is this done? The zero is displayed in the cells. Count() will only ignore a blank cell?
Is there a way to allow the use of autofilter on a protected worksheet?
How can I prevent hyperlinks from appearing when I type an email address?
Is there a function that returns the name of the worksheet?
I am using ms excel and I want to import a spreadsheet into ms powerpoint without the gridlines. Is this possible?
What are excel spreadsheet number formats?
I am using excel, and want to create a line graph with the data on my spreadsheet, ranging from january to december. However, I don not want the empty cells to berepresented as zeroes in the line graph. Is there a way to graph all months without displaying the zero values?
Why do the column headers show numbers instead of letters? How do I change my column headings so they are back to letters instead of numbers?
How can I speed up my macro execution?
I know I can use the fill handle (the small black box in the lower-right corner of the range) to copy data and formulas in excel, but is there a way to use it to clearranges in excel?
How do you use the sum and autosum functions in excel?
How can I save a chart as a gif file?
Upload data from excel into sap?
I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a zero in each. Therefore the div?
How to access my copy file?