New Posts
Home / Computer 4 Beginners / Formatting Excel spreadsheet.

Formatting Excel spreadsheet.

Formatting Excel spreadsheet.

We will learn about formatting Excel spreadsheet. Where I have discussed following topics. Formatting Excel spreadsheet means to give a nice and beautiful look to the spreadsheet. There are many options regarding Formatting Excel spreadsheet which we explore in this article.

Formatting-Excel-spreadsheet

  • Exploring font styles and effects.
  • Adjusting row heights and column widths.
  • Working with alignment and Wrap Text.
  • Designing borders.
  • Exploring numeric and special formatting.
  • Formatting numbers and dates.
  • Using conditional formatting.
  • Creating and using tables.
  • Inserting shapes, arrows, and other visual features.

Exploring font styles and effects is a way where we Adjust Row heights and column widths, Working with alignment and Wrap Text, Designing borders, Exploring numeric and special formatting, formatting numbers and dates, Using conditional formatting. Creating and using tables, Inserting shapes, arrows, and other visual features, Exploring font styles and effects.

Exploring font styles and effects.

Exploring font styles and effects

  1. Select text.
  2. Apply any option from formatting toolbar.

Note: The options which are available on Formatting toolbar, these options can also be used from Home Tab.

 formatting toolbar

Adjusting row heights and column width.

You can easily adjust the width of column and height of the row.

Height & Width.

Height & Width.

Home Tab.

Click on the format.

 format options

Working with alignment and Wrap Text.

Following options are available on the home tab.

Working with alignment and Wrap Text

 Working with alignment and Wrap Text 2

 force lin break

 wrap text

wrapt text example

 

 

merge and center

Orientation.

Rotate your text diagonally or vertically. This is a great way to label narrow columns.

 Orientation

Designing borders.

Apply borders to the currently selected cells.

 Designing borders

desiging border format cells

Exploring numeric and special formatting.

Exploring numeric and special formatting

Select more than one cell and right click.

Format Cells.

or.

 Format cells

Format cells special

Number.

 format cells Number

Currency.

format cells currency

Formatting numbers and dates.

Ctrl+; form Date

Ctrl+shift+; for Time

=now() Data & Time

Formatting numbers and dates

Right click.

Format Cells.

format cells date

 format cells 2

M

mm mmm mmmm d dd ddd dddd y yy yyy yyyy

mmm mmmm d dd ddd dddd y yy yyy yyyy

mmmm d dd ddd dddd y yy yyy yyyy

d dd ddd dddd y yy yyy yyyy

dd ddd dddd y yy yyy yyyy

ddd dddd y yy yyy yyyy

dddd y yy yyy yyyy

y yy yyy yyyy

yy yyy yyyy

yyy yyyy

yyyy

 format date shortcut

 

 

 format cells time shortcut

formt cells time

Using conditional formatting.

Home tab.

 Using conditional formatting

 Using conditional formatting 2

Using conditional formatting 3

Fill.

Using conditional formatting fill

Using conditional formatting 5

 

 

 

 

 

 

 

 

Manage Rules.

 Using conditional formatting editng rule

 Using conditional formatting 6

Creating and using tables.

Organize the date format, sort, filter within the sheet.

Or Insert.

Table.

Ctrl+a select all data.

Creating and using tables 1

 Creating and using tables 2

 move active cell

Going to corner to data.

Insert.

Table.

Then Design tab will be displayed.

Design.

table options

Table Design.

Design formats.

 table style

 

 

 

 table sytle

Slicer.

 Slicer

Use a slicer to filter data visually.

 Use a slicer to filter data visually.

Use a slicer to filter data visually. 2

Inserting shapes, arrows, and other visual features.

Insert.

Shapes.

 Inserting shapes, arrows, and other visual features

Inserting shapes, arrows, and other visual features 3

shape example 2

Insert Picture.

 Picture.

picture example

Online Picture.

online picture

insert picture

 insert picture options

Smart art.

 Smart art

 Smart art 2

 Smart art 3

 

 

 

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Microsoft Excel Data Analysis Tools

Microsoft Excel Data Analysis Tools

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. …