how to freeze first two rows in excel 2017

That might not matter for your particular use case, but in case it does, we’ll cover a second method that allows you to center the work area by turning off the gridlines. For instance, if you hide all unused rows and columns, the work area will end up in the top-left corner of the sheet rather than the middle. However, hiding parts of the worksheet comes with one inherent behavior that’s difficult to work around: Hiding rows and columns displaces the work area.

Whether you’re protecting data or removing distractions, hiding white space and other areas of the worksheet can help. SEE: 30 Excel tips you need to know (TechRepublic Premium) When you’re trying to make your Excel worksheet function like a dashboard, you won’t want to see many of Excel’s traditional sheet elements.

Viewers, or end consumers, might click around to focus on something in the sheet or to filter a report or graph like they would in a dashboard, but they won’t be able to make changes to the underlying data. The reason? Hiding everything but the working area is a good way to obscure data and formulas you don’t want users to see or try to change.Īnother good reason to hide unused areas is to make your worksheet function similarly to dashboards, which are growing in popular use. You usually hide a column or row to conceal or protect data and formulas, so you might be wondering why anyone would want to hide everything else.

Moving toward Excel’s protection feature.Hiding the header rows and formula bar in Excel.You can download the Microsoft Excel demo file for this tutorial. Excel’s online version lets you turn off gridlines and the heading rows. I’m using Microsoft 365 Desktop on a Windows 10 64-bit system, but you can also use older versions. This process is easy to implement and takes very little time. In this tutorial, I’ll show you how to inhibit several worksheet properties and options so user focus stays on the working area. SEE: The Complete Microsoft Office Master Class Bundle (TechRepublic Academy) When it looks like everything is missing, it’s often because the owner of the document has disabled properties and options to protect the working area. If you’ve ever opened a Microsoft Excel workbook to find no columns, rows and/or scrollbars, this is probably why: The workbook’s author hid some portion of the Excel worksheet from view so users can focus on the working area without distractions.

How to freeze first two rows in excel 2017