Forum Home
Press F1
Thread ID: 126259	2012-08-16 17:51:00	Excel 2010	lostsoul62 (16011)	Press F1

Post ID	Timestamp	Content	User
1295114	2012-08-16 17:51:00	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 in the spreadsheet and change them to the font and color I want. However when I do this and I change the color and Fonts the entire cell. At least half of my diary is color coded so is there any way to just change one word throughout my document 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 the cell is change to the color of red with those fonts. On some of my cells there is an extra space at the bottom. At the bottom of the cell there is a line with nothing in it so I do an "Auto fit row height" but still some of the cell it doesn't work on. So I have to manually go to the bottom of the cell and made it smaller to fit. Does anyone know how to fix this?	lostsoul62 (16011)
1