Skip to main content

6 Excel Print Formatting Techniques That You Need To Know


Like it or not, sometimes it's not the data or analysis you've done, but rather how you present it that sells. We've seen so much good work done not getting enough credit simply because poor formatting makes it look unprofessional when printed. Here are 6 MS Excel formatting techniques that you need to know when printing your spreadsheet.

1. Print Header Row On Every Sheet

Page Layout => Print Tiles => Rows to repeat at top


When you have a spreadsheet that stretches across many pages, you should have the header row repeat at the top of every page so that readers can follow your data without having to flip back to the first page every time. 


2. Portrait / Landscape Orientation

Page Layout => Orientation => Portrait / Landscape



Depending on the number of columns you have and how "wide" your rows are, it is essential that you switch between portrait and landscape orientation when you print your sheet. The rule of thumb, use landscape if you have many columns, portrait otherwise.

If you'd like to change the orientation of multiple sheets at once, select them by holding the ctrl button and clicking on the sheet tab at the bottom and then change the layout as shown above.

3. Fit Spreadsheet Onto A Single Piece of Paper

Page Layout => Orientation => Width / Height



Don't you just hate it when half your columns get printed on one sheet of paper and the rest on another? That makes your spreadsheet data so hard to follow. If you'd like to fit all your rows/columns to a sheet of paper, set the height/width to 1 page and Excel will re-size your font size automatically. Do note that this could lead to some tiny fonts if your rows are too wide or columns too long.

4. Adjust The Margins

Page Layout => Margins => Normal / Wide / Narrow


If you want to squeeze more data in without reducing the font size too much, try using narrow margins to reduce the white space on the sides. A custom 0.5" margin all around works well too.

5. Page Break Preview - Design Your Page

View => Page Break Preview


With Page Break Preview, you can see exactly what gets printed on each sheet of paper. In the example above, data till row 7 is printed on page 1 while the remaining data is printed on page 2. By dragging the blue line, you can include more or less data in the specific sheet.

6. Print Area - Decide What To Print

Page Layout => Print Area => Set Print Area


If you do not want to print all our data, you can select the data to be printed as shown above and then set the print area. Only the data you selected will be printed. 

And so there you have it, 6 formatting tips you need to know when you're printing your spreadsheet. We hope you've found them useful and do like or share with your friends and colleagues! For more Excel Tips, check out our guide on analysis and presentation add-ins as well as Excel shortcuts to save you time.
Labels:

Comments

Post a Comment

Popular posts from this blog

How to View YouTube Shorts in the Regular YouTube Player

YouTube's "Shorts" is YouTube’s answer to TikTok and Instagram reels but let’s be honest, the YouTube Shorts player lacks some functionality, such as the ability to fast forward and go back in the video. However, you might be surprised to know that every video that loads in the "Shorts" player is actually a regular video, and by changing the URL slightly, you can load the same video in the regular player along with all the functionality of a traditional YouTube video. Changing the URL Changing the URL is the easiest way to switch the player from a technical standpoint. It’s so easy even your grandma can do it, as long as she knows how to type an address into the address bar of a browser.   Let’s use this super popular short video about AI taking over ping pong as an example. Look in the URL bar of a video playing in the "Shorts" player, where you should see the text Shorts/. Replace that text with watch?v= and load the new URL. So in this...
Post a Comment
Read more

Create QR Codes in Excel With VBA

Need to automate the creation of QR Codes? Excel and VBA can help with that! Here's how to do it in less than 15 lines of code. What we're looking to do is have a URL in a cell and then we're going to use a function that we create in VBA call Google APIs to create the code. Here's a video that explains the whole process of creating a user defined function in VBA that will create QR Codes: Code to create QR Codes in Excel with VBA Open up your Visual Basic editor and insert the following code and then save. To call the function, type =GETQRCODES(Cell Address) where Cell Address is the address of the cell which contains a URL that you want to send your user to. Function GETQRCODES(QRCode As String)     Dim URL As String     URL = "https://chart.googleapis.com/chart?chs=100x100&&cht=qr&chl=" & QRCode     ActiveSheet.Pictures.Insert(URL).Select     With Selection.ShapeRange(1)         .Name = "QR_CODE_" & QRCode...
Post a Comment
Read more

How To Change Bluetooth Name On Android

This post will take you step-by-step through the process of changing the Bluetooth name of your devices on an Android phone. There are pictures as references in case you get lost along the way. Change Bluetooth Name On Android | Step-by-step 1. Unlock your Android phone and go to Settings Unlock your phone and click on the Settings Icon It goes without saying, but the first thing you need to do is unlock your phone. By default, the settings icon will be on your home page like in the picture above. If you don't have the settings icon, you can search for 'Settings' in the Android search bar. 2. In the Settings page, click on Bluetooth Click on the Bluetooth settings to open up the Bluetooth Settings menu Click on the Bluetooth settings which should be at the top of your Settings page. If it doesn't, scroll down till you find it or just search for it in the search bar at the top of the Settings page. 3. Click On Device Name To Change Your Phone's Bluetooth Name Click o...
Post a Comment
Read more