Numbers
Paste different column into different rows. What's the command for changing rows? Linebreak?
MacBook Pro 13″, macOS 10.15
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
Paste different column into different rows. What's the command for changing rows? Linebreak?
MacBook Pro 13″, macOS 10.15
Hello megamom,
If you just hit enter, or the return key, on your keyboard. If you want to go to the next line within the same row (multi line), hold option while hitting the enter key (option + return)
I hope this helps!
Hello megamom,
If you just hit enter, or the return key, on your keyboard. If you want to go to the next line within the same row (multi line), hold option while hitting the enter key (option + return)
I hope this helps!
Thank you Barry, Your right about my question not being clear. I was having trouble inserting data into a spreadsheet. That "Adjust import settings" seems to magically appear and disappear. Anyway, the answer I was looking for is the paragraph return symbol. Placing the paragraph return symbol at the end of all the columns I want to enter will place the next category into the next row. Thank you for taking time to help me.
Thank you for responding. I didn't structure a very good question.
I was having trouble inserting a list categories into different columns. At the end of one category going to the next row for another category. The answer is the paragraph return symbol at the end of columns for that specific category.
I appreciate you taking the time to help me. Thanks Again
HI mmom,
Not sure what you are asking here. Can you clarify?
A 'before and after' pair of images could be useful.
Possible option is to use the Transpose function
Barry
Numbers