auto fit

  1. Windows 7 Struggling to Print Complex Excel Diary: Seeking Solutions and Advice

    I have a 20 year Diary in Excel 2010 which I spent over 1,000 hours on. It is complex. I have over 5,000 lines and over 15,000 cells which are all color coded and fonts coded. Because of the complexity of the spreadsheetI have to do everything manually. I can't go and correct any fonts are color...
    • lostsoul65
    • Thread
    • auto fit cell formatting color coding complexity data entry diary document management excel formatting manual correction microsoft print quality printer printing recommendations row height spreadsheet troubleshooting user experience
    • Replies: 1
    • Forum: Windows Software

  2. Windows 7 How to Find and Replace Text in Excel 2010 Without Changing Entire Cell Formatting

    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...
    • lostsoul65
    • Thread
    • auto fit cell formatting color change diary excel find and replace font update row height spreadsheet word processing
    • Replies: 1
    • Forum: Windows Software