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
Thanks to Robin Wakefield for putting together this post on touch.
With the new Windows 7 Touch platform you now have the ability to interact with applications by touching the screen. This paradigm is a huge success in the mobile market and as the hardware evolves, applications utilizing touch input will become more broadly available. We will likely begin to see touch as the primary interaction method for some PCs such as wall mounted displays used as a kiosk as well as to enhance the experience for a tablet laptop. The touch gestures are built into the core of Windows 7 which means previous versions of Excel and many other applications will already respond to touch gestures without any changes.
Our goal for Excel 2010 was to ensure these gestures were smooth and predictable when it would be inconvenient to use your mouse or keyboard either because your tablet pc is in tablet mode or it is quicker to simply touch the screen to access information in an Excel file. In order to do that we partnered with the Windows 7 team to review how well the gestures worked “out of the box” in Excel to determine if there were any changes we needed to make to optimize the reading experience.
Below are the gestures supported by Excel and the details about the changes we made to them in 2010.
Touch Gesture
Pre Excel 2010 Behavior
Excel 2010 Behavior
Tap and Double-tap - Touch and release to click.
This is the most basic touch action and it worked well in Excel without any changes.
Same as prior versions.
Scroll – Drag up or down on the content (not the scrollbar) of scrollable window to scroll. Scrolling is available with one or more fingers.
Since the surface of Excel is a grid of cells, the scrolling felt choppy and horizontal gestures were not picked up as a scroll.
We decided to enhance the vertical scrolling so it would feel smooth and add the ability to scroll horizontally as these are core to the scenario of reading that we targeted. You’ll notice details that make this a more natural interaction: the inertia if you scroll and the little bounce when the end of the worksheet is reached.
Drag – Touch and slide your finger on screen (like dragging with a mouse).
This worked well in prior versions of Excel.
One of the tradeoffs of adding the ability to scroll horizontally was we lost the ability to drag and move objects like shapes and charts around your worksheet. We felt that horizontal scrolling was more important in the context of Excel and the scenario of reading that we felt would be most common. There is a workaround of turning off single finger panning or using the Press-and-hold gesture to get a right click and then drag.
Zoom – Pinch two fingers together or apart to zoom in or out on a worksheet.
This worked well in Excel without any changes.
Press-and-hold – Hold your finger on screen for a moment and release after the animation to get a right-click.
This worked well in Excel without any changes. You can access context/right click menus using this gesture.
Same as prior versions. In 2010 you can also use this as a workaround to drag objects.
Press-and-tap with a second finger – to get right-click, just like you would click the right button on a mouse or track pad.
The following gestures are not supported by Excel.
Comments: (2) Collapse
back and forward gesture idea: move to next / previous worksheet (like ctrl + pgdn / pgup )
Hello,
I've started working with Excel 2010 and I like it a lot.
One quick Q, can the slicers show calculated members ?
In the filter I can see them but not on the slicer.
Tnx,
Michael Raam