From the course: Excel: Creating a Basic Dashboard

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Hide gridlines and set zoom levels

Hide gridlines and set zoom levels - Microsoft Excel Tutorial

From the course: Excel: Creating a Basic Dashboard

Hide gridlines and set zoom levels

- [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 grid lines which mark boundaries between cells by default. If you want to change the amount of information displayed on a worksheet at a time or turn grid lines on or off, you can do so quickly. I will demonstrate using 0205 grid lines and this is an Excel workbook you can find in the chapter two folder of the exercise files collection. On my dashboard worksheet, I have the start of a dashboard that summarizes sales for two categories, bath products and gift basket. I'm at the standard zoom level which you can see at the bottom right hand corner. It's current only 100%. And if I want to change the zoom level then I can click the zoom in button at the bottom right and you can see the information on the screen is larger and easier to read. If I want to hide the…

Contents