Zoom to make your spreadsheet fit your screen

Excel Tip #011

Zoom to make your spreadsheet fit your screen

Usually a new Excel sheet is available at Zoom % of 100. Sometimes for the look and feel of the workbook, we usually change the zoom %, I usually have my workbooks mostly at 90% zoom.

But to fit the data into the screen, we might have to decrease the zoom % further so that the entire data is viewed properly. Before going to our today's tip, let us first check out the ways we can zoom in (or) zoom out the Excel sheet.

Option 1 (Usual method):

People mostly follow either of these 2 usual methods. One way is going round the Excel ribbon tab and the other is using the Zoom option available at the right bottom corner of the sheet.

Using Zoom option via Excel ribbon

Using Zoom option at the right bottom corner of the Excel sheet

Option 2 (Keyboard Shortcut):

When we move over the Excel ribbon by pressing ALT keys, alphabets appear. The shortcut key is ALT + W + Q 

Shortcut key using Excel Ribbon
 A pop up window as shown in the below image will appear, where you can resize the Zoom %
Pop up window for resizing the Zoom %

Option 3 (Mouse Shortcut):

Press the CTRL key and move up (or) down the scroll wheel in the mouse, Moving up will increase the Zoom % and moving down will decrease the Zoom %. By default this increase (or) decrease will move by 15% (i,e.) 85%, 100%, 115% etc

Fitting your screen:

Consider the below sales data of 15 products in 2016 for all the months. Here, Excel default Zoom % of 100 is set. If you see, the entire data is not fitted into the screen.

When the data is slightly wider than will display on the screen I've seen people try using smaller font sizes, make columns narrower, or abbreviate data in some columns just to make it fit. There is a much easier way.

Data not fitting the screen
Below is the method to fit the range of cells to the screen size.
  1. Select a range of cells from the left-most cell (usually column A) to the right-most cell in your sheet. It doesn't matter how many rows, one or two will do
  2. Using option 1 & option 2 as mentioned above, you will see a pop up window. Click Zoom to Selection. Excel will automatically adjust the zoom percentage so that the cells you have selected will fit into the visible area of your screen
Fit Selection option in Zoom pop up window
Data Fitted in the screen

We can also achieve this in another method where we have an option Zoom to Selection in the View ribbon tab which does the same.
Zoom to Selection option in View tab
Shortcuts for the sheet to fit the screen:
  1. ALT + W + Q + F + Enter
  2. ALT + W + G

Comments

Post a Comment

Popular posts from this blog

VLOOKUP - Exact Match & Approximate Match

Image
Excel Tip #013 VLOOKUP - Exact Match & Approximate Match In the previous tip #012 (VLOOKUP & INDEX + MATCH), we learnt about VLOOKUP, it's syntax and how to use it. We also learnt about its drawback and how INDEX & MATCH can be helpful. Like said in the previous tip, there are 2 match option available in VLOOKUP - Exact & Approximate Match . Let us first refresh the syntax of VLOOKUP. Syntax: = VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) In simple terms, =  VLOOKUP (value/data that is used as reference, data table, the column # where our resultant data resides, exact (or) approximate match) Let's have a closer look at the last argument you supply to the Excel VLOOKUP function - range_lookup. You are likely to get different results in the same formula depending on whether you enter TRUE or FALSE (Approximate or Exact). If range_lookup is set to FALSE , the formula searches for exact match, i.e. for the lookup value exac
Read more

Row 1 Is Missing. How to unhide?

Image
Excel Tip #030 Row 1 Is Missing. How to unhide? As you know, hiding and unhiding rows in Excel is simple as selecting them, right-clicking and choosing Hide or Unhide . The trick to selecting hidden rows, is to select a row above or below and then drag to included the hidden rows. For example, if you accidentally hide row 1 of your worksheet or inherit someone else's worksheet with one or more of the top rows hidden, you may be wondering how to unhide them since apparently you cannot select them. Row 1 Hidden There is a really easy solution. 1) Point to the row 2 header , press the left mouse button and drag upward to the top of the worksheet. Although you cannot see it, row 2 and row 1 are now selected 2) Right click anywhere on row 2 3) Choose Unhide from the right-click menu Unhiding hidden Row 1 NOTE : This also works for multiple hidden rows. There is another method of doing the same if Row 1 is hidden. 1) Go to the top left corner of the sheet abov
Read more

Search Backwards in Excel

Excel Tip #022 Search Backwards in Excel Sometimes we take some things for granted in Excel and assume that everyone else knows too. Here's a tip which lot of Excel users don't know about it. Many Excel users know that the quickest way to find something in a large worksheet is to use Excel's Find command. On the Home tab, in the Editing group, click Find & Select , then Find or, preferrably, use the keyboard shortcut CTRL+F instead. Each time you click Find Next you will be taken to the next matching cell, starting from the active cell and going down the sheet until you finally come to the last one. But what if you want to find the 'last' matching value in a sheet and there are dozens or even hundreds of matching values? You don't want to click through each one until you finally reach the end. Here's a simple trick that will save you some time. Select a cell below the range you want to search ( CTRL+END is a shortcut you can use to quick
Read more