When I enter a value, it appears with two decimal places. For example, when I enter 154 it shows up as 1.54. Whats wrong?
601I 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?
605I am using ms excel and I want to import a spreadsheet into ms powerpoint without the gridlines. Is this possible?
650I 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?
638Why 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?
739I 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?
626Post New MS Excel Microsoft Questions
Why do excel files get corrupted?
What is the difference between spreadsheet worksheet and sheet?
How can I introduce myself during interview?
What is a spreadsheet and give examples?
How do you find the average on a spreadsheet?
Can I combine columns in excel?
How do I change the default font in excel 2013?
How many formulas in ms excel?
What is the symbol in excel?
How do I remove numbers and keep text in excel?
I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return thecolor of the interior for each cell in a range? I would like to do something like: =countif(b1:b10, cell("interior","red"))?
How do you format all text in excel?
What is the use of ms excel 2010?
How many rows and columns excel 2016?
How do I extract last name in excel?