You are viewing a single comment's thread from:

RE: Step by Step - Named Ranges in Excel

in #excel6 years ago

@theexcelclub you made this nice and easy indeed to earn steem rewards. I have a number of spreadsheets set up using named ranges, but most often I would use Table format and use a column name in a formula over a named range. I know you can set up dynamic named ranges, but with tables, if you reference them in a formula and update the table with more data, the formula updates too. with static named ranges this does not happen.

Sort:  

I think I have to make a tutorial on dynamic named ranges now too, tables do rock and that is a great alternative :-)