Tech Support question: Excel on Windows

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!!!

03-14-2006, 02:15 PM	#1
Kevy Baby Chowder Head Join Date: Jan 2005 Location: Yes Posts: 18,500	Tech Support question: Excel on Windows 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!!! __________________ The thing about quotes on the internet is that you cannot verify their validity. - Abraham Lincoln
	Submit to Quotes