If you want to prevent users from wandering into parts of a worksheet you don’t want them to see, then hide such rows from their view. This technique is often used to conceal sensitive data or formulas, but you may also wish to hide unused or unimportant areas to keep your users focused on relevant information.
You could be thinking “Why can’t I hide rows in my sheet?”
Could be your Sheet is Protected, in such case hiding rows is not allowed. Was this reply helpful? Sorry this didn’t help. Thanks for your feedback.
Right-click the selected row headers and pick Unhide Rows. Note: When consecutive columns or rows are hidden, you can’t unhide specific columns or rows. First unhide all the columns or rows, and then hide the ones you don’t want displayed.
Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns. Click the minus sign, the selected rows or column are hidden immediately. And click the Plus sign, the hidden rows or columns are showing at once.
How to hide or unhide rows with plus or minus sign in Excel?
Select the entire rows or columns you need to hide or unhide with plus or minus sign, then click Group in the Outline group under Data tab. See screenshot: 2. Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns.
How to fix Microsoft Office not showing content on high DPI?
Now in the Properties window, switch to Compatibility tab and put a check mark against Disable display scaling on high DPI settings. Click Apply followed by OK. Now reopen the Office programs, and you will find that their content will not be blurry. There may be a possibility that you may find that the option is disabled or grayed out.
One article argued that right-click the icon of the Office program with blurry text and click Properties. Click the Compatibility tab and check Disable display scaling on high DPI settings.
Right-click on the icon of the Office program for which you’re facing the issue of poor scaling and select Properties. Now in the Properties window, switch to Compatibility tab and put a check mark against Disable display scaling on high DPI settings. Click Apply followed by OK.
Why does Windows 10 look blurry on my computer?
For information about updating Windows 10, see Update Windows 10. Sign out of Windows: If applications look blurry after connecting or disconnecting a monitor, docking or undocking your laptop, or changing your display scaling settings, signing out of Windows can fix this.