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.
It's still January. There's still time to share the most popular posts on the Excel blog in 2011. Thanks for reading them!
When we looked back to see which post received the most comments, it not all that surprising. It was the one when we got to hear from all of you:Your call: What would you like us to post about on the Excel blog?
As we start this new year (ok, it started four weeks ago), we want to hear what you'd like us to write. So leave a comment, and we'll do our best to write a post to answer it.
I have a good long list of documented shortcuts that do not work in the German version or where the documentation is wrong. Would anyone be interested in filing and eventually fixing them in a future version?
List of bugs (as said in the German version of Excel 2010):
Shift-F5 is not listed (open Name manager)
Shift-Ctrl-6 - does not assign a border to selected range (as mentioned in help)
F9 - calculate in edit mode is not listed as short cut
Shift-Ctrl-_ removes frame versus adding frame to selected cells (as mentioned in help)
Ctrl-# - assigns date format (versus Shift-Ctrl-# as mentioned in help)
Ctrl-# - to toggle values & formulas does not work and is not listed in all lists (in some places the US equivalent of Ctrl-' [apostrophe] is listed.
Shift-Ctrl-@ does not work at all (should assign time format)
Ctrl-. Is not listed (enter current date at cell)
Ctrl- - (minus) - deletes a row/column (does not open delete dialog as help claims)
Shift-Ctrl-" does not copy from cell above (as help says)
Does anyone know how to copy a range of cells from one spreadsheet and paste to a second spreadsheet ignoring the hidden columns in the destination spreadsheet. I really don't want to use code. I'm using 2010. firstname.lastname@example.org
Each month we get an Excel spreadsheet with a lot of data in rows and columns. The left hand column has customer numbers. In a spreadsheet with 1,000 customer numbers, there may be some numbers that are skipped due to no sales. Therefore in column A, you would see 1,2,3,4,5,7,8,10,12,13,14,15,19,20….
Currently, we go down each row and physically insert a blank row where a number was skipped. 1,2,3,4,5,blank,7,8,blank,10,blank, 12,13,14,15,blank,blank,blank,19,20. As you can easily see, this is very time-consuming and ripe for errors. We do this to match up sales rep information.
If anyone can come up with a formula that would automatically insert a blank row between non-sequential numbers
Very useful site. I have read and collected for information. Thank you.I am watch for your site. Details is excellent. And do follow for your site. very nice and wonderful.I read best information collect for your site. Thank you.