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.
One of the themes we focused on with Office 2007 was “great looking documents”. For the next half-dozen articles, I am going to explain what that means for Excel, and some of the cross-application features that users will see in Office 2007.
Way back when we were starting planning for Excel 2007, we talked to a lot of people about the documents they created using Office, and we looked at many, many examples of people’s work. We asked them about what they found difficult, what they would like to see fixed, and what they thought good-looking output looked like. We also looked at many examples of “professional” output, drawn from textbooks, business journals, scientific journals, and professional design firms. During our planning, it became clear that there was still a lot of additional capability that we could add in this area that would benefit all sorts of users, so we set out to really improve Excel’s capabilities in this area in a number of ways. Specifically, we set out to:
These goals translated in to the following work:
So that’s the introduction. Next time, I will cover some of the limitations we have changed as well as changes to cell styles.
Comments: (15) Collapse
Re: Address some long-standing print-related customer requests
This wouldn't happen to include finally being able to print multiple area selections on the same page? No doubt since Excel really isn't 3D it still won't be able to print ranges on different worksheets on the same printout page (a feature Lotus 123 has had since 1989).
The fact you spelt colour with a 'u' makes we wonder if Microsoft might finally get around to localizing Office for Australia, Canada or any of the other different English vernaculars. Office has had good non American English dictionaries for a while, why is the interface still lagging behind?
I remember when I was in school I would spell colour as "color" and centre as "center" because that was how the tool tips in office spelt them, this annoyed my teaches to no end and resulted in missed grades in English and Art classes.
It really does amount to an attack on non American English cultures; which I find very frustrating as it seems to be done without thought or with an attitude that it really doesn't matter.
Harlan, it dissapoints me to have to say no, that isn't one of them.
DesB, good question. I will ask some folks.
Harlan, I remember seeing some VBA coding that provides a work around to this problem... If you are interested let me know and I will provide a link to it (assuming I can find it!).
David (& XL Team), this looks like another feature to look forward to playing with! Keep up the good work...
To Simon Herbert,
Some of the VBA workarounds you'll find in the newsgroup archives will have my name in the sender line. My question what somewhat rhetorical. I didn't expect an affirmative answer. It'll still be necessary to paste picture links in new temporary worksheets to achieve the appearance of printing disconnected areas on the same printout page.
At least lots of the old kludges will still be as useful (necessary) in XL12 as they have been for years & years in older versions.
David,
So far, we have noticed that almost every post comes with a couple of good suggestions to improve features in excel. I am not an expert, but many of them do not seem to be that hard to implement, taking into account the experts at the excel team. These are valuable comments, as they are usually posted by experienced users (who are the majority of the readers of this blog). So, why don’t you post a list of suggestions (also opened to new ones) so readers can vote (and suggest) in what they believe is priority. I am sure this list will be huge, but will be a valuable source for excel team to focus on the next updates, which I read should come in shorter intervals than they have been coming so far. I bet it would be possible to have many of them done soon. Users will also be encouraged to participate more in this blog, voting and suggesting, and you will have a fairly good idea of what to do to make customers even happier next time...after all, the one who suggests/complains is usually the one who uses/knows the product the most.
It will be nice to see the following in excel charts:
tool-tip/bubble show up for every time series being plotted while moving the mouse in the x-axis of the chart(line chart). Say there are 3 time series data and a line chart is created from them, so X-axis is a time line and say y-axis is share price, we will have three lines for 3 time series, if the mouse is placed on any one time series, it gives the information about that point of that time series(with a pop-up or tool tip, heard people are calling it bubble), it doesn't show anything about the other 2 time series at the same point. It will be nice to have the option of seeing the tool tip/bubble for all the 3 time series as the mouse is moved along x-axis.
I know this is a bit OT.
But one of the existing limitations that I am hopping will get removed is the ~9K non-conitnuous cells that you can select (and delete) at a time in 2003
Is this in the pipe line
Sam, unfortuantely this is not one that we changed, but it is on the list for things to think about next time.
How can I get a copy of beta 2 of Excel 2007?
Thanks.
Richard - Please register at the Office 12 preview site:
www.microsoft.com/.../default.mspx
R102oy, I have passed that on to the chart team.
Fabio, you are absolutely correct, there have been hundreds of good suggestions. Since we are still some way from starting work on the version after 2007, and since I am sure that future posts will spark further good suggestions, I want to think a bit more about how to use all this information, but we definitely appreciate all the time and ideas you readers have provided, and I will let you know when the time comes.
where can download the office2007?my E-mail:nhxnic@gmail.com
Hello David
"Sam, unfortuantely this is not one that we changed, but it is on the list for things to think about next time."
This is a big disappointment. You give us a million rows. Dont you expect data to grow as well.
I mean lets say I filter on a data table of 80k rows for a criteria. And its says 10k records found.
I want to delete these 10 k records.... I cant do it....without writing a looping code in VBA....
Thats really sad.
Regards
Sam
Re Sam's comments:
Office and Excel are commercial products. There's less of a market for products in which just the current limitations of some functionalities are eliminated relative to current capacities vs increasing the capacities but leaving the limited functionality as-is. The same is true for certain string comparisons still being limited to 255 characters (a limitation that should have been addressed 9 years ago in Excel 8/97 when cell contents were allowed up to 32K characters).
When it comes to New! And! Improved!, new beats out improved every time. So boring for programmers to have to address existing functionality.
Comments: (loading) Collapse