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.
-
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...- Monkihunta
- Thread
- audio files batch file cell formatting file list file management file size scripting windows wordpad
- Replies: 1
- Forum: Windows Help and Support
-
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
-
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