If you want to change the amount of information displayed on a worksheet at a time or turn gridlines on or off, you can do so quickly.
- [Instructor] When you create a worksheet in Excel,…it comes with a standard zoom level,…which refers to the general size of objects on the screen.…Excel also shows gridlines, which are marked boundaries…between cells by default.…If you want to change the amount of information…displayed on a worksheet at a time,…or turn gridlines on or off,…you can do so quickly.…You can also if you want hide all or part of the ribbon…to give yourself even more screen real estate.…I'll demonstrate these techniques in this movie.…My sample file is the GridlinesAndZoom Excel workbook,…which you can find in the Chapter Two folder…of your Exercise Files collection.…
I am on the Dashboard worksheet…of the workbook, and you can see that what I have…on the screen doesn't take up all the room…that's available, so what I could do…is to resize the pivot chart here…showing the different departments…and what their quarterly expenses are,…or I can zoom in.…If I want to zoom in, that is to increase…the magnification of the images on the worksheet,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Managing data using Excel tables
- Managing PivotTables and PivotCharts
- Summarizing table and PivotTable data
- Defining conditional formats
- Creating sparklines
- Sketching your dashboard layout
- Creating and managing cell links
- Linking cell contents to a shape
- Linking to a PivotTable cell
- Extending your dashboard using hidden rows