How to Fit Your Excel Spreadsheet to Your Screen - MakeUseOf [PDF]

Dec 4, 2015 - excel-fitting3. In the Page Setup menu, under the Page tab, you'll see that under Scaling, the option to A

5 downloads 32 Views 2MB Size

Recommend Stories


How Fit Are Your Finances?
Live as if you were to die tomorrow. Learn as if you were to live forever. Mahatma Gandhi

HOW TO INSURE YOUR CAR PDF
Ask yourself: What is one thing I could start doing today to improve the quality of my life? Next

How to Adapt Your Garden Shelter to Your Pets
Your big opportunity may be right where you are now. Napoleon Hill

How to wash your car
No amount of guilt can solve the past, and no amount of anxiety can change the future. Anonymous

How to present your thesis
Don’t grieve. Anything you lose comes round in another form. Rumi

how to synchronise your contacts
Your big opportunity may be right where you are now. Napoleon Hill

How to Invest Your Money
Ask yourself: Am I achieving the goals that I’ve set for myself? Next

How to motivate your team
You can never cross the ocean unless you have the courage to lose sight of the shore. Andrè Gide

How to Appeal Your Conviction
Ask yourself: What are some childhood dreams or interests you were never able to fully explore but still

How to insulate your attic
Pretending to not be afraid is as good as actually not being afraid. David Letterman

Idea Transcript


PC & MOB IL E

L IFE ST YL E

HARDWARE

DE AL S

GIVE AWAYS

P RODUCTIVITY

How to Fit Your Excel Spreadsheet to Your Screen By Ryan Dube / December 4, 2015 04-12-2015 / 5 minutes

Ryan Dube 956 articles Ryan Dube is MUO's Managing Editor. Ryan Facebook

Twitter

Pinterest

Stumbleupon

has a BSc degree in Electrical Engineering.

Email

He's worked 13 years in automation engineering, 5 years in IT, and now is an

Advertisement

Get Paid $90 Per Survey?

Apps Engineer. He's spoken at national conferences on Data Visualization and was been featured on national TV and radio.

Excel is a powerful tool for so many things, but having to resize the sheet to fit your screen every time you open a file can be a major pain. Here are three quick solutions that can make your spreadsheet much easier to view. Here at MakeUseOf, we’ve shown you how to use Excel for things like doing your taxes, general data analysis, or even just managing your life.

Doing Your Taxes? 5 Excel Formulas You Must Know It's two days before your taxes are due and you don't want to pay another late filing fee. This is the time to leverage the power of Excel to get everything in order. R EA D MOR E

Regardless what you’re using Excel for, wouldn’t it be nice to be able to have your spreadsheet open up automatically so that you can see all the data on your screen? Wouldn’t it be sweet if your printouts contained every column resized so that it could fit on one sheet? Using one of the three steps below, you can accomplish this.

1. Fit All Columns to Screen When you’ve opened a spreadsheet with more than a dozen columns or so, or maybe with very large text columns, it doesn’t take long for the end of the sheet to run off the right side of your screen.

Latest Giveaways!

Mindkoo Unicat Cat Ear Headphones: Cute, and They Light Up (Review and Giveaway)



Azulle Byte 3 Review: This Tiny, Fanless Mini PC Does Everything



Populele Review: Learn to Play the Ukulele in 15 Minutes

People often put up with this because they think there’s no other way. The truth is that Excel is one of the best spreadsheet applications for this — reconfiguring your sheet display so that all columns fit on the screen is actually pretty simple.

Excel vs. Google Sheets: Which One Is Better for You? Do you really need Excel? Both desktop and online solutions have their advantages. If you have trouble choosing between Excel and Google Sheets for managing your spreadsheets, let us help you decide.

Trending

R EA D MOR E



WI N D OWS , PR OGR A MMI N G



BU Y I N G GU I D ES , PR OGR A MMI N G

The Best Command Prompt Tricks and Tips

Geek Gifts for Programmers: 15 Presents for Techies and Nerds… Step 1 – Highlight the entire first row of your spreadsheet across all columns.

Step 2 – Click on the View tab, and then select Zoom to Selection.

I N TER N ET

5 of Google’s Best New Apps and Updates You Need…

Related Articles

PR OD U C TI V I TY



PR OD U C TI V I TY



PR OD U C TI V I TY

How to Hide and Unhide Worksheets in Excel

How to Calculate Basic Statistics in Excel: A Beginner’s Guide

How to Make a Calendar Template in Excel

That’s all it takes for all columns to fit onto your screen. No more cut off columns at the right side of your spreadsheet!

Shop Related Products

Use LibreOffice Calc: A Beginners Guide

