Skip to main content

Formatting In Excel - helps you find meaning in the spreadsheet


 


Formatting In Excel -  helps you find meaning in the spreadsheet 


Spreadsheets are often seen as boring and pure tools of utility, but that doesn't mean that we can't bring some style and formatting to our spreadsheets

Formatting helps your user find meaning in the spreadsheet without going through each and every individual cell. Cells with formatting will draw the viewer's attention to the important cells.

In Excel, formatting worksheet data is easy. You can use several fast and simple ways to create professional-looking worksheets that display your data effectively. For example, you can use document themes for a uniform look throughout all of your Excel spreadsheets, styles to apply predefined formats, and other manual formatting features to highlight important data.

Formatting a Data

Raw Data

 


Using Font, Number tabs as shown in image to do a simple formatting

 



Formatting a Data with help of formatting tools in Excel 

As shown in image , we have Product category wise data with Taxable value, Cost, Profit and Profit Ratio.

There are no gridlines, headers, formula bar and ribbon, these can be hidden with formatting tools.

 



In Below Image you can see Formula tab, header and gridlines

 

 

In Below image there is none. Untick gridlines, headings and formula bar.




Below is a Report prepared using various formatting tools like chart and Smart Art.



 

As shown above we can convert a simple data into a nice and presentable form with the help of formatting tools available in Excel.

As shown in image below, with this style of formatting and presenting a data there is no need to rework the data and show it in PowerPoint.

 



Types of Formatting 

Press Ctrl +1 or 

1. Numeric

I. Date formatting 

 


II. Special Formatting – Change Security code number formatting and Phone number formatting.

 




III. Custom Formatting 

You can custom a formatting as required

 


2. Display

In Home Tab – Font feature 

Change font of the text , size, Colour

Fill colours in cell

Apply borders

Underline, Bold or Italic a character

 




3. Tools

Justify option allows the text copied from internet or word to be changed.

 




Background – Change background from Page layout option

 




4. Row & Column

Data with no Row or column formatting

 



After adjusting row and column

 





5. Outlining

Data Tab – Outline -- Subtotal

 



After Outline

 






Grouping

Data Tab – Outline -- Group

 



6. Visualization

Sparklines – Insert High, Low, first, last, negative markers.

 







WordArt


 



Shape Effects


 



Themes

Pagelayout – Colours or Themes

 



7. Conditional

Home – Conditional Formatting – there are various options for formatting as shown in image. 

 



Conditional Formatting with Formula



 


Labels:

Comments

Post a Comment

Popular posts from this blog

Why Every BI Professional Needs to Learn Agentic AI in 2026

Meta Description:  Agentic AI is transforming business intelligence. Learn why BI professionals must embrace autonomous AI agents to stay relevant — with practical examples, skills to build, and a BI Lead's honest perspective on the shift. Tags:   Agentic AI  ·  Business Intelligence  ·  Power BI  ·  AI Agents  ·  Data Analytics  ·  Future of BI  ·  Career Growth Let me be blunt: if you're a BI professional in 2025 and you haven't started paying attention to agentic AI, you're already behind. I'm not saying that to scare you. I'm saying it because I've spent over a decade building dashboards, tuning SQL queries, and wrangling Power BI data models — and nothing in my career has shifted the landscape as fast as agentic AI. Not self-service analytics. Not cloud migration. Not even the first wave of AI/ML. This is different. And here's why. What Exactly Is Agentic AI? Forget the chatbot hype for a second. Agentic AI refer...
Post a Comment
Read more

Quantum Computing

  Quantum computing is a new kind of computing that uses the laws of quantum physics to solve certain problems much faster than classical computers.  It doesn’t replace your laptop but can tackle very complex simulations, optimization, and cryptography‑style tasks that are intractable for ordinary machines.  *** ### What is quantum computing? Quantum computing is a computing paradigm that uses quantum‑mechanical phenomena—like superposition, entanglement, and interference—to represent and process information in new ways. Instead of classical bits (0 or 1), quantum computers use **qubits**, which can be in a mix of 0 and 1 at the same time, enabling parallel computation.  *** ### Classical bits vs. qubits - A **classical bit** is either 0 or 1; operations are deterministic and sequential.  - A **qubit** can be 0, 1, or any quantum “blend” of both, written as $$ \alpha|0\rangle + \beta|1\rangle $$, where $$ \alpha $$ and $$ \beta $$ are complex numbers capturing p...
Post a Comment
Read more

Rethinking Agentic AI

 # Rethinking AI Agents: Why Intelligence Beats Integration Every Time ## More Tools Won't Save a Thoughtless Agent Every week, another development team ships an AI agent loaded with integrations — web search, vector databases, code runners, calendar hooks, payment gateways. The demo looks impressive. The stakeholders nod. Then the agent hits its first real user in a messy, unpredictable situation, and the cracks appear fast. The uncomfortable truth? Most AI agents fail not because they lack access to information, but because nobody taught them how to *think* about it. The industry has quietly developed a bad habit: treating agent-building like a hardware upgrade. Slow processor? Add RAM. Agent underperforming? Add tools. This logic sounds reasonable until you realize that intelligence doesn't accumulate through connection counts. A library card doesn't make someone well-read. --- ## Competence Isn't a Plugin Here's a useful mental test. Imagine hiring someone for a...
Post a Comment
Read more