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

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.

Trainings

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

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
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

Name

Print area

Sheet1!Print_Area

Print Titles

Sheet1!Print_Titles

Advanced Filter Criteria

Sheet1!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.