Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: excel question re formatting

17 Feb 2017   #1

windows 7 Home Premium
excel question re formatting

I have an Excel file with 10 pages. Over the years I have changed format (one page is TNR12, another is Arial 10, etc.) between pages. If I wanted to adopt the same format to all 10 pages, is there a way through the program of doing this automatically or do I have to change format one page at a time by hand? Thanks in advance.

I just realized this should have gone under Excel but I regret I don't know how to move it. Any assistance appreciated in advance.

My System SpecsSystem Spec
17 Feb 2017   #2
Mellon Head

Win 7 Pro x64/Win 10 Pro x64 dual boot


I just tried to select all sheets and change the fonts globally in an Excel file with no success. Unless there is a method that I'm not aware of, I think you'll have to do each page individually.

If you do find a way, please let me know. It's something that I would love to know how to do.
My System SpecsSystem Spec
14 Mar 2017   #3

Windows 10 x64

You can script it with a macro.
My System SpecsSystem Spec

14 Mar 2017   #4

Windows 7 Professional 64-bit

I was a Quattro Pro/DOS user some years back, would one be able to highlight the entire spreadsheet and then do the format choices? Or, was that tactic removed since the DOS [Fred Flintstone] days? Of course, have a backup of that excel file before trying any global-highlighting.
My System SpecsSystem Spec

 excel question re formatting

Thread Tools

Similar help and support threads
Thread Forum
Formatting in Excel 2010
Hello all, In Excel 2010 there are many formats for cells in Home > number group > drop-down list. And also by Format Cells dialog box. My question is, why we use those formats? Is there any benefit for it please?
Microsoft Office
Microsoft Excel 2010 - chart formatting question
Hello, I've just made a pretty decent scheme in my Excel. It's all good but I would like it to fill a whole A/4 sized piece of paper, by increasing the size of the cells as well as the text in them proportionally, so that I don't have any unused, blank cells. Is there a simple way to do this? ...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
After formatting my disk question
Hi all,I would like to ask,after formatting my disk partition (let say it is D),can i trace back any document that previously stored in it?thanks..
General Discussion
Formatting question!
I have XP installed on my 2'nd hard drive but I want to format that hard drive now. How do I do that in Windows 7? Under Disk Management the option to format is grayed out! Please help! Thanks!!
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 23:28.
Twitter Facebook Google+