How do I fill multiple cells in a row with single named range?
I want to complete a form from a detailed worksheet. The form is financial
and the data are by month with quarterly subtotals. When I type =name_range, I only get the first value in the named range. I want all twelve cells to fill from the name range |
How do I fill multiple cells in a row with single named range?
To do that, select all 12 cells, type:
=name_range and then press Ctrl+Shift+Enter to confirm, not just Enter. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mike Patterson" wrote: I want to complete a form from a detailed worksheet. The form is financial and the data are by month with quarterly subtotals. When I type =name_range, I only get the first value in the named range. I want all twelve cells to fill from the name range |
All times are GMT +1. The time now is 04:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com