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.
Tips
How-to
News
Videos
Stories
We know you're pressed for time, and you want what you read to be worth the effort. Our question to you is this: What kind of blog post about Excel works best for you? Do great tips help you work smarter? Maybe code examples unlock your creative side? Or do guest posts from Excel MVPs hit home? Take this poll, and be heard. And feel free to suggest something else in the "Leave a comment" section near the bottom of this page if you have any other ideas. Thanks!
The poll is closed, and results are shown above. Thanks again for voting and for your comments!
--Gary Willoughby
Comments: (31) Collapse
I started using this blog when it was created (2006 i believe) and it was about was about XL 2007 before the Beta was even out. I'm still getting here through the old http://blogs.msdn.com/excel/.
The blog used to be exactly what i needed, and it kept being extremely useful all the way 'till xl2010 beta. The contents was about upcoming versions of excel, mostly "what's new" with information that couldn't be found anywhere else.
Is there a new site with such purpose on microsoft.com? Couldn't find anything for the past 2 years.
Current site:
Personally, I do not need nor want the basic how-to articles that are published here.
While I understand that such a site can be useful to many users and should keep going as a separate site, I am very disappointed that ms has just discarded the old blog's original purpose. I miss it and I want it back.
Thanks.
(by the way, why is the thread titles' font so huge on this blog?)
I love this blog and I find it very useful!! I would like to see more things on Excel 2007, yes 2010 is great, but my employer hasn't upgraded to 2010 yet, so I'm still using 2007. Also I would love to see more macro examples. A really good one would be to open a new workbook, select a macro that will create 12 sheets all named JAN-DEC automatically. I've seen this done, but am not good enough to create the macro myself.
Because the help files are so much more sparse than they once were information regarding VBA and examples of how to code for specific results would be good. Either that or spend a bit more time on the help files so that they can be used as they once were as a real and useful way to find out how to achieve a given result by programming.
I'd also like to see some articles about VSTO. I understand that this is an Excel blog and VSTO may technically fall under Visual Studio, but ultimately it's about turning out advanced Excel applications and therefore has a place here.
@TezzerK: I'd suggest going to the Excel Developer Center, here: msdn.microsoft.com/.../aa905411.aspx. Hope you find that site helpful.
@Brandi: Ask and ye shall receive!
Sub MonthSheets()
Dim i As Integer
For i = 1 To 12
Select Case i
Case 1
strMo = "JAN"
Case 2
strMo = "FEB"
Case 3
strMo = "MAR"
Case 4
strMo = "APR"
Case 5
strMo = "MAY"
Case 6
strMo = "JUN"
Case 7
strMo = "JUL"
Case 8
strMo = "AUG"
Case 9
strMo = "SEP"
Case 10
strMo = "OCT"
Case 11
strMo = "NOV"
Case 12
strMo = "DEC"
End Select
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Select
Sheets(Sheets.Count).Name = strMo
Next i
End Sub
@Brandi: "open a new workbook, select a macro that will create 12 sheets all named JAN-DEC automatically. "
Option Explicit
Sub New12MonthWorkbook()
Dim i As Long
Workbooks.Add (xlWBATWorksheet) ' new workbook one sheet
Worksheets.Add Count:=11
Worksheets(i).Name = MonthName(i, True)
Next
@sysmod: Very nice! You certainly know your object model!
awesome! Thank you!!!
@Sebastien: Thanks for your input; you’re right in that we changed the focus of the blog based on feedback from readers. We hope you’ll continue to visit and learn new things about Excel.
In the meantime, you might visit the Office 2010 area of the TechNet blog, if you haven't already: blogs.technet.com/.../Office+2010
I do read technet too, but rarely as it doesn't really pertain to me.
As a gold partner, i am lucky to get software releases in advance which is a must to get our software updated & ready in time. However, Previews & Betas are usually missing the help file and info is sporadic.
This site exposed the latest & newest features and object model changes of Excel 2007 much earlier than usual; this gave my company the unique opportunity to not just update our software in advance but also, for the first time, to integrate some of the newest excel features much earlier than usual.
As an excel user, I also used the knowledge on this site to build demos with the Excel Preview, each demo specific to each of my customers, showing them the new features and how to use them to solve their business problems. I believe this has helped them adopting the latest version of Office sooner.
I'm curious, what was the reason for changing the focus of this blog?
And I suppose there isn't a new early site for Excel 15?
Thanks
When useing EXCEL, I select "Data", "Filter", "AutoFilter, it creates a "carrot" at the top of all the columns, which is what I want. When I select a "carrot" and pick an option, the carrot's color changes from black to dark blue, which is very hart to see. Is there a way to change the carrot from dark blue to "RED" to make it easier to see?
Also is there a way to de-select all carrot options that have been elected?
@Phil: Looks like you're using Excel 2003 or earlier? Nope, no way to change the color of the arrow from blue to another color when you've applied a filter. Note that, in Excel 2007 and later, a filter icon (looks like a funnel) appears next to the arrow when you apply a filter. Good question, though.
There are many other places to learn how to use Excel. Shame the newsgroups are now so difficult to use via nntp/newsreaders. This is the ONLY place to get current information on what MAY become new in Excel.
There used to be a voting blog about various Office features. I lost the url to it, but it's probably dead. That'd be an interesting feature here - an open ended poll of the best AND WORST features in Excel allowing users to add candidate best and worst features as well as add comments.
re macro to create workbooks with abbreviated month names as worksheet names: why not create it ONCE and save it as a template?