Change Empty Cells Font for the Entire Workbook

[Paul Black]

Hi Tom,

Changing the "Format", "Style" and Changing the Font from "Ariel" to
"Tahoma" ONLY Seems to Change the "Column Letters" and "Row Numbers",
it does NOT Change the Cells within the Spreadsheet. I tried Selecting
a Single Cell - Hitting the F5 Function Key - Special - Check Blanks -
OK, but this ONLY Changes them down to the Last Cell with Data in, it
IGNORES from there to "IV65536".

Thanks for your Help.
All the Best
Paul

 

[Norman Jones]

Hi Paul,

A Suggestion:

Open a new 'virgin' workbook
Select a worksheet (any)
Format | Style | Modify | Change font to Tahoma.| OK
Go to cell A1 - check the font - Tahoma, right?
Go to cell IV65536 - check the font - Tahoma, right?
Insert a column (anywhere)
Select any cell in the new column - check the font - Tahoma, right?

 

[Tom Ogilvy]

That isn't how you would test. You would test by going to a cell beyond
where that procedure puts you and typing in a string. Whala, Tahoma.

--
Regards,
Tom Ogilvy

Hi Tom,

Changing the "Format", "Style" and Changing the Font from "Ariel" to
"Tahoma" ONLY Seems to Change the "Column Letters" and "Row Numbers",
it does NOT Change the Cells within the Spreadsheet. I tried Selecting
a Single Cell - Hitting the F5 Function Key - Special - Check Blanks -
OK, but this ONLY Changes them down to the Last Cell with Data in, it
IGNORES from there to "IV65536".

Thanks for your Help.
All the Best
Paul




Tom, Unfortunately this is NOT the Case

We must be talking about differnt things. It certainly is true for me.

--
Regards,
Tom Ogilvy



same
time
as the
entry, and
the approach
over Check
Blanks | you
can
try to
Cell apply
the recorder,
do it (Paul
Black) A1:IV65536 )to
"Tahoma", Only
want
normal
style the
have go
to
this saving
changes. that
the
Sheet Change
the by
using or
"Comic ALL
the
Empty Both
the AND
with
a

[/QUOTE]

 

[Peter T]

Hi Paul,

I suspect at some stage, when the Normal font was Arial,
entire columns or rows or all cells were formatted with
Arial. This is not tautology.

Try this with Normal font = Arial:

- Select all cells (small square that intersects headers)
- Click Arial in the drop down font list (simply that,
nothing else)
- Change Normal Font to Tahoma
- All cells still have Arial - right?
- Clear formats in some cells (Edit > Clear > Formats)
- Font is now Tahoma - right?

In your problematic sheet in which you have changed Normal
font from Arial to Tahoma, select some cells that still
have Arial and clear formats. If they change to Tahoma the
conundrum is solved.

Solution:
Ctrl + End to select Last Cell
Clear formats in all rows one below to 65536 (row header,
Shit+End down arrow) and columns to the right (it's much
quicker to clear rows down first).
F5 Special > blanks > clear formats.

This should only take a few seconds per sheet. If you have
many to do then similar with a simple macro.

BTW, applying formats to entire rows or columns does not
impact the Used Range. F5 Special > Blanks only selects
within the UR.

Regards,
Peter