ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   List Will Not Automatically Expand (https://www.excelbanter.com/excel-discussion-misc-queries/200391-list-will-not-automatically-expand.html)

Marvin Buzz

List Will Not Automatically Expand
 
I have data in cells a1:c10
Row 1 contains column headings. I create a list, and get the blue border
with an asterisk (*) in a11.

I expect the list to expand if I type or paste into a11. Instead, the typed
data appears with the asterisk superimposed over the data. If I move select
a cell outside of the list, the newly typed data remains, but if I select a
cell within the list, the asterisk appears in a11, and the new daya appears
in a12, outside the border of the list.

Any help would be appreciated.

Thanks.



All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com