While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and Formula Bar. This can give WOW experience to your bosses, clients because after hiding these features, you excel sheet looks like a software or an application. See below example:
Do you like this below Project Snapshot when compared with above? Scroll Down
Below are the features which we may hide to make our projects more appealing:x
Go To Menu Bar > Select View Tab as below
Uncheck the “Formula Bar”, “Gridlines” & “Headings”. See below to understand what would happen:
Sometimes Menu Ribbon occupies the space on your Monitor screen. So you may hide the Menu Ribbon, if it is not needed. See below:
If you have blank rows and Column which would not be used during the entire tenure of the project or you might have done some calculations in those columns. You may hide those by following below simple steps:
Select any column or columns and Right click on the header and Click “Hide”
Similarly you can select rows, right click and hide the rows. There is another method to hide rows and column which explained in below image:
These highlighted option can hide your rows or columns
By following the same process you may Unhide Rows/Columns as you can see in the above image, there is an option to Unhide Rows or Unhide Columns.
See below small gif image which may help you to understand the same:
Hope you like this article. Please share your views and comment below.
Want to learn how to unprotect Excel worksheet? Follow this simple guide to master this important skill in Excel. You can protect an Excel worksheet with or without a password. This helps keep your data…
Unhide Cells in Excel means you’ve probably hidden a row, column, or worksheet before to focus on important data. But what if you need to see those hidden parts again? Don’t worry—Excel makes it easy…
In this guide, you will learn how to use the NPV function in Excel to calculate the net present value of an investment and how to avoid common mistakes when using NPV in Excel.
Introduction Welcome to this comprehensive guide on using Power Query in Excel to split data efficiently. In this tutorial, we’ll walk you through the step-by-step process of splitting columns, specifically focusing on splitting the name…
MID function is used for extracting the mid characters from the available string. The output of the function returns the extracted characters in new cell.
Lock Cells to avoid editing, Hide Formulas Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and…