18 Tips to Make you an Excel Formatting Pro
We can take any Excel workbook and format it until Christmas, and we would still not be done. But not many of us have so much of time or energy. So, today, lets talk formatting.
In this, you will learn how to
1) Use tables to format data quickly
2) Change colors of your worksheet in a snap
3) Use cell styles
4) Quickly clone formatting using format painter
5) Clear formats to begin with a clean-slate
6) Formatting shortcuts
7) Formatting options for print
and 8 ) Why you should not go overboard formatting and 10 other tips.
So go ahead and become a formatting pro.
Excel Tables Tutorial & 13 Tips for making you a Data Guru
Excel table is a series of rows and columns with related data that is managed independently. Excel tables, (known as lists in excel 2003) is a very powerful and supercool feature that you must learn if your work involves handling tables of data.
What is an excel table?
Table is your way of telling excel, “look, all this data from A1 to E25 is related. The row 1 has table headers. Right now we just have 24 rows of data. But I can add more later!”
Save time & paper with print areas in Excel
Here is a very simple but effective tip: use print areas. Oh.. but what is a print area? Imagine looking at a report or dashboard worksheet. Now, that sheet also has few calculations, some extra stuff to the right of the report. When you print, you don’t need those extra elements. Just the report will do. This […]
CP025: Sexy on spreadsheet, Ugly on Printout
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 25th session of Chandoo.org podcast, let’s learn how to avoid SSUP syndrome.
What is in this session?
Most of us suffer from Sexy on the Spreadsheet, Ugly on Printout syndrome. I used to suffer from it too. This happens because we spend all our attention creating that perfect workbook, report or model. And then, we forget about making the proper print settings.
In this podcast, let’s understand how to create awesome workbooks that look great and print great.
In this podcast, you will learn,
- Frozen & Cars, where my free time goes
- Primer on print settings
- Width & height of printouts
- Page breaks
- Row & column repetitions on every page
- Size & orientation of paper
- Dealing with unprintables
- Proofing your print settings
- Printing whats not on screen
- Closing thoughts
Quick Update about VBA Classes & Discount Expiry!
I have 2 quick announcements & 1 Excel tip for you.
Announcements
- Registrations for next batch of VBA Class start form January 11th (Wednesday). Please click here to download the course brochure.
- 20% Holiday discount on Excel School expires tonight (Midnight, Pacific Time). Please visit Excel School page and use the code LETSGOEXCEL to claim your discount.
Read on for a bonus Excel tip as well.
Hui’s Excel Report Printer
Do you enjoy printing complex spreadsheets with multiple pages with different print ranges and different setups on each page for different people who have different requirements ?
If the answer is No…
This post may save your day and change your life.
Get Rid of Page Break Lines with a snap [macros]
Have you ever jumped back to normal view from print preview and noticed the annoying page break lines? They look distracting. They are like a naughty kid shouting for attention. look at me!!! How do we get rid of those lines after completing our business with print preview?!? Very simple. We just copy everything, press […]