cell formatting

About this tag
Cell formatting in Excel is a common topic on WindowsForum, where users seek to control the appearance of individual cells or text within cells. Discussions cover challenges like printing complex spreadsheets with color-coded and font-coded cells, finding and replacing text without altering entire cell formatting, and listing metadata such as audio file lengths in a cell format. Users often struggle with Excel's behavior when applying changes globally, wanting to preserve existing formatting while updating specific content. These threads highlight the need for precise cell formatting techniques in Microsoft Excel, especially for large, manually maintained workbooks.
  1. M

    Windows 7 Listing out Metadata

    Hi, I have a big bunch of audio files, and I'd like to list them out in cell format with the lengths in seconds listed out next to them. I have a simple batch file that I found online that lists out filenames in wordpad. Is there something similar that would list out the file names with the...
  2. lostsoul65

    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...
  3. lostsoul65

    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...
Back
Top