What character cannot be used when creating a range name in excel?

Excel

1 answer

Answer

1130970

2026-03-01 02:50

+ Follow

In Excel, you cannot use spaces or certain special characters when creating a range name. Specifically, characters like punctuation marks (e.g., !, @, #, $, %, ^, &, *, (, ), etc.) are not allowed. Additionally, range names must begin with a letter, underscore (_), or backslash () and cannot be a cell reference (e.g., A1).

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.