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
tonyvella

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
 
 

Tony,

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
margrave

Windows 10 x64
 
 

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

14 Mar 2017   #4
RolandJS

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
Reply

 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
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 18:28.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App