You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Office.com writer Joy Miller shares her latest video on adding dates, times, file names, and page numbers to your headers and footers.
So it turns out that Excel 2010 users have something in common with Word users after all.
While researching the top search terms and phrases on the Office.com web site, I discovered that just like Word users, many people who use Excel 2010 want to add page numbers, the date and time, a file name, and other text to the header or footer of all worksheets in a workbook.
So here's a video I created to help you accomplish this task.
And here are some other related how-to articles that you might find helpful:
Hope you find this video and links helpful!
--Joy Miller
Comments: (2) Collapse
But don't add a graphic to your header/footer as a bug in XL2010 will lower the resolution of your output, messing with gridlines and font quality.
I want to know how to STOP Excel from auto-incrementing FUNCTION NAMES -- Cell Auto-Incrementing (drag and drop) is usual-- but NOT function names as in Excel 2010. Example:
=PRT1(b1,c1) (this is what a user wants-- user function name is PRT1)
=PRT1(b2,c2)
..
=PRT1(b999,c999)
Previously, Excel 2003/2007 did NOT auto-increment function names. Dragging the =function1(b1,c1) would NOT change the function name to function999(b999,c999)
The USABILITY of EXCEL 2010 is POOR for academic/scientific users.
This is what you get in Excel2010:
=PRT1(b1,c1) (this is NOT what a user wants)
=PRT2(b2,c2)
=PRT999(b999,c999)
Thanks for any reply-- I am not sure how to really post a question. Hopefully, someone will put up instructions for all of these frustrated Excel 2010 users.
Comments: (loading) Collapse