netopk.blogg.se - Excel ribbon is greyed out sheet disappeared

Select the View tab at the top of the window.

While our guide above focuses specifically on changing the page layout view in Excel 2010, the same method still works for newer versions, like Excel 2016 or Excel for Office 365. How to Enable or Disable Page Layout View in Excel 2010Īs we indicate above, Excel is only going to show the ruler when you are in Page Layout view.Īs with any time you switch the view in Excel, you are able to do so from the View tab. If you have data that’s in the wrong unit, then our mm to inches formula can show you a simple way to fix that. Now that you know how to display the ruler in a Microsoft Excel spreadsheet you will be able to adjust this setting whenever you need to toggle the Excel ruler on or off.

When you see the Excel ruler greyed out that means that you aren’t able to click the Ruler check box to change its display setting. The box will remain checked in the Show section of the ribbon, but it is grayed out in every view except the Page Layout view. Additionally, note that if you select any of the other view options in the Workbook Views section, the ruler will disappear. You should now see a ruler at the top and left side of the window. Our guide below is going to show you how to change to the correct view and then enable the ruler so that you can see your spreadsheet with a ruler next to it. But that ruler is not visible in every view, so you need to make some additional changes to view the ruler in Excel 2010. Unfortunately, this can be difficult to do visually, so Excel has included a ruler that you can turn on and off to help you with accurate sizing. While we have previously written about ways to fit a spreadsheet on one page and how to repeat a row at the top of a page, you may be more concerned with appropriately sizing your cells to fit specific criteria. When you are adjusting the settings on a spreadsheet in Excel 2010, one of your biggest concerns may revolve around how to page looks when it is printed. This can be tough to visualize on the screen, which could leave you looking for a way to add an on-screen ruler.

While your primary concern when working with data in an Excel spreadsheet may be ensuring that the data is correct, you may also need to consider its physical size.