the microsoft office button
Office templates office.microsoft.com
Customize the ribbon office.microsoft.com
Keyboard shortcuts in the 2007 Office system office.microsoft.com
Auto Macros Office 2007 msdn.microsoft.com
This is for Word only
VBA Language Reference msdn.microsoft.com
Error: User-defined type not defined office.microsoft.com
About the Browser msdn.microsoft.com
shdocvw.dll
this is old; IE 4
PowerPoint
PowerPoint is Evil Edwart Tufte, wired.com
"Power Corrupts.
PowerPoint Corrupts Absolutely." - Edward Tufte, September 2003
Visio
Visio statechart office.microsoft.com
Visio - Import data from Excel, SQL Server, SharePoint sites, and other external sources
Access
Build an Access database to share on the Web office.microsoft.com
Desktop Northwind 2007 sample database office.microsoft.com
Access PassView utility nirsoft.net
Excel
Excel personal macros office.microsoft.com
Personal.xlsb
C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART
Enable the developer tab in the ribbon > record a macro > save it in personal macro workbook
Copy a macro to another workbook office.microsoft.com
Excel shortcut and function keys office.microsoft.com, Excel 2007
To change the color palette
Excel > Options > Save > [no this is only for previous versions of excel]
How to change the color palette for workbooks in Excel
To find links
To find formula links search for the left bracket: '['. Links are also used in names and other objects.
Find external references (links) in a workbook office.microsoft.com
To delete links to external files:
The Delete Links Wizard is an add-in file for Microsoft Excel that you can use to delete links to external files in one or more workbooks. Currently, the only way to perform this task is to manually delete the links or to use a Microsoft Visual Basic for Applications macro to search, find, and delete the links.
Note that there are multiple types of links:
Master Formula Links
Defined Name Links
Hidden Name Links
Chart Links
Microsoft Query Links
Object Links
Excel delete links wizard support.microsoft.com
To unhide the first row or first column:
select a hidden cell by typing 'A1' in the Name box > enter > home > cells > format > visibility > unhide row/column
Unhide the first column or row in a worksheet office.microsoft.com
[note this does not always work; bug?]
Default font
microsoft office button > excel options > popular > when creating new workbooks
use this font: body font
font size: 11
To change the body font
[body font is defined for each theme; you can't change the built-in themes but you can create a new theme]
page layout > [themes] fonts > create new theme fonts
Using structured references with Excel tables office.microsoft.com
- special item specifiers #All, #Data, #Headers, #Totals, #ThisRow, etc.
Excel internal date format
Excel stores dates as serial numbers, beginning with January 1, 1900 as day 1.
Subtracting two dates results in the number of days between the two dates.
General ways to deal with CSV in Excel superuser.com
Excel auto macros ozgrid.com/VBA
Create and save all your macros in a single workbook Excel 2007 office.microsoft.com
Copy visible cells
(don't copy hidden cells)
Excel > Home > Find & Select > Go To > Special > Select 'Visible cells only'
then copy and paste as usual
Copy visible cells only office.microsoft.com
Delete hidden rows and columns Excel 2007
Office button > Prepare > Inspect Document > Inspect
Hidden Rows and Columns > Remove All
Turn off Display Page Breaks
Once you print a page or use Print Preview, Excel figures out the page breaks and you will see them as bold dashed lines on your sheet. This may slow down your use of Excel considerably depending on what print drivers you are using, for instance. They can really slow down macros to the point that you may want to turn off Display Page Breaks in some macros. Examples such as when you change the page layout by hiding/deleting/inserting rows/columns so that Excel has to recalculate page breaks with each change.
To turn off the Display of Page Break lines once you've been in Print Preview:
turn off manually: Tools --> Options --> View --> (uncheck) Page Breaks,
turn off in VBA: ActiveSheet.DisplayPageBreaks = False
Page Break lines will appear again and this box will get checked when you print or use print preview.
[Page Breaks dmcritchie.mvps.org]
Error message: To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet support.microsoft.com
My Excel Pages - David McRitchie dmcritchie.mvps.org
OneNote
Find and replace text in notes office.microsoft.com
- this is basically manual copy and paste; consider making bulk changes in another tool
Outlook
Create an e-mail template office.microsoft.com
Outlook > [new mail message] > [save as outlook template]