Trick to make Excel Data fit to display

How to Make Your Spreadsheet Fit to the display, Fit Excel Spreadsheet to Screen. An easy trick to make your Excel data fit display / screen.

Many times You put a lot of preparation into designing your spreadsheets the way exactly you want Excel spreadsheets, but you find that your Excel spreadsheet is little wider to fit your display or screen. Now you want to view or find out where the last column or two are just off the right side of your screen or computer display. Maybe you have many spreadsheets like this so Here is the quick and easy solutions to resolve it or lets say to view your entire data within the spreadsheet in a single display/Screen or Make spreadsheet fit to your screen.

If you want to scroll up or down your data is not a big problem, anyone can use mouse scroller to do that but suppose your data is little wider in left or right side, then you can't simply scroll with mouse. So the problem here is that not only do you have to scroll up and down to navigate your spreadsheet but you also have to scroll left and right.
 

Zoom to Selection

Generally people use smaller font size, make columns narrower (Reduce the size/width of columns), or abbreviate data (just to make it all fit within the screen) to display data on the screen when the data is slightly wider than display. So, here below is a quick or simple method to zoom to fit selection / selected data.

Zoom to fit selection / Selected data within excel spreadsheet. 

There is a much easier way / method to make your data fit the width of your screen. 

1) At first, Select a range of cells from the left-most cell to the right-most cell,
 

Zoom To Selection 1

2) Now click the View tab and click the Zoom To Selection command. Excel will change the zoom percentage to fit the selected cells on your screen.

Zoom To Selection 2

Keyboard Shortcut key to Zoom to Selection in MS Excel - ALT+W+G.
 

You can see the zoom percentage for the active workbook in the Zoom Controls on the right side of the Status Bar.

Another method to Zoom to Selection is to click on the percentage value on the Zoom Controls and select Fit Selection from the Zoom dialog and click OK.
 

Zoom To Selection 3

You can use Zoom Controls to squeeze your spreadsheet to fit your screen.