I have Excel 2010
I have a Diary which has 5,000+ cells(20 years) I want to do a "Find and replace" Find all the words inthe spreadsheet and change them to the font and color I want. However when I dothis and I change the color and Fonts the entire cell. At least half of mydiary is color coded so is there any way to just change one word throughout mydocument to the font and color I want without the entire cell being change.Example: I might want to change the word "work" to "Work" and if I do that every word in thecell is change to the color of red with those fonts.
On some of my cells thereis an extra space at the bottom. At the bottom of the cell there is a line withnothing in it so I do an "Auto fit row height" but still some of thecell it doesn't work on. So I have to manually go to the bottom of the cell andmade it smaller to fit. Does anyone know how to fix this?