| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Empty Cells Font for the Entire Workbook
Hi Everyone,
I have been given a Spreadsheet which needs Updating. The Current ( Default on Excel for the Person that the Sheet Belongs to ) Font is Set to "Ariel". I have Managed to Change the Column Letters and Row Numbers from "Ariel" to "Tahoma" by using "Format", "Style" and then Modifying the Font. All the Cells in the Spreadsheet ( and Workbook ) that have Information and Formulas in are Either "Tahoma" or "Comic Sans MS" Font. What I would Ideally like is a way of Changing ALL the Empty "Ariel" Cells ( A1:IV65536) to Empty "Tahoma" Cells in Both the Worksheet AND the Workbook. I would like a Method of Achieving this Manually AND with a Macro if Possible Please. I am using XP and XL2002. All the Best Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the font to all caps for the entire worksheet? | Excel Worksheet Functions | |||
| XY marker change for entire workbook | Charts and Charting in Excel | |||
| Change font color across entire row | Excel Discussion (Misc queries) | |||
| Change Print Quality for entire workbook | Setting up and Configuration of Excel | |||
| Highlight entire document and try to change font - won't change. | Excel Discussion (Misc queries) | |||
Threaded Mode
