will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Shifty Tricks in Excel
Posted on July 17th, 2008 by Debra Dalgleish
You probably know a few ways to use the Shift key in Excel, to extend the cells that you have selected. For example:
- Click on a cell, then hold the Shift key, and click on another cell. All the cells in between are selected.
- Hold the Shift key while you use the arrow keys, and cells will be selected as you move.
Here are a couple more Shift tricks:
- Select a cell, then click in the Name box, at the left side of the Formula Bar. Type the address of another cell, then hold the Shift key, and press Enter. The entire range will be selected.
- Select a starting cell, then hold the Shift key, and select a named range from the Name box drop down list.
Filed under: Excel
Comment from Jon Peltier
Time: July 17, 2008, 9:53 am
In the Name Box I usually select a cell, type a colon, then type the name of the second cell. Using Shift saves a mouse click. Also when I tested it the first time, I held Ctrl when I pressed Enter, and Excel selected only the two cells, not the entire rectangular range defined by them. So add this to your Controlly Tricks in Excel post.
Comment from Debra Dalgleish
Time: July 17, 2008, 11:43 am
Thanks Jon, controlly tricks are good too.
Comment from Donna Mills
Time: July 31, 2008, 7:25 pm
I love to close all of my open Excel documents (and use Save All) when I hold Shift and then File>Close All
I copy selected cells as a picture to paste into other places (PPT files, Word files, Outlook emails) by holding Shift and selecting Edit>Copy Picture
Comment from Debra Dalgleish
Time: July 31, 2008, 9:32 pm
Donna, thanks for sharing your tips. I wish Excel had a Save All, like Word has.