tag:blogger.com,1999:blog-1869924468172210809.post8601540577779633675..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: Ensuring that dropdown lists start at the top (and Merry Christmas)Glen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-1869924468172210809.post-88647786461040493572016-12-29T09:49:39.390+00:002016-12-29T09:49:39.390+00:00A dynamic range is a more elegant solution, but in...A dynamic range is a more elegant solution, but in most cases, I'm not sure there are any tangible benefits for the extra work and complexity involved in setting it up.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-57719212684631536302016-12-27T14:52:16.280+00:002016-12-27T14:52:16.280+00:00good points
how about a dynamic range which picks ...good points<br />how about a dynamic range which picks up all non-blank cells with conditional formatting that formats the 1st blank cell as though it were part of the range<br />I used to use dynamic named ranges all the time until I discovered tables, now I hardly ever need them (but I only improve others' spreadsheets to work better, not full-blooded developing)<br /><br />jimAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-36145963558839557222016-12-27T07:05:25.045+00:002016-12-27T07:05:25.045+00:00Jim
If I am developing a spreadsheet for someone e...Jim<br />If I am developing a spreadsheet for someone else to use, I try to avoid tables for user input, as Microsoft have yet to properly integrate them in sheet protection. You can't protect formulae or the sheet layout with a table on it, if you also want to add rows to the table. A defined range with space to add more can be locked down and also make it more obvious that items can be added.<br /><br />And this is not late. We've started to get some decent results the last few weeks and its only Christmas. We're usually lower than this in April!<br />All the bestGlen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-18127361712194877642016-12-26T23:44:22.417+00:002016-12-26T23:44:22.417+00:00PS
and a Happy Christmas to you too; good to see y...PS<br />and a Happy Christmas to you too; good to see you blogging againAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-30930427674589961502016-12-26T23:40:47.433+00:002016-12-26T23:40:47.433+00:00Why would you want to leave a blank at the end?
If...Why would you want to leave a blank at the end?<br />If your valid list is a table then it will automatically be extended when you add a new entry<br /><br />jim<br /><br />and don't you think you're leaving it a little late this season; I know you like to make the Escape exciting but this could be a little too farAnonymousnoreply@blogger.com