You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025

Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Paste Numbers Spreadsheetlet in Apple Mail Email

Trying to come up with an invoice, or statement, for a few rentals.


The plan is to create a simple spreadsheet in Numbers (2 columns x 7 rows) each month, for each unit, then copy and past it in an Apple Mail Template then email it off. 


Problem: The columns in Number have the first row left justified and the left column RIGHT justified, as it should; however, when the spread sheet is copied and pasted in the email the right column becomes LEFT justified.


Comment: Problem exists in Mail and Text Edit, but not in Pages.

Any ideas?


Step 1 - create spreadsheet in Numbers:


Step 2 - Copy then Pasted spreadsheet in Email & TextEdit, 2nd column left justified

Mac Pro, macOS 10.12

Posted on Aug 27, 2020 12:33 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 27, 2020 1:06 PM

I was able to reproduce this issue and found that the cells that don't come across the proper way were not actually formatted to be right justified. In my workbook they were set to the auto justify option. (far right button on the justify selection are)


the cells that did respect the alignment were set to right justified using the third button


Select the range of cells, then go to the Format pane on the right, under the Text Tab, select Right justified. now try your copy/paste again.


let us know if this solves your issue, if not let us know and we can try to find other things that might cause it.


Thanks

Jason



Similar questions

7 replies
Question marked as Top-ranking reply

Aug 27, 2020 1:06 PM in response to Searchin99

I was able to reproduce this issue and found that the cells that don't come across the proper way were not actually formatted to be right justified. In my workbook they were set to the auto justify option. (far right button on the justify selection are)


the cells that did respect the alignment were set to right justified using the third button


Select the range of cells, then go to the Format pane on the right, under the Text Tab, select Right justified. now try your copy/paste again.


let us know if this solves your issue, if not let us know and we can try to find other things that might cause it.


Thanks

Jason



Aug 30, 2020 12:52 AM in response to Halliday

Halliday writes:

"By the way, Searchin99, «the justification box to the far right with the the letter A in it» is the default for most cells in Numbers.


It’s sort of an “automatic” justification (left for text, right for numbers, that sort of thing)."


It's not "sort of an "automatic" justification." The A is short for Automatic. With that setting, Numbers automatically aligns text to the left side of the cell and automatically aligns numbers and quasi numeric values (such as Date and Time values and Durations) to the right edge of the cell.


Justification refers to the action of the fourth button, which sets alignment to both left and right cell margins, and adds space between words (or between characters) to produce straight left and right edges in blocks of text. Although this can produce a 'neat' page of text, the varying spacing between words can be annoying (particularly on narrow columns) and tends to slow reading of the text. Images below are of two copies of this paragraph (in Pages) using the automatic left alignment, then using (full) justification.


Note the larger spaces between words in the second and second last lines of the second example.



Regards,

Barry




Aug 27, 2020 1:08 PM in response to Searchin99

Welcome, Searchin99, to Apple Support Communities!


We see you are having trouble keeping the alignment, within a table, the same from Numbers to pasting into a Mail message.


I have noticed that once I paste a Numbers Table into a Mail message, it looses many of its Table like features, even though it still looks a lot like a Table. (In Pages, it is an actual Table, not simply something that look like one.)


However, I found that if I explicitly set the alignment of a column to be right-justified, in Numbers, the pasted table-like “thing” in Mail was also right-justified. Using Numbers 10.1 on iPad Pro running iPadOS 13.6.1.


Please let us know if this helps any.

Aug 27, 2020 3:27 PM in response to jaxjason

Thank you, Jason, for the research including trying to reproduce the problem. I'm impressed ... Did what you suggested and it worked!


I've used Numerous for several years, but only occasionally as my wife does the accounting. Have to say, I've never noticed the justification box to the far right with the the letter A in it. I had *thought* the right justified button was selected but apparently not. Can't believe I selected the one with the A in it because I never used it before, but ... apparently that is what happened.


Bottom line, there are a lot of little nuances to using the application.


Like your screen shots in the reply, too. Always helpful. "A picture is worth a thousand words"

Thanks again.

Aug 27, 2020 3:40 PM in response to Halliday

Hi Halliday,

Thanks for your reply, too. And I agree with your "what you see is not necessarily what you get" comment. Happens more often that I'd care to admit. Worked on this for a couple hours and nothing worked. Just wasn't doing the right thing but it does now.


What I've found out now is that this approach to billing isn't going to be the best, but not sure what will be. This approach requires a file somewhere around 15KB to 60KB to be created each month, then duplicated when the email is Sent, then duplicated again if there is a reply. It's not only the file size but also the number of files, and it all adds up. Really need to analyze the process to find a less intensive file management system, with both size and labor..


Thank you for chipping in.

That iPad Pro is some iPad! My wife has one with the fancy pen and I got her really old one, Gen 2? I think. Gotta keep 'em happy!

Paste Numbers Spreadsheetlet in Apple Mail Email

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.