Kevy Baby
03-14-2006, 02:15 PM
I use a PC at work quite frequently and Excel fairly extensively. Two things I have not been able to figure out:
On Excel on my Mac, I can hit Command-= and it will insert the current date. At one point I knew the keystroke for inserting the current TIME. However, I cannot figure out what the keystroke is for these two items (most importantly, inserting the time) on the PC version. Nor could I figure out how to configure these under the "Customize" option in the Tools menu. BTW: it is Excel 2003. Anybody know these keyboard commands or how to assign them?
Secondly, does anybody now how to provide a count of a series of cells if the information to be counted is text? Basically I would need to just know how many cells in a range have SOMETHING in them. I know that if I use the COUNT function, it returns how many cells have numbers in them. I want to be able to count cells with ANYTHING in them.
Thank you in advance for any assistance!!!
On Excel on my Mac, I can hit Command-= and it will insert the current date. At one point I knew the keystroke for inserting the current TIME. However, I cannot figure out what the keystroke is for these two items (most importantly, inserting the time) on the PC version. Nor could I figure out how to configure these under the "Customize" option in the Tools menu. BTW: it is Excel 2003. Anybody know these keyboard commands or how to assign them?
Secondly, does anybody now how to provide a count of a series of cells if the information to be counted is text? Basically I would need to just know how many cells in a range have SOMETHING in them. I know that if I use the COUNT function, it returns how many cells have numbers in them. I want to be able to count cells with ANYTHING in them.
Thank you in advance for any assistance!!!