99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Replacing Cell Formats In An Entire Excel Workbook
Wed 24th August 2011
So it is at the firm of Waste-Knott & Wantnott, where a strict regime has been initiated to cut costs across the board. The manager called a meeting at which he asked the entire workforce to consider their actions a little more carefully. "Ask yourselves if what you are doing is really necessary," he said, "For example, do you really need to make that phone call? Would an email not do the job just as well? Does the light in the stationery cupboard need to be on when nobody is in there?"
He went on to say that making small savings each day would amount to a considerable saving over the course of a year. To remind everyone that an economy drive was under way, he had posters made that asked the question, IS THIS NECESSARY?
With this new cost-cutting attitude at the fore, one employee went to print off an Excel workbook. Just as he was about to click Print, he glimpsed one of the posters and this prompted a thought. The workbook he was about to print off was for reference purposes only and yet all of the column headers and totals were in bold type. Printing these as they were would be a waste of ink, so he set about changing all of the bold entries into regular type. The only trouble was, there were twenty seven worksheets in this workbook, so it would take some time to complete.
It would if he altered each worksheet individually, but Excel has the means to change the formatting of an entire workbook with just a few mouse clicks. The process is the same for all versions of Excel from 2003 onwards. Here is how the employee would have removed bold font from the entire workbook.
Open the workbook and press Ctrl + H to bring up the Find and Replace dialog box. Instead of typing in the Find What box, click on the Format button to the right of it. This will open up the Find Format dialog box. Select the Font tab and click on Bold in the Font Style list. Click OK.
Back in the Find and Replace box, click on the Format button to the right of the Replace With box, and this time select Regular from the list and click OK. You will be sent back to the Find and Replace dialog box. The last thing to do is click on the options for the Within box and select Workbook and then click Replace All. You have now instructed Excel to find all of the bold type within the workbook and replace it with regular type.
It is worth taking some time to explore the Find Format dialog box. Look under all of the tabs and you will see the vast array of formatting options at your disposal. Experiment with different fonts, or apply patterns or borders to an entire workbook.
And that is one of the great features of this application; when you learn how to perform one task, such as the one above, there are often many similar tasks that can be carried out using the same process. This makes the learning curve a lot less steep and it enables the student to build up a working knowledge of Excel fairly quickly. Those skilled in the use of Excel are always in demand, so why not embark on a journey to see just how versatile this application is.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Smurfit Kappa Townsend Hook
Implementing Reporting Services
Stephen has helped me to understand writing queries from scratch. Entering this course I had no understanding about the different commands and what they meant. Now I feel confident enough to try and write a query and report for our existing data.
AXA PPP Healthcare
PowerPoint Intermediate Advanced
I thought today's course was well structured and implemented so I can't fault it! I'm not sure that I would change anything about the course. Although there were certain aspects (i.e. animations/transitions as aforementioned) which were not relevant to my needs (purely due to the nature of my work), these sections were well presented and well explained, and therefore interesting nonetheless! Five stars from me!
National Physical Laboratory
Senior Research Scientist
Excel VBA Intermediate
This has been one of the most useful courses that I have attended, I wish I had gone on it years ago. Jens was a fantastic trainer and made the course interesting the whole way through. I have already recommended it to my colleagues.