Archive for the ‘Excel 2007’ Category
Thursday, July 31st, 2008
When working with a large worksheet in Excel, it’s often necessary to keep the row or column headings onscreen while working so you can see what you’re working with as you scroll down-screen. You can do this by Freezing Panes in Excel.
The only catch is in knowing how to ...
Posted in Customizing, Excel 2007, Views & Screen Parts | 6 Comments »
Monday, June 16th, 2008
This is how to paste data from Excel into Word when you want the pasted data to expand when the original data does. When you paste a link to a block of cells in an Excel worksheet, the data in Word will update when the Excel data changes, but it ...
Posted in Cut, Copy & Paste, Excel 2007, Range Names, Word 2007 | No Comments »
Wednesday, March 26th, 2008
The Office button holds a list of the 17 most Recent Documents you had open. If some of those are files that you open regularly, you can pin them to the menu so they won’t be shifted off the list as you open more files. To the right of each ...
Posted in Excel 2007, File Related, Word 2007 | No Comments »
Thursday, January 3rd, 2008
Add the commands you use frequently to this toolbar. Since the Ribbon can't be customized, this is the only place to gather your frequently used commands. The techniques to do this are the same in all the MS Office programs that have it.
Some of the basic commands can be added ...
Posted in Customize, Excel 2007, Screen Parts & Views, Word 2007 | 2 Comments »
Wednesday, January 2nd, 2008
Key Tips = Alt
What were once Keyboard Shortcuts in the MS Office programs are now Key Tips. If you're used to using the basic Ctrl+P, Ctrl+S, etc., they are going to work the same in 2007. What's been added is more convenient use of the Alt key to access the ...
Posted in Excel 2007, Screen Parts & Views, Shortcut Keys, Word 2007 | No Comments »
