Replies

Do the notes actually have to remain in PowerPoint? Could you export the presentation as handouts to Word, then add the additional text there? Just thinking out loud.

My guess would be to create a separate slide master for use on your second and subsequent slides. Put your heading on that slide master and it should carry through the rest of your presentation. Interested in what others might suggest.

Thank you! Wonder how that extra return got in the separator in the first place?

The “footnote separator” in that document has an extra return in it.

The quick fix is:
Change to Draft View
Go to References > Footnotes > Show Notes
In the pane that appears down the bottom, change the Footnotes dropdown to Footnote Separator
Edit the separator to remove the extra return.

You can read more info that is relevant here –> http://wordfaqs.mvps.org/NoteSeparators.htm

Kweaver, this works if I’m only looking for the grade after the final. I was more looking for a current grade at any point in time. The INDIRECT/ADDRESS function pair should work great. Thanks for the suggestion, though!

Maudibe, this works great, but I’m not sure I understand why. I pulled out my trusty “Excel Functions in Practice” (Blattner) to study up on these two functions.

Here’s what I understand: INDIRECT points to a cell containing a reference to another cell. The ADDRESS function is acting as the argument for the INDIRECT function.

The ADDRESS function creates a cell address, given a row and column number. SO….18-all the blanks: 18 is the last row of my data area; you subtracted the blanks to find the current row that contains data, and 12 is the column position (L is the 12th column). This returns the current cell address that contains a letter grade.

Wow – I think I just figured it out in rewriting it. Very cool set of functions. Thanks so much for the mini-lesson! 🙂

Agreed – far simpler for most use cases!

Just wanted to say thanks to everyone who is participating in this thread. In my Intro to Computers class today, we are talking about Excel Macros and VBA, and I used this as an example of a real life macro that was designed to save someone time. We didn’t get into the specifics of the workbook, but just reading the initial plea for help was enough to get them to understand the enormity of the emailing task, should they have been trying to accomplish it manually. It’s a great scenario, so thank you for asking the initial question! 🙂

That’s the thing – I don’t have the list of names.

Googling just gave me ideas for choosing random names from a list. I actually wanted to CREATE the names. I ended up doing a google search for .xls files and found a couple of different lists that contained names. Copied and pasted into a single Excel file. Viola! 500+ names.

Thanks for the ideas.

Today, I updated my copy of Office (University) at home (which did NOT have the inking functionality) and now I have it. Not sure why, but I’m happy!

Posting an answer in case others are looking for this. Finally figured out the correct Google question to come up with an answer…

https://support.office.com/en-us/article/Record-your-slide-show-in-PowerPoint-2013-9d136e4a-9717-49ad-876e-77aeca9c17eb?ui=en-US&rs=en-001&ad=US

Apparently the functionality is linked to an update, which is currently suspended. Some computers have been updated while others have not.

Those are outline levels. Either the sheet has subtotals applied, or the sheet is grouped and outlined. Clicking on each of the numbers will reveal (or hide) different levels of data.

Clicking the (1) generally only shows grand totals, the (2) would show category-level subtotals, and so on.

Here is some additional information on outlining.

Thanks for the general info and the link out to the blog. Neither really addresses the issue of having to display the tabs to navigate through pages, though.

Guess I’ll just have to get used to this new workflow.

One of the most frequent ways such corruption is caused is by using Word to manipulate/edit/print documents that are on removable media like flash drives. Within Word, you should act as if such devices do not exist.

?? Really? I have had hundreds of students saving hundreds of documents (and spreadsheets, and slide decks) to (and from) flash drives with no evidence of corruption. Curious why you think this is true?

I kind of figured that might be the case. Thanks for the response!

No, it isn’t, I’m afraid. You could always create a separate table from your original that sorts the data and base the chart on that.

I’ll give this a try, ron007. Thanks for the tip.