Scale your Excel spreadsheet to fit your screen
If you work with large Excel spreadsheets, you'll probably know the hassle of scrolling left and right, up and down as you try to work with all that data. You can use the Zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn't always give you the result you want. Often, it will make your spreadsheet too small or not small enough.
To fit your spreadsheet exactly to the screen - let's say you want to reduce the width of it so you can see all the columns fitting snugly into the width of your screen, with no screen space wasted, simply follow these steps:
- Select one row of cells from the spreadsheet range you want to see (e.g. from A4 to H4.
- Choose View, Zoom, then select Fit Selection
- Click OK
This will make the cells you selected fit exactly into the width of your screen. It doesn't matter that you only selected cells from one row (or column if doing it the other way) - Excel will scale according to the longest dimension (in this example the dimension was width rather than height).
Note that this tip also works to make a spreadsheet larger to fit the screen as well.
About Us
Fiveminutelessons.com is a website dedicated to providing free training on a range of subjects. We're starting with lessons on Microsoft Word, Excel and PowerPoint but have plans to add other subjects over time such as Adobe Photoshop and Microsoft Project as well as non-software subjects.
We're based in Tauranga, New Zealand but have years of experience in the UK, USA and Ireland working in the training industry with a range of clients from small businesses to blue chip corporates.
Commercial Services
As well as the free training you get at www.fiveminutelessons.com, we also offer a range of commercial services to help you with your training and online learning requirements including:
- Private labelling
- Courseware development
- e-learning development
- Corporate subscriptions
- Learning consultancy services
- Documentation and user guide development
- Development of innovative corporate learning environments
We offer these services for Microsoft Word, Excel and PowerPoint, as well as a range of other popular software applications. We can also assist with documentation and courseware development for custom or in-house software packages.
Contact us now to find out more about our learning consultancy and courseware development services