All articles with 'printing' Tag

Save time & paper with print areas in Excel

Published on Aug 23, 2015 in Excel Howtos

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 […]

Continue »

CP025: Sexy on spreadsheet, Ugly on Printout

Published on Nov 6, 2014 in Chandoo.org Podcast Sessions
CP025: Sexy on spreadsheet, Ugly on Printout

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
Continue »

Quick Update about VBA Classes & Discount Expiry!

Published on Jan 5, 2012 in Excel Howtos, Learn Excel

I have 2 quick announcements & 1 Excel tip for you.

Announcements

Read on for a bonus Excel tip as well.

Continue »

8 Tips to Make you a Formatting Pro

Published on Dec 5, 2011 in Excel Howtos, Learn Excel
8 Tips to Make you a 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

So go ahead and become a formatting pro.

Continue »

Hui’s Excel Report Printer

Published on Sep 14, 2011 in Excel Howtos, Huis, Posts by Hui, VBA Macros
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.

Continue »

Get Rid of Page Break Lines with a snap [macros]

Published on Feb 28, 2011 in VBA Macros
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 […]

Continue »

Hiding Error Messages – Quick Tip

Published on Oct 28, 2010 in Excel Howtos
Hiding Error Messages – Quick Tip

I like to leave certain error messages in place because they can show you what your data is doing, but they look horrible when you print out reports. This will show you an alternative method for dealing with error messages.

Continue »

Print Worksheets in One Page Across [Quick Tips]

Published on Dec 22, 2009 in Excel Howtos
Print Worksheets in One Page Across [Quick Tips]

Have you ever wondered how to print excel sheets in one page across? so that when you print a large excel spreadsheet the output can be read one page after another. We can use the print settings in Excel to do this very easily. In this episode of quick tips we will learn how to do this with in 5 seconds.

Continue »

How to Print Excel Comments

Published on Dec 16, 2009 in Excel Howtos, Learn Excel
How to Print Excel Comments

We all know how to make comments on excel documents, just select the cell where you want a comment, press SHIFT+F2 and make the comment. But the comments are only visible when you open the workbook. What if you want to print out an excel file, but include all the comments as well?

Turns out you can do that with a hidden option in excel page setup.

Continue »

10 Supercool UI Improvements in Excel 2010

Published on Nov 20, 2009 in Learn Excel
10 Supercool UI Improvements in Excel 2010

Today I want to introduce Excel 2010 to you. Excel 2010 is the latest version of spreadsheet software from Microsoft, set to be released for sale in late 2010. On Nov 18th, MS released the public beta of Excel 2010 [download here] along with other Office productivity software.

Excel 2010 has several improvements compared to earlier version – Excel 2007. In this post, I want to highlight some of the User Interface improvements made in Excel 2010 that are very exciting and fun to use.

Continue »

Want to become a Data God? Learn Excel Data Tables

Published on Sep 10, 2009 in Excel Howtos, Featured, Learn Excel
Want to become a Data God? Learn Excel Data Tables

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!”

Continue »

Converting Excel to PDF – Everything you need to know

Published on Jun 4, 2009 in Excel Howtos, Featured
Converting Excel to PDF – Everything you need to know

Ok, so you have that neat little excel report ready and now you want to share it with your boss or client in a PDF format. So how would you do that? Your best option is …

Continue »

Hide Formula Errors While Printing [Quick tip]

Published on May 27, 2009 in Excel Howtos, Learn Excel
Hide Formula Errors While Printing [Quick tip]

Here is a quick excel printing tip. Use the page setup options from print preview area of the spreadsheet to select how you want to handle the formula errors when the worksheet is printed. You can set it to blank from the “sheet” tab of the page setup dialog in Microsoft excel

Continue »

Excel Links of the Week – Minor Changes to PHD edition

Published on Jan 26, 2009 in blogging, excel links
Excel Links of the Week – Minor Changes to PHD edition

There are some minor changes to PHD sidebar layout and feed address. Also, in this week’s featured links learn how to Understand Stock Charts in Excel, Choose the Right Chart Using this Flow Chart, Quickly Create Named Ranges using F4 Key, Print Multiple Areas by Creating a Consolidation Sheet and Get a List of Filenames in a Directory to Excel using Browser

Continue »

Excel Links of the Week [Jan 12]

Published on Jan 12, 2009 in excel links

Everyweek PHD shares some of the Excel links to help you learn better and become productive at using Excel. This weeks edition will help you with printing, creating named ranges, finding excel version.

Continue »