USMLE Step 1 Lecture Notes 2017: 7-Book Set (Kaplan …

$15.99

$198.66 $329.99

(3)

(206)

Problem solved, right? Well, not quite. While this first solution works, it isn’t a permanent solution unless you’re willing to go through those two steps every single time you open your spreadsheet. What about when you open the spreadsheet on a different screen with a different resolution?

First Aid for the USMLE Step 1 2018, 28th Edition

Microsoft Excel Data Analysis and Business Modeling (5t…

The answer is to automate the resizing one time, so you never have to think about it again.

$53.08 $55.00

$32.00 $49.99

(2)

2. Using VBA to Fit to Screen

Ads by Amazon

Affiliate Disclosure: By buying the products we recommend, you help keep the lights on at MakeUseOf. Read more.

What better way to automate anything in Excel than VBA?

How to See All Your PC Information Using a Simple Excel VBA Script Excel and 10 minutes of work will give you more detailed information about your computer than you ever thought possible. Sounds too good to be true? That's Windows, if you know how to use it. R EA D MOR E

With a Visual Basic script, you can add some code to the Worksheet.Open method to automatically resize the sheet to fix the screen. To make this easy, first select the entire first row of the sheet (including all columns you want to fit onto the screen). Right click anywhere in the highlighted row, and choose Define Name…

In Office 2016, if “Define Name…” is not an option in your right-click menu, highlight the first row with all columns you would like to auto-fit to the screen, then ask Tell Me for Name a Range and select the respective result. You’ll find that “Workbook” is the Scope selected, and the sheet name and range is already filled into the Refers to: field. Just type in a name for the range that you’ll remember, into the Name: field.

In this next step, you’ll need to click on the Developer menu item, and choose View Code from the Developer menu. If you don’t see the Developer option in your menu, you’ll need to enable it by going to File > Options > Customize Ribbon. Make sure Developer is selected here.

Once you click View Code in the menu, make sure to double-click the ThisWorkbook object, and on the right pane choose Open from the list of methods on the right drop-down menu.

Then, paste in the code shown above into the function Workbook_Open(). For your convenience, select and copy the text below into your function. Range("DefinedRange").Select ActiveWindow.Zoom = True 'Cells(1, 1).Select The last line is optional. Basically, if you include it, the sheet will move back to the left side so that the first cell is selected and the view is centered toward the top, left side of your sheet. When you save your workbook, you will have to select a macro-enabled file type, i.e. XLSM. Now, every time you open your Excel file, it’ll automatically resize the sheet so that every single column fits inside the computer screen you’re using, regardless of its resolution.

3. Fitting All Columns When Printing Another problem people face when actually printing out their spreadsheets, even though all columns fit onto the display, is having all columns fit onto the printed paper sheet. This is a real annoyance, but the fix is fast and easy. Dann recently showed you a whole list of ways you can fix this issue, but personally I prefer the fast and simple rescaling approach.

How to Print an Excel Spreadsheet on One Single Page A beautifully crafted spreadsheet loses all its appeal when it comes printed on nine sheets of paper, with half of them empty. We show you how to get everything nicely on one single page. R EA D MOR E

When you choose Print from the File menu, you’ll see in the print preview that not all of the columns are on the preview.

Scroll down to the bottom of the print menu, and click on the Page Setup… link.

In the Page Setup menu, under the Page tab, you’ll see that under Scaling, the option to Adjust to 100% normal size is selected by default. This will make the sheet print at it’s original size, whether or not the whole sheet will fit. It’ll just print the rest of the worksheet on multiple pieces of paper, which is completely useless. Instead, select Fit to: and then change the tall setting to a ridiculously high number that’s much higher than the number of papers your spreadsheet will actually need for printing.

This ensures that the sheet will only be “squeezed” to fit all columns on the sheet, but won’t resize the rows of the sheet. This is because if the rows are resized, it’ll mess up the final formatting. By only forcing all columns to fit, your spreadsheet will print to one sheet wide, and as many pages as needed to print all of the data.

Excel Fits Right In In the end, reformatting your spreadsheet, no matter how massive it is, to fit everything on one PC display, or on one printed sheet, really isn’t that complicated. You just have to know the right trick to use to accomplish it!

Visualize Your Data & Make Your Spreadsheets User Friendly With An Excel Dashboard Sometimes, a simple spreadsheet format isn't engaging enough to make your data accessible. A dashboard allows you to present your most important data in an easy-todigest format. R EA D MOR E

We’ve showed you a lot of useful tricks with Excel through the years, but now you know all three tricks for getting your data to look and print exactly the way you want it to. Don’t forget to share these tricks with all of your friends and family! Do you know any other ways to quickly fit a spreadsheet onto a computer screen of any resolution? Share your own tips and tricks in the comments section below! Image Credit: holding a huge mallet by Pretty Vectors via Shutterstock

2 C O MMEN TS

© 2017 MakeUseOf. All Rights Reserved.

(29)

WRITE A COMMENT

Smile Life

When life gives you a hundred reasons to cry, show life that you have a thousand reasons to smile

Get in touch

© Copyright 2015 - 2024 PDFFOX.COM - All rights reserved.