Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
Home > English site > Articles > Defined Names > Special Names
Deze pagina in het Nederlands

Range Names In Excel

Special Names

Excel also uses defined names for built-in functions. The table below lists a few:

Used option
Print area
Print Titles
Advanced Filter Criteria

It is not wise to remove or change this kind of names using the Define Name dialog (or by other means), unless you know exactly what you are doing. It is better to let Excel handle those names.