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 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 > home > cells > format > visibility > unhide row/column
Unhide the first column or row in a worksheet office.microsoft.com
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