Copying excel data with row and column headings - Mac

[naita]

In math class my students need to be able to use excel and copy their work to word. On exams that data has to have row and column headings.

I know one can take a screen shot or use an excel objects, but it’s preferable to have as uncomplicated a procedure as possible.

I just found a method that works under windows, but I’m not a Mac user and trying to figure out if I can do the same there is proving not to be a good project as my first mac adventure. Searching the net doesn’t seem to give me the good results I’m looking for.

The method under windows is as follows:

In Excel 2010 you:
Go to Page Layout tab and click on the Page Setup launcher in the bottom right corner of the Page Setup group
Go to the Sheet tab and tick the setting for ‘Row and column headings’ and click OK
Select the range you want to copy
Go to the Home tab and click the dropdown for Copy and choose ‘Copy as Picture’ and select the ‘for printer’ option

Is there a way to do the same on a mac?

[Reply]

@naita

In math class my students need to be able to use excel and copy their work to word. On exams that data has to have row and column headings.

I know one can take a screen shot or use an excel objects, but it’s preferable to have as uncomplicated a procedure as possible.

I just found a method that works under windows, but I’m not a Mac user and trying to figure out if I can do the same there is proving not to be a good project as my first mac adventure. Searching the net doesn’t seem to give me the good results I’m looking for.

The method under windows is as follows:

Is there a way to do the same on a mac?

IMO that sounds horribly complicated. Using the Windows Snipping Tool to take a partial screenshot and pasting that into word would seem simpler. Or you can just use Alt-Printscreen to take a picture of the Excel window only.

On the Mac it’s even easier. Use Command+Control+Shift+4, the cursor turns into a camera icon, drag a box over the section you want to capture, and then paste it into Word.

[naita]

I wasn’t aware that windows now included a simple tool like that. Thanks!

[Reply]

(dupe)

[Reply]

Sure. It’s really easy to use and auto copies to the clipboard when you drag a rectangle. Good luck.

[bordelond]

@Reply

Sure. It’s really easy to use and auto copies to the clipboard when you drag a rectangle. Good luck.

Was kind of wondering why the OP wasn’t doing it this way already. Sepcifically, I was wondering if the data set was so large that dragging the rectangle out was a pain in the rear.

If so, you can start at the upper leftmost “corner” of your data and press [Shift]+[Control]+[Down Arrow]**, then [Shift]+[Control]+[Right Arrow] to select all the data with just a few keystrokes. Then Copy & Paste as normal.

** or Mac equivalent. Navigating Excel this way is fundamental to the program, so there is definitely a Mac equivalent.

[Reply]

@bordelond

Was kind of wondering why the OP wasn’t doing it this way already. Sepcifically, I was wondering if the data set was so large that dragging the rectangle out was a pain in the rear.

If so, you can start at the upper leftmost “corner” of your data and press [Shift]+[Control]+[Down Arrow]**, then [Shift]+[Control]+[Right Arrow] to select all the data with just a few keystrokes. Then Copy & Paste as normal.

** or Mac equivalent. Navigating Excel this way is fundamental to the program, so there is definitely a Mac equivalent.

I think the OP meant “headers” as in row numbers and column letters, which normally don’t get copied. Hence the screenshot.

[bordelond]

@Reply

I think the OP meant “headers” as in row numbers and column letters, which normally don’t get copied. Hence the screenshot.

Ah – if that’s the case, it’s no problem to make your own headers and row numbers as needed. Just have to do it within the “body” of your data set – e.g. Column A will have values [1, 2, 3, 4 …] while Row 1 will have values [A, B, C, D, …]. Then Row 2 can contain the “real” column headers.

[naita]

@bordelond

Ah – if that’s the case, it’s no problem to make your own headers and row numbers as needed. Just have to do it within the “body” of your data set – e.g. Column A will have values [1, 2, 3, 4 …] while Row 1 will have values [A, B, C, D, …]. Then Row 2 can contain the “real” column headers.

Sure, but these are kids with poor math skills and the less complicated the better. I can just imagine them leaving school thinking writing A1, B, C, D, E, F in the top row is necessary for some to them unfathomable reason. I’m gonna use screenshots since the process of getting just a part of the screen has become so simple.

[Reply]

PS - Why not have them use Google Sheets instead of Excel? It’s free, they can access their work from any computer, and they can share their worksheets with you directly and skip the copy-paste voodoo.

[naita]

@Reply

PS - Why not have them use Google Sheets instead of Excel? It’s free, they can access their work from any computer, and they can share their worksheets with you directly and skip the copy-paste voodoo.

The cost doesn’t matter since the county supplies Word and Excel to them all. And the copy-paste voodoo is necessary since being able to share sheets with me doesn’t help them when they need to turn in their work on paper, in a particular form, for national exams graded outside the school.

[Reply]

@naita

The cost doesn’t matter since the county supplies Word and Excel to them all. And the copy-paste voodoo is necessary since being able to share sheets with me doesn’t help them when they need to turn in their work on paper, in a particular form, for national exams graded outside the school.

Ah, ok.