Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to format rownumbers?

Ive one spreadsheet where the numbers of the rows and the characters of the
columns look like arial 20 while contence of spreadsheet is like arial 8. I
cant get rownummers and columncharacters to change according to
spreadsheetcontence.
Who knows what to do?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,104
Default How to format rownumbers?

Have you experimented with the Zoom tool (or View | Zoom) ?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"longbody51" wrote in message
...
Ive one spreadsheet where the numbers of the rows and the characters of
the
columns look like arial 20 while contence of spreadsheet is like arial 8.
I
cant get rownummers and columncharacters to change according to
spreadsheetcontence.
Who knows what to do?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to format rownumbers?

Yes Bernard but that wasn't the solution..
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,104
Default How to format rownumbers?

Sorry but I know of no way to format column/row headers; but I am open to
correction.
The Windows Properties can be used to change all menus etc but not that of a
single workbook
Have you looked to see if the workbook has macros in it?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"longbody51" wrote in message
...
Yes Bernard but that wasn't the solution..



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How to format rownumbers?

FormatStyleNormalModify

Change the Font to what you want. Your row num,bers and column chars will
change.

The worksheet cell fonts will also change but you can re-format them.

Styles are saved with the workbook so you can have varying Fonts for the
headers in each workbook.


Gord Dibben MS Excel MVP

On Thu, 25 Jun 2009 03:10:07 -0700, longbody51
wrote:

Ive one spreadsheet where the numbers of the rows and the characters of the
columns look like arial 20 while contence of spreadsheet is like arial 8. I
cant get rownummers and columncharacters to change according to
spreadsheetcontence.
Who knows what to do?




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,104
Default How to format rownumbers?

That's a new for for me. Thanks, Gord
Help and Google did not find an answer!
--
Bernard


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
FormatStyleNormalModify

Change the Font to what you want. Your row num,bers and column chars will
change.

The worksheet cell fonts will also change but you can re-format them.

Styles are saved with the workbook so you can have varying Fonts for the
headers in each workbook.


Gord Dibben MS Excel MVP

On Thu, 25 Jun 2009 03:10:07 -0700, longbody51
wrote:

Ive one spreadsheet where the numbers of the rows and the characters of
the
columns look like arial 20 while contence of spreadsheet is like arial 8.
I
cant get rownummers and columncharacters to change according to
spreadsheetcontence.
Who knows what to do?



  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How to format rownumbers?

We're always finding new tricks in these groups.

Glad to assist.


Gord

On Thu, 25 Jun 2009 14:00:06 -0300, "Bernard Liengme"
wrote:

That's a new for for me. Thanks, Gord
Help and Google did not find an answer!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Excel Worksheet Functions 2 May 9th 23 07:42 PM
Need help with converting CUSTOM format/TEXT format to DATE format Deo Cleto Excel Worksheet Functions 6 June 2nd 09 08:14 PM
Replace million-billion number format to lakhs-crores format Sumit Excel Discussion (Misc queries) 1 December 9th 05 05:58 PM
count rownumbers in loop TUNGANA KURMA RAJU Excel Discussion (Misc queries) 9 October 3rd 05 09:29 AM
how to format excel format to text format with separator "|" in s. azlan New Users to Excel 1 January 31st 05 01:57 PM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"