New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Other Hardware and Peripherals Other Apple systems and peripherals discussion.

excel for mac 2004 question


Post Reply New Thread Subscribe

 
Thread Tools
Terry1121

 
Member Since: Oct 02, 2008
Location: Erie, PA
Posts: 10
Terry1121 is on a distinguished road
Mac Specs: Mac OS X Leopard, 2.4GHz Intel Core 2 Duo iMac, 2GB 800MHz DDR2 SDRAM

Terry1121 is offline
I need to change the font size of my row and column headers, they are too big.

I tried Format > Style > Modify > Font...no luck. It changed the default font of the page but left the headers unaffected.

I saw nothing (except R1C1 option under General) in Preferences.

Can anyone help? Much appreciated.

Terry
QUOTE Thanks
hughvane

 
hughvane's Avatar
 
Member Since: May 18, 2008
Location: Banks Peninsula, New Zealand
Posts: 3,263
hughvane is just really nicehughvane is just really nicehughvane is just really nicehughvane is just really nicehughvane is just really nice
Mac Specs: MacMini 2.4, 4 Gb, OS 10.9 and 10.6; MacBook 2.4, 2 Gb, OS 10.6.8

hughvane is offline
Strictly speaking, this is a software or applications issue, so you may find it moved.

I cannot find Font via the pathway you've outlined, nor R1C1 in Prefs. Headers should be dealt with via Page Setup > Header/Footer > Customize, wherein you can set font and size using the instructions provided.
QUOTE Thanks
Terry1121

 
Member Since: Oct 02, 2008
Location: Erie, PA
Posts: 10
Terry1121 is on a distinguished road
Mac Specs: Mac OS X Leopard, 2.4GHz Intel Core 2 Duo iMac, 2GB 800MHz DDR2 SDRAM

Terry1121 is offline
Not that kind of header/footer. I'm talking about row and column headers - the numbers down the side of the rows and letters across the tops of the columns.

Terry
QUOTE Thanks
hughvane

 
hughvane's Avatar
 
Member Since: May 18, 2008
Location: Banks Peninsula, New Zealand
Posts: 3,263
hughvane is just really nicehughvane is just really nicehughvane is just really nicehughvane is just really nicehughvane is just really nice
Mac Specs: MacMini 2.4, 4 Gb, OS 10.9 and 10.6; MacBook 2.4, 2 Gb, OS 10.6.8

hughvane is offline
Quote:
Originally Posted by Terry1121 View Post
I'm talking about row and column headers - the numbers down the side of the rows and letters across the tops of the columns.
Okay, I did wonder about that (and I've found the R1C1, just missed seeing it earlier).

If I go to Format > Row > Height, I can change that to a desired number and shrink or expand the cell height. Similar with Format > Column > Width. Is that what you want to do?

How to make the settings the default I've yet to discover.
QUOTE Thanks
Terry1121

 
Member Since: Oct 02, 2008
Location: Erie, PA
Posts: 10
Terry1121 is on a distinguished road
Mac Specs: Mac OS X Leopard, 2.4GHz Intel Core 2 Duo iMac, 2GB 800MHz DDR2 SDRAM

Terry1121 is offline
I noticed I was in the wrong heading but when I tried to Edit my post to either move it or just cancel and rewrite it under the right heading, I couldn't do either. I thought that was odd.

Anyway, the font is too big for the row height. It doesn't change as row height changes. It's annoying and it wasn't always that way.

Terry
QUOTE Thanks
hughvane

 
hughvane's Avatar
 
Member Since: May 18, 2008
Location: Banks Peninsula, New Zealand
Posts: 3,263
hughvane is just really nicehughvane is just really nicehughvane is just really nicehughvane is just really nicehughvane is just really nice
Mac Specs: MacMini 2.4, 4 Gb, OS 10.9 and 10.6; MacBook 2.4, 2 Gb, OS 10.6.8

hughvane is offline
Quote:
Originally Posted by Terry1121 View Post
the font is too big for the row height. It doesn't change as row height changes. It's annoying and it wasn't always that way.
I agree, Excel is annoying - period. One of the most fiddly and yet universally used spreadsheet apps ever!

Re the font size - after changing the column/rows etc dimensions, you'll need to change the font size as well. That is done via the toolbar at the top. Excel treats cells, columns, rows etc, and text, as quite different entities.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,554
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
I've never known the row and column headings/headers font to adjust to the size of the row/column. I also don't know of a way to change the font size myself. It's probably more of an issue with short rows than with narrow columns, eh? But, why is it an issue? Do you want them to print? (You can set it so that you see them on the screen, but they don't print.) Or, do you want to be able to read them on screen when working with formulas? (But, if that's the case, wouldn't a row that's so short that you can't read the header also be so short that you can't read what's in the cell unless your font size for that cell is tiny?) What's your issue with this behavior?
QUOTE Thanks
Terry1121

 
Member Since: Oct 02, 2008
Location: Erie, PA
Posts: 10
Terry1121 is on a distinguished road
Mac Specs: Mac OS X Leopard, 2.4GHz Intel Core 2 Duo iMac, 2GB 800MHz DDR2 SDRAM

