AHH! I have been working on a handout and when I copy the words from one page to another, there is a white highlighting. I have marked "no highlight" ... but still, it highlights.
Here is the solution I found. Choose "Clear Formatting". It removes all the formatting so I had to redo the Heading 2 Style that I was using ... but it worked. It is on the home tab and looks like a little eraser, and in the Styles Pane.
0 Comments
Having been lucky enough to be an Excel Trainer for many years, I can't believe I forgot how to do this and had to look it up!
I was tracking how many different times people attended training, but I wanted Excel to tell me how many people were unique and give a count for each person. It is under Data - Sort and Filter - Advanced. Then I had it copy the data to another row and only show unique values. Then I ran a count of the names, and it was done! |
AuthorTeacher, Writer, Editor, Instructional Designer. Archives
June 2021
Categories
All
|