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.
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k
AVERAGEIFS function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.
This feature is particularly useful for summarizing data or improving the readability of complex sheets.
This tutorial introduces XLOOKUP, a new function in Excel for both vertical and horizontal lookups. Tasks that used to feel super complicated, like left-side lookups, finding the last match, or using VLOOKUP with multiple criteria, are now much easier with XLOOKUP.
Before, you had to choose between VLOOKUP for vertical lookups, HLOOKUP for horizontal ones, or more complex options like INDEX MATCH or Power Query. But now, you don’t have to pick anymore. XLOOKUP can handle all those tasks in one simple function.
Delta Symbol in Excel The Greek Capital Alphabet letter Delta (▲) and is commonly discussed topic in Excel. This is being used for various purposes i.e. changes in quantity, insert the symbol in excel etc….
The Article of DATEVALUE explains how to use Excel functions to change text into dates and numbers into dates. It also shows how to convert text strings into dates without using formulas. You’ll also learn…