More Excel 2010 Posts

imageThere’s some more Excel news, ads, and articles showing up.  Check out this post on the Office blog to see a couple of videos on the introduction of sparklines to Excel, one made by us and another by MrExcel … and since we’re on the topic, below is a couple of recent videos from MrExcel that feature sparklines:

 

image

Episode 1195 - Add shading to your sparklines to specify acceptable ranges.


image

Episode 1194 – Add labels to your sparklines.

Office Blogs Comments

Comments: (16) Collapse

  • I have used Excel 2007 on a PC for years and have many files that use advanced conditional formatting (such as data bars and symbols).  I have moved to a MAC and have Excel 2008.  I am SICK that the data bars and symbols are not included in the MAC version.  Are there any plans to fix this?  Can I purchase a plug in? Is this because of the VBA issues?   What are my options?  I am a loyal user and would appreciate a response.

  • This guy is so full of himself you are not able to see what he is doing because his face is in front of the graphs. Great distraction!

  • To heidi,

    tough luck!

    I have reporting a bug for years on their forums, they do not even respond. Sometimes I wonder why I bother.

  • heidiR - A new version of Mac Excel is coming out later this year, I've shared this feedback with the Excel mac team, keep an eye on their blog for more information: www.officeformac.com/blog

    kikoki - which bug have you been reporting, please send me an email on it via the link at the top of this blog.  thanks!

  • Compatibility Viewer?  I know that when 2007 came out there was an Office compatibility viewer to view Office 2007 documents.  With the implementation of slicers, tweaking of the conditional formating, and sparklines, will there be an excel viewer for older formats to share the visuals of these new features?

  • Hi,

    I am starting to use the sparkline for Excel 2010. Is it possible to do a find and replace after I am finished with putting a bunch of charts on one page? I want to redo the chart for a different product line and don't want to have click through every chart to re-type in the reference.

  • johncon - i don't think there is going to be an update to the compatability viewer for 2010, but you will be able to use the Office web apps to view the new 2010 features, little more information here:

    blogs.technet.com/.../default.aspx

    nuoctuong - please send me a mail with more info on how you want to change it, there might be a way through some formula adjust, but it might also take a macro to loop through it.

  • hi i m trying to use the excel but i know easily 2007 office

  • Tring to find templates for excel 2010 but when putting this in the dialogue box-i get 2010 calendars. On Microsoft is there some secret way to find these or are we held hostage to only ever download calender templates that does not even work in the new office system?

  • I use Microsoft Excel for a living and am very familiar with the applications- a few things that I think would be helpful (if they are not already available) would be if you could copy/paste special/ transpose AND links- seems like now you can only paste transpose and values. Another thought would be if you could sort data and use the find and replace by other things like cell color and font. Are these applications currently available?

  • This may be off topic but does Outlook team have any plans to introduce Outlook Services for SharePoint and have server based fast printing / ops like Word Services for SharePoint?

  • This may be off topic but does the Excel team have any plans to introduce Excel Services for SharePoint and have server based fast printing / ops like Word Services for SharePoint?

  • Hello Everyone

    I am Vikas from new Delhi. (India) Need some help in Macros.

    The requirement is as follows.

    1. We have lets says 10 Files of Excel and want to combine those files in One Worksheet, all the data in all the files is in the same format. Is it possible.

    Thanks and Regards

    Vikas

  • I am having a problem printing in excel. I go to view>page break review, set everything up and then hit print. it automatically resizes everything and prints out 2 pages instead of one. its like it has auto sizing on when it prints. this is very annoying. do you know how to fix this??

    jgunnels@kwintl.com

  • I use conditional formatting in Excel 2007 frequently.  However, only 3 reference colors can be implemented at a time.  I am hoping this will be improved in 2010.  Until then, I rely heavily on editing in photoshop so that I can use more colors.

    Also, I hope more control will be available for manipulating multithreaded calculations since the 2007 system is not very good at identifying when and where a problem can be multithreaded.  With between 8 and 24 core computers becoming the norm over the next few years this will become highly desirable for people who actually utilize significant computational power with their spreadsheets.

1 2  Next >
Comments

Comments: (loading) Collapse