Solved

excel format all sheets in a workbook

Posted on 2011-03-06
2
245 Views
Last Modified: 2012-05-11
I have a workbook and would like to format all the worksheets apart from worksheet "A".

So, for all other worksheets, column B should be a percentage number with 2 decimal points, and columns C:K should be a number with no decimal points.

Can you help please?
Thanks,
Chris
0
Comment
Question by:CC10
2 Comments
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 250 total points
Comment Utility
You may select the worksheets that you want to include the formatting by holding the Shift key. Then, do format the columns only one of the selected sheets. The formatting will effect into other worksheets.

Ed
0
 

Author Closing Comment

by:CC10
Comment Utility
Thanks. Actually I wanted a macro but this works fine.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now