Terry1121 is offline
The font size is too big. Much bigger than the default size of, say, 10 or 12. It's more aesthetics than anything. It doesn't happen in every file though. Perhaps it got changed somehow in saving certain ones. It's a mystery. I know in Excel for Windows you can change the font style and size of the headers at will. I've done it but it's been way too long since I used a PC to remember how.

It's not critical. Thanks for thinking about this. I was hoping is was something simple I was missing.

Terry
QUOTE Thanks
hughvane

 
hughvane's Avatar
 
Member Since: May 18, 2008
Location: Banks Peninsula, New Zealand
Posts: 3,263
hughvane is just really nicehughvane is just really nicehughvane is just really nicehughvane is just really nicehughvane is just really nice
Mac Specs: MacMini 2.4, 4 Gb, OS 10.9 and 10.6; MacBook 2.4, 2 Gb, OS 10.6.8

hughvane is offline
Quote:
Originally Posted by Terry1121 View Post
The font size is too big. Much bigger than the default size of, say, 10 or 12.
In my version of 04 Excel (11.5.3 - must update it when back on b/band), the smallest listed font size is 8, but I believe you can reduce that further with the keystoke Cmd-[.

Quote:
I know in Excel for Windows you can change the font style and size of the headers at will. I've done it but it's been way too long since I used a PC to remember how.
Fellow feeling there. I worked Excel in Windows about 9 years ago and (casting furtive glances) I much preferred it to the Mac version. Of course it was initially designed for WinOS, so it's not surprising.

As said earlier, I can change font, size and style readily by using the toolbar, which I have positioned above the open worksheet. What do you have selected to show via View > Toolbars?
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,554
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
It's not so simple that a preference setting can be adjusted for it. I looked for one. You could go into Excel Preferences>View and uncheck Row and Column Headers, then hit OK, go back in and recheck it. Do they change, or come back the same way?

By the way, this topic fits better in the OSX Applications Forum.
QUOTE Thanks
Terry1121

 
Member Since: Oct 02, 2008
Location: Erie, PA
Posts: 10
Terry1121 is on a distinguished road
Mac Specs: Mac OS X Leopard, 2.4GHz Intel Core 2 Duo iMac, 2GB 800MHz DDR2 SDRAM

Terry1121 is offline
to Hughvane: I have Standard, Formatting and Drawing.

to toMACsh: I know it's in the wrong forum but couldn't seem to change it via Edit. Not even cancel or delete the post and rewrite.

to ALL: I figured it out. When you zoom to 125% or 150% it seems that the headers get inordinately bigger than the font size default (in my case 12 pt). Especially at 150%. The font stays the same size (relatively speaking) when zoom in but the header numbers and letters actually get bigger.

Thanks for pondering with me about this. I am sane once again.

Terry
QUOTE Thanks
harryb2448

 
harryb2448's Avatar
 
Member Since: Nov 28, 2007
Location: Nambucca Heads Australia
Posts: 18,102
harryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond reputeharryb2448 has a reputation beyond repute
Mac Specs: iMac i5 2.7GHz, 16GB memory, OS 10.10.1

harryb2448 is offline
Make sure the Formatting Palette is up and open and change font sizes there.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,554
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
Quote:
Originally Posted by Terry1121 View Post
to toMACsh: I know it's in the wrong forum but couldn't seem to change it via Edit. Not even cancel or delete the post and rewrite.

to ALL: I figured it out. When you zoom to 125% or 150% it seems that the headers get inordinately bigger than the font size default (in my case 12 pt). Especially at 150%. The font stays the same size (relatively speaking) when zoom in but the header numbers and letters actually get bigger.
Mine don't. I just opened a file and zoomed to 200% and the box and text for the headers increased proportionately to each other.

No biggie on the forum location. Usually a moderator will move it. You can use the "report post" button (the ! in the little box at the lower left) to make that request.
QUOTE Thanks

Post Reply New Thread Subscribe


« MyBook World Editon 1TB - Can I use it for normal external harddrive use? | Monitor settings »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
The question game! Sydrocentric Schweb's Lounge 28 06-13-2009 05:21 AM
how to copy a row of excel to firefox chidambaram OS X - Apps and Games 0 06-04-2009 04:26 AM
Updating Excel document over a network? Garnon OS X - Apps and Games 3 05-26-2009 04:41 AM
Best setup for gaming & advanced excel chssvl Running Windows (or anything else) on your Mac 4 04-14-2009 04:58 PM
Mac Office 2004: Change in the graph when copied from Excel to Word aysun Running Windows (or anything else) on your Mac 0 04-02-2007 06:26 PM

All times are GMT -4. The time now is 11:06 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?